SQLite Forum

select * from t; -- but don't want virtual columns
Login
Chronological Hierarchical 
You're right. It should probably be

  select group_concat(name, ', ') from
  (select name from pragma_table_xinfo 
  where schema == :schema and arg == :tablename and hidden == 0 order by cid);

although I'd like Keith to confirm that.