> Also column type is not strict and you can write strings into integer column.

FYI, as of late 2021, you can opt into strictness.

https://sqlite.org/stricttables.html