fix: sqa deprecations for airflow providers
related: #28723
fix deprecations for SQLAlchemy 2.0 for Airflow providers.
FAB SQLAlchemy 2.0 is changing the behavior when an object is being merged into a Session along the backref cascade. The User needs to be present in the session before it is merged with backref cascade for relationship Role.user.
Openlineage Removed the sqlalchemy_engine completely. First of all in SQLAlchemy 2.0 the ability to associate an Engine with MetaData object is removed, second IMO the sqlalchemy_engine is not used at all in the function. It is passed to MetaData but not used afterwards.
Reported in providers
- [x] airflow/providers/openlineage/utils/sql.py:152
- [x] airflow/providers/fab/auth_manager/security_manager/override.py:1509
^ Add meaningful description above
Read the Pull Request Guidelines for more information.
In case of fundamental code changes, an Airflow Improvement Proposal (AIP) is needed.
In case of a new dependency, check compliance with the ASF 3rd Party License Policy.
In case of backwards incompatible changes please leave a note in a newsfragment file, named {pr_number}.significant.rst or {issue_number}.significant.rst, in newsfragments.