Modern SQLite: Generated Columns

You can index the json expression directly, but yes it's convenient.

Also the intent was probably to store JSON as BSON blob for faster access, but the example needs to insert jsonb('jsonstring') to achieve that. Rest of the example can stay unchanged.

SQLite has exceptionally readable documentation, I recommend just reading whole relevant chapter before using some functions.

Thanks for this blog "Moder SQL". I am trying to catch up with the last capabilities of sqlite, and man there are a lot of new things !