logoalt Hacker News

Pipelined Relational Query Language, Pronounced "Prequel"

37 pointsby dmitlast Saturday at 12:02 PM20 commentsview on HN

Comments

deweytoday at 3:28 PM

Every time I see these layers on top of SQL I think: Just use regular, boring SQL

It will be around for a long time, there's an infinite number of resources and examples for it and if you ever have to onboard someone into your code they don't need to learn something new. You can get pretty far by just using CTEs to "pipeline".

show 2 replies
bob1029today at 3:23 PM

"Pipelined" SQL already exists in the form of common table expressions. I don't know of any providers where this is not available. SQLite has had support since 2014.

show 1 reply
Taikonerdtoday at 1:00 PM

Google's "pipe syntax" is a similar idea: [0]

It's not as elegant as PRQL, because of course it's bolted onto the existing SQL syntax, rather than a redesign from scratch. But it has a big name behind it, and it's actually running in prod in Google Cloud... so it might have more momentum.

[0]: https://cloud.google.com/blog/products/data-analytics/simpli...

Taikonerdtoday at 12:57 PM

Is this project stalling out? The last post on the "posts" page is from March 2023. But the last commit to the git repo was last week...

show 1 reply
hbarkatoday at 3:02 PM

Procedural language fanatics have been trying for years to overturn the best declarative language for relational data.

show 2 replies
latexrlast Saturday at 12:14 PM

The title of the submission is literally the first line on the website.

I always find that funny. If you have to provide a pronunciation guide for your product, perhaps consider a different name. I guarantee you’ll still have people pronouncing each individual letter, either because they don’t know or because it’ll be less ambiguous.

show 3 replies