v.21.8Improvement

Support LowCardinality, Decimal, and UUID for JSONExtract

Support LowCardinality, Decimal, and UUID for JSONExtract. Closes #24606. #25900 (Kseniia Sumarokova).
Support for extracting LowCardinality, Decimal, and UUID data types using the JSONExtract function in ClickHouse.

Why it matters

This feature enables users to directly extract and parse JSON fields as LowCardinality, Decimal, and UUID types, expanding the versatility of JSON data handling and improving query precision and performance when working with these data types.

How to use it

Use the JSONExtract function with the desired data type specified, for example:

SELECT JSONExtract(json_column, 'field_name', 'LowCardinality(String)') FROM table;

This works similarly for Decimal and UUID types by specifying the appropriate type name.