11 ms·
I actually mostly agree with you, except for the fact that in reality SQL is not a language, but a family of languages, some of which don't support the syntax[1
by ainar-g 6y ago
I actually mostly agree with you, except for the fact that
in reality SQL is not a language, but a family of languages,
some of which don't support the syntax[1], including Google's
own BigQuery. Whether or not this is a reason to create
a completely new unrelated language is still up for a debate.
Tangentially related, but does anybody know of a program
or a library that takes standard SQL queries as input
and outputs one or multiple equivalent queries using the SQL
dialects of a set of DBMSs? That is, compiles a standard
SQL query into a PostgreSQL one, an SQLite one, etc.
[1]: https://modern-sql.com/feature/values#compatibility https://modern-sql.com/feature/values#compatibility
- layer8 6y ago> does anybody know of a program or a library that takes standard SQL queries as input and outputs one or multiple equivalent queries using the SQL dialects of a set of DBMSs? There are a number of tools that translate queries between SQL dialects. Google for “sql dialect translator”.
- ainar-g 6y agoThe thing is, most of them translate between dialects of SQL excluding Standard SQL, which is both more and less than what I would like to have. I don't want the ability to turn PostgreSQL SQL into SQLite SQL, but I do want the ability to turn Standard SQL into both of these. I guess, that will remain an idea for a hobby project, heh.