values() creates one row of arrays instead of multiple rows

[memeplex]

What happens?

I believe this behavior is a bug and not actually intended, but I may be wrong.

duckdb.values([(10, 'A'), (20, 'B')]) produces a table with one row of VARCHAR[] values, instead of a table with two rows and two columns with different types.

Other alternatives like:

• duckdb.values((10, 'A'), (20, 'B'))
• duckdb.values("(10, 'A'), (20, 'B')")

just fail.

To Reproduce

duckdb.values([(10, 'A'), (20, 'B')]).df()

OS:

macOS Tahoe

DuckDB Package Version:

1.5.1

Python Version:

3.12.13

Full Name:

Carlos

Affiliation:

Mutt

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

No - Other reason (please specify in the issue body)

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration to reproduce the issue?

• Yes, I have