Comment by bruce_one

You're looking for [strict tables](https://www.sqlite.org/stricttables.html) and they do already exist :-)

Added in 3.37.0 (2021-11-27), apparently :-)