<https://github.com/0x09/sqlite-statement-vtab/> gives you essentially parameterized VIEWs (but with an optimization boundary).
<https://github.com/0x09/sqlite-statement-vtab/> gives you essentially parameterized VIEWs (but with an optimization boundary).