v.21.4Improvements

Add aliases simpleJSONExtract/simpleJSONHas to visitParam/visitParamExtract functions

Add aliases simpleJSONExtract/simpleJSONHas to visitParam/visitParamExtract{UInt, Int, Bool, Float, Raw, String}. Fixes #21383. #21519 (fastio).
Added new aliases simpleJSONExtract and simpleJSONHas as alternatives to visitParam and visitParamExtract{UInt, Int, Bool, Float, Raw, String} functions for JSON data extraction.

Why it matters

This feature provides simpler and more intuitive function names for extracting values from JSON using the visitParam mechanism, improving usability and code readability while maintaining existing functionality. It addresses user feedback to make JSON extraction functions easier to understand and use.

How to use it

Use the new aliases simpleJSONExtract and simpleJSONHas in your queries as drop-in replacements for visitParam and visitParamExtract{UInt, Int, Bool, Float, Raw, String}. For example:

SELECT simpleJSONExtract(your_json_column, 'key') FROM your_table;


These functions can be used in the same contexts as the original visitParam functions without additional configuration.