The main advantage being more concise syntax?
Comment on Is there something better than SQL?
r1veRRR@feddit.de 8 months ago
I’d recommend everyone check out prql-lang.org. It’s SQL, but readable and writable in a sane way.
And no, SQL is NOT readable or writable for anything involving more than a single join.
Sigmatics@lemmy.ca 8 months ago
BehindTheBarrier@programming.dev 8 months ago
I’m not too much of a fan of the SQL equivalent of SELECT not being at the top. Granted I’m fairly sure there are some arguments for it, since select is optional there’s a higher mental load trying to figure out what is actually being returned imo. At least from looking at for the first time.
On the other hand, i’d kill for f-strings, the top N in group (which is nigh unreadable in SQL), and null handling that doesn’t require me to write either COALSECE or NVL too often. The joins were a little less pretty though, I’m quite fond of normal SQL joins since they are very reasonable unless chained beyond the line count your screen can show.
luckystarr@feddit.de 8 months ago
You can write selects with many joins, as long they are regular and either add a column or reduce the result set. You have to write the joins explicitly though. Just shoving all of the restrictions into the where clause will definitely confuse everybody.
BitSound@lemmy.world 8 months ago
I’m pretty excited about PRQL. If anything has a shot at replacing SQL, it’s something like this (taken from their FAQ):