> That's sad though because SQLite is really missing a lot of features that PostgreSQL has.

It is, but luckily it's not standing still. It's added JSON support and window functions in recent years for example.