This is fantastic progress, Vincent and all the collaborators - I was mostly following and reviewing some of those, but this is huge when it comes to our dependency chain.
It will definitely allow us to seriously look at the reports we have now in our CI that are showing us outdated dependencies and the way we should handle them. The SQLA<2 was a huge blocker for us and freeing it will automatically resolve most of the "impossible to solve today" issues - leaving mostly those that we can deal with on an on-going basis. This will be a huge leverage for the future where CRA (Cyber Resilience Act) is in operation and we will be expected to **not** have dependencies with known security issues. Something that we will have to focus on in the coming months and years - and this one removes the biggest obstacle on the way. Kudos to everyone who helps! J. On Tue, Nov 4, 2025 at 6:54 AM Amogh Desai <[email protected]> wrote: > Thanks for spearheading this, Vincent. > > Great teamwork, everyone! > > Thanks & Regards, > Amogh Desai > > > On Tue, Nov 4, 2025 at 3:57 AM Vincent Beck <[email protected]> wrote: > > > I forgot to mention, I keep rebasing > > https://github.com/apache/airflow/pull/56212 which removes the > constraint > > on sqlalchemy<2 so you can find all the errors I mentioned in my previous > > email in this PR's CI. > > > > On 2025/11/03 22:15:45 Vincent Beck wrote: > > > Hi everyone, > > > > > > A quick status on SQLAlchemy 2 migration: > > > > > > - From 525 errors in core Airflow we are down to 64. Please look at > > https://github.com/apache/airflow/issues/56735 if you are interested > > and/or want to help us reach 0 > > > - From 193 errors we are down to ... 0. Actually, I am lying, 2 > > providers are left but we already have open PR for these 2 so it is only > a > > matter of reviewing and merging > > > - Kubernetes provider: https://github.com/apache/airflow/pull/57563 > > > - Databricks provider: https://github.com/apache/airflow/pull/57768 > > > - There is one open PR to resolve the 2 errors from devel-common: > > https://github.com/apache/airflow/pull/57774 > > > - There are still 4 errors in task SDK. Any help is appreciated on that > > front :) > > > > > > But most importantly, huge thanks to all the contributors and reviewers > > for their amazing work fixing these static errors — we’re so close to the > > finish line! > > > > > > Vincent > > > > > > On 2025/10/17 07:17:31 Pavankumar Gopidesu wrote: > > > > Thanks vincet, finally :) > > > > > > > > Pavan > > > > > > > > On Fri, 17 Oct 2025 at 07:18, Amogh Desai <[email protected]> > > wrote: > > > > > > > > > Thanks for spearheading this, Vincent. > > > > > > > > > > Exciting to see it finally happening. > > > > > > > > > > If you / anyone gets hold of a good prompt for AI, do share it on > the > > > > > Github issues > > > > > so that others can benefit from it as well. > > > > > > > > > > Thanks & Regards, > > > > > Amogh Desai > > > > > > > > > > > > > > > On Thu, Oct 16, 2025 at 10:59 PM Beck, Vincent < > [email protected]> > > > > > wrote: > > > > > > > > > > > Hi everyone, > > > > > > > > > > > > We are getting close to be able to migrate to SQL2. Currently we > > are > > > > > still > > > > > > limiting sqlalchemy to version 1 ( > > > > > > > > > > > > > > https://github.com/apache/airflow/blob/main/providers/fab/pyproject.toml#L80 > > > > > ) > > > > > > because our type annotations across the codebase is not > compatible > > with > > > > > > SQLA2. When SQLA2 is enabled, mypy gets very angry and report a > > lot of > > > > > > static errors as you can see in > > > > > > https://github.com/apache/airflow/pull/56212. > > > > > > > > > > > > The idea is, to migrate to SQLA2 but also to improve type safety > > and code > > > > > > quality, solve all these static errors. There are currently: > > > > > > > > > > > > * 525 errors in core Airflow > > > > > > * 193 errors in providers > > > > > > * 4 errors in task SDK > > > > > > * 2 errors in devel-common > > > > > > > > > > > > Given the number of errors, I need you 😊 By dividing and > > conquering, we > > > > > > can easily and quickly solve these errors. To make it easy I > > created 2 > > > > > > issues, one tracking errors in core Airflow, one tracking errors > in > > > > > > providers. No need to create issue for Task SDK and devel-common, > > there > > > > > are > > > > > > just a few. > > > > > > > > > > > > > > > > > > * Issue tracking errors in core Airflow: > > > > > > https://github.com/apache/airflow/issues/56735 > > > > > > * Issue tracking errors in providers: > > > > > > https://github.com/apache/airflow/issues/56738 > > > > > > > > > > > > In these issues you can find steps on how to generate these > > errors. If > > > > > you > > > > > > are interested to help Airflow using SQLA2, then please feel free > > to > > > > > > pick-up some files/directories as part of these issues and > resolve > > the > > > > > > errors in these files. Solving these static errors is not > > complicated, > > > > > > there are just a lot 😊 > > > > > > > > > > > > Thank you for your help! > > > > > > Vincent > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [email protected] > > > For additional commands, e-mail: [email protected] > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [email protected] > > For additional commands, e-mail: [email protected] > > > > >
