[BUG] JSQLParser 4.6 : postgresql : Encountered unexpected token: "QUALIFY" <S_IDENTIFIER>

[young0098]

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

• Encountered unexpected token: "QUALIFY" <S_IDENTIFIER>

SQL Example:

• Simplified Query Example, focusing on the failing feature

  -- QUALIFY ROW_NUMBER() OVER (PARTITION BY A.ID ORDER BY B.date_field DESC) = 1

INSERT INTO table1
SELECT * FROM first_table A
LEFT JOIN second_table B
ON A.ID = B.ID_User
QUALIFY ROW_NUMBER() OVER (PARTITION BY A.ID ORDER BY B.date_field DESC) = 1

```

Software Information:

• JSqlParser 4.6
• PostgreSQL

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.