v.25.8Improvement
System.columns table now provides column as
Thesystem.columnstable now providescolumnas an alias for the existingnamecolumn. #84695 (Yunchi Pang).
Why it matters
This feature improves the readability and usability of thesystem.columns table by providing a more intuitive alias, column, for the name column. It helps users better understand the data structure and aligns with common terminology when referring to column names.How to use it
Users can query thesystem.columns table using either column or name to retrieve column names. For example:SELECT column, type FROM system.columns WHERE table = 'your_table'