SQLite: How to get a list of column names

Question

It is possible to get a row with all column names of a table like this:

|id|foo|bar|age|street|address|

id dont like to use "Pragma table_info(bla)"

Thanks.

Answer 1

SELECT sql FROM sqlite_master
WHERE tbl_name = 'table_name' AND type = 'table'

Then parse this value with Reg Exp (it's easy) which could looks similar to this: "[(.*?)]"