SQLite has a solution for this! There's called strict tables and final SQLite to get mad at you when you try to put a string into a number column, etc.

https://www.sqlite.org/stricttables.html