We flatten it to a map and store the map. When you query, we dynamically generate ClickHouse query that queries the map.
If the JSON is nested, how do you put it the map?
Since map key is one type, how do you handle multiple types of values?
we flatten nested JSONs too. Not sure what you meant by second question, can you rephrase or provide an example? Also, feel free to drop me an email or join slack[1]- it will be easier to discuss tech details there.