is there a query that can be run against 2.8.x and 3.x dbs that will return something like
tablename | fieldname | fieldname | fieldname
SELECT tbl_name FROM sqlite_master WHERE type='table';
to get the table list and
PRAGMA table_info(tbl_name);
to return field info for each table.
AFAIK, there is no way to do it in a single query.
Regards, ~Nuno Lucas