there is a strict mode https://sqlite.org/src/wiki?name=StrictMode