Fixes #701: Add the OVER clause and include it in the Function tokens.

andialbrecht / sqlparse

A non-validating SQL parser module for Python

BSD 3-Clause "New" or "Revised" License

3.63k stars 685 forks source link

Fixes #701: Add the OVER clause and include it in the Function tokens. #768

Closed r33s3n6 closed 2 months ago

r33s3n6 commented 3 months ago

Resolves #701

[x] ran the tests (pytest)
[x] all style issues addressed (flake8)
[x] your changes are covered by tests (N/A) your changes are documented, if needed

Group tokens such as OVER exist_win or OVER (PARTITION BY...) as the OVER clause before grouping Identifier and Function. Extend tokens of Function to include the OVER clause if it is next to the Parenthesis of function parameters.

andialbrecht commented 2 months ago

Thanks a lot!