JSON Builtins Over Columnstore

The SingleStore database has improved its support for JSON data, using a columnar format called Parquet2 to store and query JSON documents efficiently. This enables the use of built-in functions such as JSON_EXTRACT, which can extract values from JSON documents at specific keypaths without having to read the entire document. The JSON_MATCH_ANY function allows filtering on properties within JSON arrays, while the JSON_INCLUDE_MASK function constructs a sub-JSON containing a subset of keys. These optimizations are made possible by the design of SingleStore-encoded Parquet, which achieves high compression and efficient data access through techniques such as striping and bit-packing. Performance tests demonstrate significant reductions in query latency for queries that would otherwise require reading and reconstructing entire JSON documents.