See [](https://github.com/0x09/sqlite-statement-vtab/blob/master/statement_vtab.c) from [this post](https://github.com/0x09/sqlite-statement-vtab/blob/master/statement_vtab.c) Another classic one would be a Pivot VTab, like [this one](https://github.com/jakethaw/pivot_vtab)