Taragolis commented on issue #28723:
URL: https://github.com/apache/airflow/issues/28723#issuecomment-1371092680

   Migrate 2.0 to 1.4 potentially could have more effect rather than we have 
with other packages.
   Some of dependency of providers also use SQLAlchemy and we need to wait 
until them migrate to 2.0
   
   Current  packages which explicit have SQLAlchemy as dependency from CI image.
   
   ```console
   root@6e6ad04bdb9b:/opt/airflow# pipdeptree --reverse --packages SQLAlchemy 
--python `which python`
   
   sqlalchemy==1.4.46
     - alembic==1.9.1 [requires: SQLAlchemy>=1.3.0]
       - apache-airflow==2.6.0.dev0 [requires: alembic>=1.6.3,<2.0]
     - apache-airflow==2.6.0.dev0 [requires: sqlalchemy>=1.4,<2.0]
     - elasticsearch-dbapi==0.2.9 [requires: sqlalchemy]
     - eralchemy2==1.3.6 [requires: SQLAlchemy>=1.3.19]
     - Flask-AppBuilder==4.1.4 [requires: SQLAlchemy<1.5]
       - apache-airflow==2.6.0.dev0 [requires: flask-appbuilder==4.1.4]
     - Flask-SQLAlchemy==2.5.1 [requires: SQLAlchemy>=0.8.0]
       - Flask-AppBuilder==4.1.4 [requires: Flask-SQLAlchemy>=2.4,<3]
         - apache-airflow==2.6.0.dev0 [requires: flask-appbuilder==4.1.4]
     - marshmallow-sqlalchemy==0.26.1 [requires: SQLAlchemy>=1.2.0]
       - Flask-AppBuilder==4.1.4 [requires: 
marshmallow-sqlalchemy>=0.22.0,<0.27.0]
         - apache-airflow==2.6.0.dev0 [requires: flask-appbuilder==4.1.4]
     - snowflake-sqlalchemy==1.4.4 [requires: sqlalchemy>=1.4.0,<2.0.0]
     - sqlalchemy-bigquery==1.5.0 [requires: sqlalchemy>=1.2.0,<2.0.0dev]
     - sqlalchemy-drill==1.1.2 [requires: sqlalchemy]
     - SQLAlchemy-JSONField==1.0.1.post0 [requires: sqlalchemy]
       - apache-airflow==2.6.0.dev0 [requires: sqlalchemy-jsonfield>=1.0]
     - sqlalchemy-redshift==0.8.12 [requires: SQLAlchemy>=0.9.2,<2.0.0]
     - SQLAlchemy-Utils==0.39.0 [requires: SQLAlchemy>=1.3]
       - Flask-AppBuilder==4.1.4 [requires: sqlalchemy-utils>=0.32.21,<1]
         - apache-airflow==2.6.0.dev0 [requires: flask-appbuilder==4.1.4]
   ```
   
   This is not complete list because some of packages could use sqlalchemy but 
do not have it in dependency, for example `pandas` use it in 
[read_sql](https://pandas.pydata.org/docs/reference/api/pandas.read_sql.html#pandas-read-sql).
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to