v.21.6Improvement

Add Aliases for simpleJSONExtract and simpleJSONHas in visitParam Functions

Official CH changelog text
Add aliases simpleJSONExtract/simpleJSONHas to visitParam/visitParamExtract{UInt, Int, Bool, Float, Raw, String}. Fixes #21383. #21519 (fastio).
Added new alias functions simpleJSONExtract and simpleJSONHas as alternatives to the existing visitParam and visitParamExtract{UInt, Int, Bool, Float, Raw, String} functions for JSON extraction in ClickHouse.

Why it matters

These aliases provide a simpler and more intuitive naming for JSON extraction functions, improving code readability and addressing user confusion around the existing function names. This enhancement resolves issue #21383.

How to use it

Users can replace calls to visitParam and visitParamExtract{UInt, Int, Bool, Float, Raw, String} with their new aliases simpleJSONExtract and simpleJSONHas directly in their SQL queries without changing any other syntax or functionality.

Related resources

PreviousNext