Re:Hctree is an experimental high-concurrency database back ...
by hot_gril on Thursday January 19, 2023 @05:36PM
(#34446651)
But raw SQL made for Postgres doesn't necessarily work for SQLite and vice versa. That's what I mean by the SQL standard being thrown out the window. You might be able to write SQL that works in both if you're careful and avoid a lot of features.
In the case of JDBC and ODBC (and I think DB-API) thats all they do.