What happens?

When connecting to duckdb via odbc driver in a php script I can't seem to run a pivot query it fails with:

Invalid Error: Cannot prepare multiple statements at once!

I know that many other drivers like jdbc also had this issue:

#3547
#7720

Is this something that is unsupported with odbc driver?

To Reproduce

Run a pivot query over odbc api using any odbc client

OS:

linux-x86

DuckDB Version:

10

DuckDB Client:

ODBC

Full Name:

asrar

Affiliation:

none

Have you tried this on the latest nightly build?

I have tested with a release build (and could not test with a nightly build)

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• Yes, I have