v.23.4Improvement
Add aliases name and part_name for system.parts and system.part_log
Add aliasesnameandpart_nameformsystem.partsandsystem.part_log. Closes #48718. #48850 (sichenzhao).
Why it matters
This feature improves usability and consistency by providing common, intuitive column aliases for referring to part names in system tables, making it easier for users to query and understand the data related to parts and part logs.How to use it
Users can access the new aliasesname and part_name directly in SELECT queries on system.parts and system.part_log. For example:SELECT name, part_name, other_columns FROM system.parts;