Comment by orlp 2 years ago QUALIFY is not part of the SQL standard. 4 comments orlp Reply da_chicken 2 years ago I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it. orlp 2 years ago I don't know, and I don't feel like paying $200 per chapter to find out. riku_iki 2 years ago more importantly you can run prql on Postgres today, but can't use qualify yet gigatexal 2 years ago Then a subselect with the window function and an outer where clause where the window function column = 1
da_chicken 2 years ago I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it. orlp 2 years ago I don't know, and I don't feel like paying $200 per chapter to find out. riku_iki 2 years ago more importantly you can run prql on Postgres today, but can't use qualify yet
gigatexal 2 years ago Then a subselect with the window function and an outer where clause where the window function column = 1
I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it.
I don't know, and I don't feel like paying $200 per chapter to find out.
more importantly you can run prql on Postgres today, but can't use qualify yet
Then a subselect with the window function and an outer where clause where the window function column = 1