Structs not supported?

[EvanMachusak]

I am trying to use ADO.NET to query a table whose schema contains:

column_name: code column_type: STRUCT(coding STRUCT(code VARCHAR, display VARCHAR, "system" VARCHAR)[], sof_codes VARCHAR[], "text" VARCHAR)

I've tried every reasonable variation of select statement that should work to extract columns out of that struct, e.g.

SELECT code.coding.code FROM ...
SELECT code.* FROM ...

The data types in question for these columns are 24 and 25, which are not supported. This exception gets raised:

https://github.com/Giorgi/DuckDB.NET/blob/58a3bc90e5446ddfca998da5817ed115170fa202/DuckDB.NET.Data/DuckDBDataReader.cs#L122

These schemas come from parquet files, if that matters.

[Giorgi]

No, structs and lists aren't supported currently.

[EvanMachusak]

Would you entertain a PR for it?

[Giorgi]

I'll be happy to review it but I think you can't implement it without #77

[OneCyrus]

now that data chunks are implemented. any chance we get struct support?

[Giorgi]

Yes, I plan to work on adding struct support but first I plan to implement #135

[Giorgi]

• [ ] Allow setting naming convention for member names (camel case, pascal case, snake case).
• [ ] Allow custom naming convention for member names.
• [X] Use expression trees to set properties
• [X] Cache struct information for better performance

[Giorgi]

Structs are now working in the develop branch.

[Giorgi]

For now, I won't implement any naming customization.

[Giorgi]

Struct support is now live on NuGet

[EvanMachusak]

Thanks Giorgi. This is really great.