Add SQL/JSON Standard Support in ClickHouse

Why it matters

This feature introduces compliance with a portion of the SQL/JSON standard to improve interoperability and make JSON data querying more standardized and efficient within ClickHouse. It addresses the need for users to work with JSON data using familiar SQL/JSON syntax, thus simplifying JSON data processing and integration.

How to use it

Users can leverage the new SQL/JSON functions and operators introduced as part of this update by using standard SQL/JSON expressions within their SELECT queries. Refer to the updated documentation for specific supported functions and syntax to integrate JSON data handling in your queries.