Clickhouse's revised JSON type is still quite new (in beta currently), but I'm hopeful for it. Their first attempt fell apart if the schema changed.

[1] https://clickhouse.com/blog/a-new-powerful-json-data-type-fo...