v.18.16Improvement

Added Synonyms and Enhanced Syntax for SQL Functions in ClickHouse

Official CH changelog text
Added synonyms for the POWER, LN, LCASE, UCASE, REPLACE, LOCATE, SUBSTR, and MID functions. #3774 #3763 Some function names are case-insensitive for compatibility with the SQL standard. Added syntactic sugar SUBSTRING(expr FROM start FOR length) for compatibility with SQL. #3804
Added synonyms for common functions including POWER, LN, LCASE, UCASE, REPLACE, LOCATE, SUBSTR, and MID, enhancing SQL compatibility. Introduced case-insensitive function names and the syntactic sugar SUBSTRING(expr FROM start FOR length) for string extraction.

Why it matters

This feature improves compatibility with the SQL standard by allowing users to use common synonyms and case-insensitive function names. It simplifies queries and reduces friction when migrating SQL code to ClickHouse by supporting familiar function names and syntax forms.

How to use it

Users can now invoke functions using their new synonyms and in any case without affecting execution. Additionally, the syntax SUBSTRING(expr FROM start FOR length) can be used as an alternative to SUBSTR/MID for substring extraction, enhancing readability and compatibility.

Related resources

PreviousNext