[Bug]: inspect.get_pk_constraint() not supported

[SoumayaMauthoorMOJ]

What happened?

inspect.get_pk_constraint( not supported

import sqlalchemy
engine = sqlalchemy.create_engine('duckdb:///:memory:')
metadata = sqlalchemy.MetaData(engine)
user_id_seq = sqlalchemy.Sequence('user_id_seq')
users_table = sqlalchemy.Table(
     'users',
     metadata,
     sqlalchemy.Column(
         'id',
         sqlalchemy.Integer,
         user_id_seq,
         server_default=user_id_seq.next_value(),
         primary_key=True,
     ),
 )
metadata.create_all(bind=engine)
insp = sqlalchemy.inspect(engine)
insp.get_pk_constraint('users', 'main')

returns:

{'constrained_columns': [], 'name': 'PRIMARY KEY(id)'}

when I expect it to return:

'constrained_columns': ['id']

DuckDB Engine Version

0.7.0

DuckDB Version

0.7.1

Relevant log output

No response

Code of Conduct

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