[Bug]: Sequences not handling optional=True

[jobh]

What happened?

The Sequence(..., optional=True) construct instructs sqlalchemy to generate a SERIAL data type instead of an explicit sequence when the underlying database supports it.

duckdb does not support it, but nevertheless SERIAL is generated when optional=true.

Base = declarative_base()
class FakeModel(Base):  # type: ignore
    __tablename__ = "fake"

    id = Column(Integer, Sequence("fakemodel_id_sequence", optional=True), primary_key=True)

↓

sqlalchemy.exc.ProgrammingError: (duckdb.duckdb.CatalogException) Catalog Error: Type with name SERIAL does not exist!
Did you mean "real"?
[SQL: 
CREATE TABLE fake (
        id SERIAL NOT NULL, 
        PRIMARY KEY (id)
)

DuckDB Engine Version

0.11.2

DuckDB Version

0.10.1

SQLAlchemy Version

2.0.29

Relevant log output

No response

Code of Conduct

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