[Warning] SADeprecationWarning: The dbapi() classmethod on dialect classes has been renamed to import_dbapi().

I'm using the library via SQLDatabase (from langchain_community.utilities)

Getting the following warning:

SADeprecationWarning: The dbapi() classmethod on dialect classes has been renamed to import_dbapi(). Implement an import_dbapi() classmethod directly on class <class 'pyathena.sqlalchemy.rest.AthenaRestDialect'> to remove this warning; the old .dbapi() classmethod may be maintained for backwards compatibility.

I think this here is where the change should be implemented:

PyAthena/pyathena/sqlalchemy/base.py

Line 1016 in cb90104

def dbapi(cls) -> "ModuleType": # type: ignore

Thanks!

#496