[Bug]:Not implemented Error: currval/nextval requires a constant sequence - non-constant sequences are no longer supported

[xor2003]

What happened?

What does this error mean?

id_seq_name = "id_seq"
id_seq_journal = sqlalchemy.Sequence(f"{id_seq_name}_journal")  # Workaround for DuckDB SERIAL type issue
# https://github.com/Mause/duckdb_engine#auto-incrementing-id-columns

# Define the table
t_journal = Table(
    "journal",
    metadata,
    Column(
        "id",
        Integer,
        id_seq_journal,
        server_default=id_seq_journal.next_value(),
        primary_key=True,
        comment="id",
    ),


>               self.__c.execute(statement, parameters)

DuckDB Engine Version

0.13.0

DuckDB Version

1.0.0

SQLAlchemy Version

1.4.52

Relevant log output

duckdb.duckdb.NotImplementedException: Not implemented Error: currval/nextval requires a constant sequence - non-constant sequences are no longer supported

Code of Conduct

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

[xor2003]

It was working fine with duckdb 0.7.1 and 0.9.2