Open l1xnan opened 4 months ago
In my experience with another client api, this was resolved by using the duckdb_query() c api function which will create a materialized result. When using the arrow api it will run with the similar duckdb_query_arrow() which is used with execute_batch(). However execute_batch does not return the result. I think if execute_batch was modified to return the output or a new query() function was add to the Connection then it would work.
Executing the pivot statement results in the following error:
It may be related to https://github.com/duckdb/duckdb/issues/7720