SQLite Forum

Indexing JSON array contents
Login
> use generated columns with table-valued functions, then you could create a STORED version of your EXISTS expression

More info here - [https://dgl.cx/2020/06/sqlite-json-support](https://dgl.cx/2020/06/sqlite-json-support) :)