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
alt Hacker News
If you think Postgres has idiosyncrasies…
https://sqlite.org/quirks.html