No matter how fast the parsing is — queries are going to be slow.
For example, on 1M rows table with very simple flat JSON values like these:
{"object": "user", "object_id": 10, "action": "login"}
Without index, this query is going to take 500ms or more: select * from events where json_extract(value, '$.object_id') = ?;
With index on json_extract(value, '$.object_id'), it is going to take 1ms.See for yourself: