Pivot does not work with Prepared Statement

[arontsang]

What happens?

throws Error: Invalid Error: Cannot prepare multiple statements at once!

Same issue as duckdb/duckdb#7720

To Reproduce

    const connection = await this.database.connect();

    await connection.query('CREATE TABLE Cities(Country VARCHAR, Name VARCHAR, Year INT, Population INT)')
    const statement = connection.prepare('PIVOT Cities ON Year USING SUM(Population);');

Browser/Environment:

Chrome

Device:

PC

DuckDB-Wasm Version:

1.28.1-dev106.0
1.28.0

DuckDB-Wasm Deployment:

n/a

Full Name:

Aron Tsang

Affiliation:

N/A