fetch_df(date_as_object=True) causes pandas warning about duckdb HOT 2 CLOSED

I'm pretty sure this is fixed, as I cant reproduce it on main

import duckdb
query="""
	select
		id,
		dt::date as dt
	from (
		VALUES
			(1, '2023-08-01'),
			(2, '2023-09-03')
		)
	as f (id, dt)
"""
df = duckdb.execute(query).fetch_df(date_as_object=True)
print(df)

   id          dt
0   1  2023-08-01
1   2  2023-09-03

from duckdb.

Just for completeness:

I was seeing this for df() on 0.9.2 (pandas 2.2.0) even without specifying date_as_object.

Upgrade to 0.10.1 fixed it ✅

from duckdb.