Support SQLAlchemy 1.4+ #204
Description
Thanks for stopping by to let us know something could be better!
Is your feature request related to a problem? Please describe.
SQLAlchemy 1.4 has been released quite a while ago (November 2020) and it has mutliple improvments. Major applications has already moved to SQLAlchemy 1.4. For example Apache Airflow switched to 1.4+ a week ago: apache/airflow#22114
This is also advised in https://www.sqlalchemy.org/download.html
Please note: the 1.3 series is the current "Maintenance" series. Updates for critical fixes will be made available as needed, but applications which continue to be under active development are advised to begin upgrading to the current series of SQLAlchemy (currently the 1.4 series).
Lack of SQLAlchemy 1.4 support blokcs for example Apache Airflow Google Provider from adding spanner sqlalchemy support in Airflow Google Provider: apache/airflow#21890 (comment)
Describe the solution you'd like
SQLalchemy 1.4 should be supported.
Describe alternatives you've considered
The alternative is to not add spanner sqlalchemy suport to Google Provider for Apache Airflow (which also prevents Composer from Google from supporting it).
Additional context
SQLallchemy spanner support is not strictly necessary for Google Provider but it would be great to add it.