I've used Postgres a lot more and for more complex queries than SQLite, and have never encountered nor heard of a query semantics bug with it (though I'm sure t

I've used Postgres a lot more and for more complex queries than SQLite, and have never encountered nor heard of a query semantics bug with it (though I'm sure they exist). I know that is total anecdata, but my experience with Postgres is – whether thanks to more collective query hours, better testing methodology, or simply higher quality design – an experience that leads me to trust it more than SQLite.