It is not able to detect "January 10, 2012" as Date rather it is considering it as Varchar. Suggest a way to convert this to Date datatype in csv file data=duckdb.sql ...