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).
Introduces the prefer_column_name_to_alias setting that allows users to prefer original column names over aliases in query results, improving compatibility with common database aliasing behavior.

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 setting prefer_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.