Unable to register a pandas.DataFrame with string columns in pandas 3 #278

What happens?

Pandas 3 introduced str datatypes. However trying to register() a pandas DataFrame that has such a column leads to a NotImplementedException

To Reproduce

import duckdb
import pandas as pd

df = pd.DataFrame({"str_col": ["alfred", "beatrix", "cranbrook", "deirdre"]})

print(df["str_col"])
con = duckdb.connect()
con.register("tab", df)

results in _duckdb.NotImplementedException: Not implemented Error: Data type 'str' not recognized.

OS:

MacOS

DuckDB Package Version:

1.4.3 (and 1.5.0.dev166)

Python Version:

3.13.3

Full Name:

Andrew Bond

Affiliation:

Ministry of Justice (UK)

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

I have tested with a nightly build

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

Yes

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