How to get a list of column names

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: [(.*?)]

Alternatively you can use:

PRAGMA table_info(table_name)