Does this trick work with foreign keys? Like, if you have an ON CASCADE DELETE, does it delete a bunch of rows in other tables when converting the table to strict?
That's the pattern recommended by SQLite here: https://www.sqlite.org/lang_altertable.html#otheralter