News for hackers. Stuff that matters.

A comment on SQL: 2023 is finished: Here is what's new. Parent comment

Re:SQL: 2023 is finished: Here is what's new by candiddevmike on Thursday April 13, 2023 @09:40PM (#35564525)
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.

If someone knows a tool that reliably converts PostgreSQL queries to something like SQLite, please share!

[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by TylerE on Thursday April 13, 2023 @10:15PM (#35564722)
Not sure how such a tool could possibly exist, given all the functionality of Postgres that SQLite simply lacks.
[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by steve_gh on Friday April 14, 2023 @01:31AM (#35565845)
You could ask ChatGPT to do this sort of conversion
[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by TylerE on Friday April 14, 2023 @01:36AM (#35565865)
Still not going to have wave around things like not having transactions or proper trigger functions.
[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by hnlmorg on Friday April 14, 2023 @03:33AM (#35566577)
SQLite does have transactions. But I do agree with your general point that Sqlite is worlds apart from Postgre
[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by alserio on Friday April 14, 2023 @02:03AM (#35566027)
haven't really tried for that transform but have a look at https://www.jooq.org/translate/
[ Parent | on HN ]
Re:SQL: 2023 is finished: Here is what's new by snthpy on Saturday April 15, 2023 @03:09AM (#35578343)
sqlglot might be what you are looking for.

https://github.com/tobymao/sqlglot

[ Parent | on HN ]