4 ms·

Maybe as a baby step we could just get legal trailing commas

• candiddevmike 4y ago
  Or force the big RDBMS to use the same syntax like SQL was intended to be, so I don't have to reach for an ORM or maintain different flavors of the same query. As an aside, if someone knows a tool that reliably converts PostgreSQL queries to something like SQLite, please share!
  • alserio 4y ago
    haven't really tried for that transform but have a look at https://www.jooq.org/translate/ https://www.jooq.org/translate/
  • TylerE 4y ago
    Not sure how such a tool could possibly exist, given all the functionality of Postgres that SQLite simply lacks.
    • steve_gh 4y ago
      You could ask ChatGPT to do this sort of conversion
      • TylerE 4y ago
        Still not going to have wave around things like not having transactions or proper trigger functions.
        • hnlmorg 4y ago
          SQLite does have transactions. But I do agree with your general point that Sqlite is worlds apart from Postgre
  • snthpy 4y ago
    sqlglot might be what you are looking for. https://github.com/tobymao/sqlglot https://github.com/tobymao/sqlglot
• deleted 4y ago
  [deleted]