[ramraj07]

Great to see it in ClickHouse.

Snowflake released a white paper before its IPO days and mentioned this same feature (secretly exploding JSON into columns). Explains how snowflake feels faster than it should, they’ve secretly done a lot of amazing things and just offered it as a polished product like Apple.

[leetrout]

Scratch data does this as well with duckdb

https://github.com/scratchdata/scratchdata

[nojvek]

Singlestore has been doing json -> column expansion for a while as well.

https://www.singlestore.com/blog/json-builtins-over-columnst...

For a colstore database, dealing with json as strings is a big perf hit.

[statictype]

Do you have a link to the Snowflake whitepaper?

[JosephRedfern]

Perhaps this: https://event.cwi.nl/lsde/papers/p215-dageville-snowflake.pd...