DuckDB sniff_csv function may be able to help here. https://duckdb.org/docs/stable/data/csv/auto_detection
sniff_csv
select distinct delimiter FROM sniff_csv('/some/file.csv', sample_size = 1000)