Are you using transactions in any way? Either explicitly, with `BEGIN` statements in your scripts, or perhaps created "automatically" by whatever layer your script uses to talk to SQLite? (I believe some Python wrappers are notorious for creating "unexpected" transactions). Not sure whether that would explain the difference between `PRAGMA tableinfo` and the `SELECT * FROM pragma_table_info`, but might be helpful in tracking down what's happening.