AttributeError: 'Engine' object has no attribute 'cursor' in to_sql() -> _sql_item_exists(), newer versions of pandas (2.2.3)

[matthiasschuurmans]

When I run bcp.to_sql(), under the hood it runs _sql_item_exists(), which runs
res = pd.read_sql_query(sql=_qry, con=creds.engine)

This gives me an error with newer versions of pandas (I currently have 2.2.3) : AttributeError: 'Engine' object has no attribute 'cursor'.

I think it has to do with https://stackoverflow.com/a/77949093 , because if I change the code that produces the error to

with creds.engine.connect() as conn:
    res = pd.read_sql_query(sql=_qry, con=conn.connection)

It runs.

Thank you for your efforts!