DuckDB Struct parameter example

[jhgoodwin]

Hi,

Tried to look through the unit tests, docs, and samples, but did not see (maybe I was blind) how to create a parameter for a struct. In my case, specifically, I have an array of struct for the column.

Looking at ClrToDuckDBConverter, it doesn't seem to support this style of conversion. Do you have advice?

If it's not possible, I could use a detail table, but I was experimenting to see if I could avoid the join.

[Giorgi]

Binding Struct parameters isn't supported at the moment, and I can't say when/if it will be supported. If you are interested in it, you can PInvoke duckdb_create_struct_value function and I can add support for accepting arbitrary duckdb_value-s as a parameter value.

[jhgoodwin]

Your offer is generous. I think for now, I will use the well understood path until my project is a bit further along. Thank you for your work and support.

[Giorgi]

I'll leave this issue as open, in case others are interested in Struct parameter support.