v.23.4Improvement

Add aliases name and part_name for system.parts and system.part_log

Add aliases name and part_name form system.parts and system.part_log. Closes #48718. #48850 (sichenzhao).
Added aliases name and part_name to the system.parts and system.part_log tables.

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 aliases name 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;