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).
Why it matters
This feature addresses the limitation whereJSONExtractString 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 theJSONExtractString 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.