v.24.7Experimental Feature

Refactor JSONExtract Functions to Support More Types including Dynamic Type

Refactor JSONExtract functions, support more types including experimental Dynamic type. #66046 (Kruglov Pavel).
Refactor JSONExtract functions and extend support for additional types, including the experimental Dynamic type.

Why it matters

This feature improves the functionality of JSON extraction in ClickHouse by refactoring existing JSONExtract functions and adding support for a wider range of data types. It introduces an experimental Dynamic type to allow more flexible and dynamic handling of JSON data, solving limitations related to static type extraction and enhancing JSON processing capabilities.

How to use it

Users can leverage the updated JSONExtract functions in their queries as before, now with the ability to extract more data types from JSON strings. To use the new experimental Dynamic type, specify it in the function signature where applicable. Refer to the JSONExtract function documentation for syntax details.