Is there an automatic CSharp -> DuckDB type mapping for parametrized queries?

[soerenwolfers]

If I run

        command.CommandText = "FROM '/myfile.parquet' WHERE Time == $time;";
        command.Parameters.Add(new DuckDBParameter("time", new DateTime(2020, 1, 6, 16, 55, 0)));

through duckdb.NET my query fails because the DateTime gets inserted into the query via .ToString().

Can I do something smarter than string-formatting the DateTime object myself to match DuckDBs expectations?

[Giorgi]

There is not much you can do as a user of the library but if you are willing to send a PR I can explain what needs to be changed to make it work.

[soerenwolfers]

Sorry, it's very unlikely I will. DuckDB.NET is very awesome for what I need, and I thank you for your work on it, so just a suggestion: would it make sense then to restrict the values of DuckDbParameters to strings? Adding ToString or whatever semantically more meaningful string conversion is required in user code is easy and at least then there won't be an illusion of conversion that turns out to be just a foot gun (especially since DuckDb->Csharp does do the opposite conversion).

[Giorgi]

@soerenwolfers This will be implemented in the next release in September.