Using PRAGMAs as sources in SQLite in getting column names
Since SQLite 3.16.0 we can use PRAGMA functions
sqlite> create table my_table (a int, b TEXT);sqlite> .headers ONsqlite> .mode columnssqlite> pragma table_info(my_table);cid name type notnull dflt_value pk---------- ---------- ---------- ---------- ---------- ----------0 a int 0 01 b TEXT 0 0sqlite> select name from pragma_table_info('my_table');name----------ab