[hans_castorp]

Might be related to the use of SQLite which doesn't really support data types to begin with and allows to store anything in a column regardless of the declared data type (e.g. you can store 'fourty two' in a column declared as integer).

Apparently it's a deliberate decision because they don't really want to be a "database" just something better then "a file".

[DougBTX]

Strict table support came in last year to help address this: https://www.sqlite.org/stricttables.html