v.25.4Improvement

Use insertion columns for INFILE schema inference

Use insertion columns for INFILE schema inference. #78490 (Pervakov Grigorii).
Add support for using insertion columns when inferring schema from INFILE data in ClickHouse.

Why it matters

This feature improves schema inference during data loading with INFILE by utilizing the actual columns specified in the insertion query, ensuring more accurate and reliable schema detection compared to previous methods.

How to use it

When loading data using INFILE, the schema inference will automatically consider the columns defined in the INSERT INTO statement. Users do not need to perform any additional configuration; the feature works transparently during data insertion.