Completely agree. I've had these same thoughts for a while now, but didn't bother writing them down. I'd also add to your list compatibility with other DBs, including of course SQLite's usual go-to for compatibility, PostgreSQL. This would make porting to SQLite easier. I know of at least one large commercial product swapping a client-server RDBMS backend in the enterprisey solution with SQLite for the *personal* edition of that same product, and it's also something I had in mind. Not having to work-around these types of differences would be a plus for SQLite.