Introducing {sqlitemeta} - a wrapper for sqlite-createtable-parser.
This pkg will parse a CREATE TABLE statement for sqlite and return a list of meta-information about the table.
It is also posslble to extract the CREATE TABLE statement from an existing sqlite db and do the same - a handy tool for understanding the structure of an existing db.
This is a bit niche, and will probable get rolled in to another sqlite project eventually(!)
Developer note: Nearly every single one of my projects has started with these 3 thoughts:
That'd be cool.
It can't be that hard.
It should only take me a few hours to do.
Then I spend the next month* riding the Dunning Kruger wave - realising there's so much I don't know that I don't know! - and thinking my past self a fool for ever thinking this was possible.