JSON and virtual columns in SQLite

https://antonz.org/json-virtual-columns/

Generated columns have another great use case.

tldr: index your generated columns, just as good as a nosql db!

alter table events
add column object_id integer
as (json_extract(value, '$.object_id'));

create index events_object_id on events(object_id)