It would be great if pragma_table_info(tablename) was allowed to be used in queries. See also https://github.com/simonw/til/blob/master/sqlite/list-all-columns-in-a-database.md

select * from pragma_table_info(tablename); is currently disallowed for user-provided queries via a regex restriction - but could help here too.

datasette/datasette/utils/__init__.py

Line 174 in d349d57

disallawed_sql_res = [(re.compile("pragma"), "Statement may not contain PRAGMA")]

Originally posted by @simonw in #760 (comment)