> 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”.
The 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.
There are a number of tools that translate queries between SQL dialects. Google for “sql dialect translator”.