Support new methods in SQLAlchemy 2.0

[huw0]

SQLAlchemy 2.0 was released in January and the documentation indicates a number of new functions.

clear_cache
get_materialised_view_names
get_multi_check_constraints
get_multi_columns
get_multi_foreign_keys
get_multi_indexes
get_multi_pk_constraint
get_multi_table_comment
get_multi_table_options
get_multi_unique_constraints
has_index
has_schema
sort_tables_on_foreign_key_dependency

Clearly not all of these are relevant in the context of Impala, but it would be good to stub these functions so that Impala can be used by SQLAlchemy applications that assume these functions are implemented.

Additionally please include the version of SQLAlchemy in the README.

[lazyhope]

With the new SQLAlchemy 2.0 version ImpalaDialect.get_columns is broken, since connection.execute('plain_text') is deprecated and should be replaced with connection.execute(text('plain_text')) where text is imported from sqlalchemy, so this line would fail:

impyla/impala/sqlalchemy.py

Line 264 in 747e1da

cursor = connection.execute(query)

[s1lvester]

This is also related:

TypeError: has_table() got an unexpected keyword argument 'info_cache'

which stems from here:

impyla/impala/sqlalchemy.py

Line 231 in 747e1da

def has_table(self, connection, table_name, schema=None):

Versions used:

• impyla: v0.19.9
• sqlalchemy: 20.0.29
• python: 3.9.18

[frbelotto]

Any solution on it?

[csringhofer]

With the new SQLAlchemy 2.0 version ImpalaDialect.get_columns is broken, since connection.execute('plain_text') is
deprecated and should be replaced with connection.execute(text('plain_text')

This seems fixed in #538

Additionally please include the version of SQLAlchemy in the README.

Currently SQLAlchemy related tests run with v2 for Python 3.* and v1 with Python2.*, so to some degree both are tested.

I used SQLAlchemy only briefly, so inputs are welcome in this area, for example what to add to https://github.com/cloudera/impyla/blob/master/impala/tests/test_sqlalchemy.py to catch these issues