#3014
seems not working

The BOM in this file is not actually valid. The BOM has to be the first three bytes of the file. The first byte of the file is the quote instead. If we modify the file so the BOM is actually at the start this works as expected:

"id","name"
"1","Alice"
"2","Bob"

SELECT id FROM '~/Downloads/people.csv';
┌───────┐
│  id   │
│ int64 │
├───────┤
│     1 │
│     2 │
└───────┘

You can also use normalize_names to drop special characters from the column names:

SELECT id FROM read_csv_auto('~/Downloads/people.csv', normalize_names=True);
┌───────┐
│  id   │
│ int64 │
├───────┤
│     1 │
│     2 │
└───────┘

Thanks ! normalize_names works perfectly

I think the behaviour of how duckdb (read_csv) handles BOM should be explicitly documented.
I searched for a long time before I stumbled on normalize_names.
Actually appears to drop BOM with default normalize_names = false