4 ms·
Does anybody just use "regular, boring SQL" in practice though? All queries I have seen are loaded with regex and other non-standard extensions. Is there even
by itishappy 8mo ago
Does anybody just use "regular, boring SQL" in practice though? All queries I have seen are loaded with regex and other non-standard extensions.
Is there even a db vendor that offers full ANSII SQL support? Last I'd checked the answer was no.
- dewey 8mo agoIn my case I consider Postgres / MariaDB "regular, boring SQL".
- itishappy 8mo agoThe 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.
- dewey 8mo agoI'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.
- itishappy 8mo agoUnderstood. 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.