PRQL, Pipelined Relational Query Language

Re:PRQL, Pipelined Relational Query Language by crote on Tuesday July 25, 2023 @05:02PM (#36869482)

The main issue with SQL is that you are stuck in a very strict way of writing things, which does not clearly match to how I think. The top-down way of writing PRQL where each step is simply a transformation of the previous one makes way more sense to me. SQL is something I'd need a reference manual for, PRQL is simply writing down what I want the query to do.

I do agree that PRQL's join syntax is extremely bad, though. They should've stuck to explicit "left join"-like keywords, and the alias & join column shorthand could be done better.

[ Parent | on HN ]

Re:PRQL, Pipelined Relational Query Language by appplication on Wednesday July 26, 2023 @12:17PM (#36880200)

Despite it not at all being the right tool for most jobs, this is why I actually enjoy writing spark. It reads top down, and is “sql-ish” for most commands. Enough that you don’t need to go out of your way to learn it if you already know SQL, you just think in terms of serial transformations.

[ Parent | on HN ]