Inference for column names and datatypes seems only relevant for csv? Other formats convey that metadata, as e.g. parquet...

csv metadata inference in duckdb is amazing. There is some research in this domain and duckdb does a great job there, but yes there might be some really strange csv files, which require manual intervention.