SQLite has check constraints - and recent versions can have STRICT tables: https://www.sqlite.org/stricttables.html

It also has excellent JSON features - JSON maybe stored as text rather than a binary format like JSONB in PostgreSQL, but the SQLite JSON functions crunch through it at multiple GBs per second so it doesn't seem to matter.

Didn't know about strict tables, very cool!