[Bug]: DDL includes unsupported parameter passed as postgresql_*

[jobh]

What happened?

I have a table definition with an explicit index

        Index("ix_track_id_covering", id, unique=True,
              postgresql_include=["mmsi", "from_timestamp", "to_timestamp"]),

where the INCLUDE directive should only be generated on postgresql.

With duckdb_engine, I get an error:

E               sqlalchemy.exc.ProgrammingError: (duckdb.duckdb.ParserException) Parser Error: syntax error at or near "INCLUDE"
E               [SQL: CREATE UNIQUE INDEX ix_track_id_covering ON track (id) INCLUDE (mmsi, from_timestamp, to_timestamp)]

which indicates that postgresql_include is not ignored as it should.

DuckDB Engine Version

0.11.2

DuckDB Version

0.10.1

SQLAlchemy Version

1.4.48

Relevant log output

No response

Code of Conduct

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

[jobh]

Similar issue for

postgresql_ops={"destination": "varchar_pattern_ops"})

with error

E               sqlalchemy.exc.NotSupportedError: (duckdb.duckdb.NotImplementedException) Not implemented Error: Index with opclass not supported yet!
E               [SQL: CREATE INDEX ix_voyage_destination ON voyage (destination varchar_pattern_ops)]

[jobh]

...and

    __table_args__ = (
        {
            "postgresql_partition_by": "RANGE (moving, num_idx)",
        },
    )

↓

E               sqlalchemy.exc.ProgrammingError: (duckdb.duckdb.ParserException) Parser Error: syntax error at or near "PARTITION"