How to get column names from SQLite query?

Question

SQLite

How to get column names from SQLite query?
PRAGMA table_info(select * from table);
does not work, I don’t want to create a temporary table just for the sake of it, there should be a more elegant solution)

Answer 1

You can get DDL and then parse it.
SELECT * FROM sqlite_master