I'm in the same boat, the idiosyncrasies of postgres are real; mysql / sqlite are far more predictable.
If you think Postgres has idiosyncrasies…
https://sqlite.org/quirks.html
Which one is an issue?
No types, no foreign key enforcement, double–quoted string literals