v.21.4New Features
Add prefer_column_name_to_alias Setting for Enhanced Compatibility with Database Aliasing Rules
Add prefer_column_name_to_alias setting to use original column names instead of aliases. it is needed to be more compatible with common databases' aliasing rules. This is for #9715 and #9887. #22044 (Amos Bird).Why it matters
This feature addresses compatibility issues with aliasing rules by enabling users to retain original column names instead of automatically renaming them to their aliases. It helps users port queries more easily from other databases and ensures clearer, more consistent result column names.How to use it
Enable the feature by settingprefer_column_name_to_alias to 1 either in the session or query-specific settings. For example, use SET prefer_column_name_to_alias = 1 before executing queries to return original column names instead of aliases.