SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog
www.dbpro.app
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.