SQLite Forum

Maybe the pragma_table_info virtual table could implement some hidden columns, e.g.:

  SELECT cid,name,strictType,affinity FROM pragma_table_info('employees');

The strictType value for non-strict table would always be null.