SQLite’s type system could accurately be described as “there is no type system”. And the developers consider it a feature not a bug.

A recently added “STRICT” feature changes that. But it’s very rudimentary.