> Note that DuckDB automatically figured out how to parse the date column. It kinda did and it kinda didn't. Author got lucky that Transaction.csv contained a

> Note that DuckDB automatically figured out how to parse the date column. It kinda did and it kinda didn't. Author got lucky that Transaction.csv contained a date where the day was after the 12th in a given month. Had there not been such a date, DuckDB would have gotten the dates wrong and read it as dd/mm/yyyy. I think a warning from DuckDB would have been in order.