Re:Pipelined Relational Query Language, Pronounced "Prequel"
by dewey on Monday February 23, 2026 @12:10PM
(#47125207)
In my case I consider Postgres / MariaDB "regular, boring SQL".
Re:Pipelined Relational Query Language, Pronounced "Prequel"
by itishappy on Monday February 23, 2026 @05:36PM
(#47129983)
The problem persists, as Postgres and MariaDB use incompatible SQL dialects, right down to (imo) core concepts such as how to specify an automatically generated primary key.
Re:Pipelined Relational Query Language, Pronounced "Prequel"
by dewey on Tuesday February 24, 2026 @03:57AM
(#47134651)
I'm aware of that, but what I meant is that they both extended the SQL standard in a similar way and they will have equivalent higher level features like "regex and other non-standard extensions" even if they are not 100% drop-in replacements.
Re:Pipelined Relational Query Language, Pronounced "Prequel"
by itishappy on Tuesday February 24, 2026 @10:58AM
(#47138722)
Understood. My point is that the underlying concepts are consistent, but the syntax differs between vendors. This largely applies to PRQL as well. Admittedly slightly moreso, but if I already have to learn a new SQL dialect to use postgres, I might not mind learning a nicer one.
Is there even a db vendor that offers full ANSII SQL support? Last I'd checked the answer was no.