That's kind of the problem. The database absolutely should get in your way if you try to put nonsense data in it.

For the kinds of uses SQLite sees, the loose approach to data integrity may not have caused much grief, but I can't imagine many situations where it would have helped either.

Having support for enabling sane behaviour is welcome even if it has to be opt-in for compatibility.