v.25.8New Feature

Users can now do case-insensitive JSON key

Official CH changelog text
Users can now do case-insensitive JSON key lookups using JSONExtractCaseInsensitive (and other variants of JSONExtract). #83770 (Alistair Evans).
Users can perform case-insensitive JSON key lookups using the new function JSONExtractCaseInsensitive and its variants.

Why it matters

This feature enables more flexible and user-friendly JSON data extraction by allowing JSON keys to be matched without case sensitivity, solving the issue where keys differ in letter casing and enhancing query robustness.

How to use it

Replace existing JSONExtract calls with JSONExtractCaseInsensitive or its related variants to perform case-insensitive extraction of JSON keys in your queries. For example:

SELECT JSONExtractCaseInsensitive(json_column, 'KeyName', 'String') FROM table

Related resources

PreviousNext