SQLite did add 'STRICT' tables for type enforcement.

Still doesn't have a huge variety of types though.

The fact that they didn’t make STRICT default is really a shame.

I understand maintaining backwards compatibility, but the non-strict behavior is just so insane I have a hard time imagine it doesn’t bite most developers who use SQLite at some point.