Show HN: PRQL in PostgreSQL

Re:Show HN: PRQL in PostgreSQL by orlp on Monday February 19, 2024 @09:35AM (#39430138)

QUALIFY is not part of the SQL standard.

[ Parent | on HN ]

Re:Show HN: PRQL in PostgreSQL by da_chicken on Monday February 19, 2024 @10:51AM (#39431076)

I'm pretty sure QUALIFY was added in SQL 2023. Maybe it was only discussed and didn't make it.

[ Parent | on HN ]

Re:Show HN: PRQL in PostgreSQL by orlp on Monday February 19, 2024 @11:40AM (#39431760)

I don't know, and I don't feel like paying $200 per chapter to find out.

[ Parent | on HN ]

Re:Show HN: PRQL in PostgreSQL by riku_iki on Monday February 19, 2024 @03:37PM (#39434517)

more importantly you can run prql on Postgres today, but can't use qualify yet

[ Parent | on HN ]

Re:Show HN: PRQL in PostgreSQL by gigatexal on Monday February 19, 2024 @10:09AM (#39430549)

Then a subselect with the window function and an outer where clause where the window function column = 1

[ Parent | on HN ]