You could skip the VIRTUAL column and add an index directly using an expression index [1] with json_extract(). [1]: https://sqlite.org/expridx.html https://sql

You could skip the VIRTUAL column and add an index directly using an expression index [1] with json_extract(). [1]: https://sqlite.org/expridx.html https://sqlite.org/expridx.html