Why not store everything in a single json column but dynamically generate index files, so finding rows is fast?

Then you never have to change the data. Only the index files.