Show HN: PRQL in PostgreSQL

Re:Show HN: PRQL in PostgreSQL by gigatexal on Monday February 19, 2024 @08:39AM (#39429590)

select id from tracks qualify row_number() over partition by (album_id order by milliseconds desc) =1

That should work

Look I’m a diehard SQL just use it guy but open to improvements. But I’m loathe to use abstractions for things when the underlying thing is so expressive.

Autocomplete of fields in a good editor, schema help, etc go a long way to making SQL being written raw very nice.

[ Parent | on HN ]

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 ]