I did not realize that SQLite now has a pending feature called 'Strict Tables'[0][1]. Mindblowing. I can't wait to try using this in the wild.
> In a CREATE TABLE statement, if the "STRICT" table-option keyword is added to the end,
> after the closing ")", then strict typing rules apply to that table.
I'm guessing that addition is reason why this document was recently written and is a draft, I guess.
[0] https://www.sqlite.org/draft/flextypegood.html#if_you_insist...