I would add "limited json support" to this list. Under the hood, SQLite treats json as strings, you have to do some strange stuff with extract and computed fie

I would add "limited json support" to this list. Under the hood, SQLite treats json as strings, you have to do some strange stuff with extract and computed fields indexing to index into it, which can be a bit fragile. My use case these days is hybrid rdbms / nosql, where most of my tables have defined columns for frequently queried data, and a jsonb "data" field for everything else. Postgres has impressive jsonb capabilities, and with 14 the index operators making querying it a dream. I love SQLite, but postgres' jsonb handing makes the additional operational overhead worth it to me.