SQLite Forum

Does table have rowid?
It is an information leakage exposure, is my understanding.

Also, open a big database and execute `select * from pragma_integrity_check`.

Do you want someone to give you a database that has a view that selects from pragma_integrity_check?  Not setting the INNOCUOUS flag means that statements which execute pragmas must originate from your application (or have been put in the per connection temp table by your application) and cannot be put there by an external attacker for you to execute unbeknownst to you.