v.21.4Improvements
Add aliases simpleJSONExtract/simpleJSONHas to visitParam/visitParamExtract functions
Add aliasessimpleJSONExtract/simpleJSONHastovisitParam/visitParamExtract{UInt, Int, Bool, Float, Raw, String}. Fixes #21383. #21519 (fastio).
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 aliasessimpleJSONExtract 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.