Comment by zimmi

You can use strict tables: https://sqlite.org/stricttables.html