[Bug]: Support for Double (Float8) column type

[arambert]

What happened?

I'm trying to create a double (float8) column using sqlalchemy with Column(Double) or Column(Float(8)) but it creates every time only a float (float4) column.

Am I doing something wrong? Is the double (float8) type supported on column creation?

Note if relevant:
I'm using sqlmodel: the full field definition I'm using is Field(sa_column=Column(Double))

DuckDB Engine Version

0.13.5

DuckDB Version

1.4.2

SQLAlchemy Version

2.0.36

Relevant log output

Code of Conduct

• I agree to follow this project's Code of Conduct