Pivot not working

[ekanna]

Below query is not working but it is working in shell.duckdb.com
Doc at https://duckdb.org/docs/sql/statements/pivot.html

PIVOT cities
ON year
USING sum(population);

Why it is not working with this library? I am getting below error.

invalid Input Error: Cannot prepare multiple statements at once!

[era127]

That query will need to be executed using the duckdb_query or duckdb_query_arrow c api functions. The rust client api execute_batch will use the duckdb_query_arrow c api function, but unfortunately execute_batch doesn't return the result, so I dont know if its possible with the rust client api currently.

[l1xnan]

I also encountered this issue. For my specific use case, I made some modifications to the source code. It's not an official solution, but you can use it as a reference.
l1xnan@75a235f