v.21.11Improvements

Allow JSONExtractString to Extract Non-String Elements as Strings

Allow extracting non-string element as string using JSONExtractString. This is for pull/25452#issuecomment-927123287. #30426 (Amos Bird).
Allow JSONExtractString function in ClickHouse to extract non-string JSON elements by converting them to strings.

Why it matters

This feature addresses the limitation where JSONExtractString could only extract JSON string elements. Users can now extract non-string elements (such as numbers or booleans) as their string representation, improving JSON data processing flexibility.

How to use it

Use the JSONExtractString function as usual. When extracting a JSON element that is not a string, the function will return its string representation instead of failing or returning null.