Window Function With Parameter Parsed as Two Columns

[reata]

Now row_number() OVER ... and rank() OVER ... are handled. But window function like max(col) OVER ..., sum(col1) OVER ... will get wrong result.

[reata]

"ROW_NUMBER() OVER (PARTITION BY col1, col2) rn" will be parsed as <Function 'row_number'> + <Keyword 'OVER'> + <Identifier '(PARTITION BY col1, col2)'>, which is not desirable. I'll try to see if I can extend or monkey patch sqlparse by grouping these together to a a new 'Window' tokenlist.

Reference:

• sqlparse grouping/parsing functionality: https://github.com/andialbrecht/sqlparse/blob/master/sqlparse/engine/grouping.py#L387
• sqlglot window parsing implementation: https://github.com/tobymao/sqlglot/blob/main/sqlglot/parser.py#L1171