Update SQLAlchemy documentation links from 1.4 (en/14) to 2.0 (en/20)

[shahar1]

Human Summary

While reviewing #69150 (which fixes #25461), I noticed that a number of our
SQLAlchemy documentation links still point at the SQLAlchemy 1.4 docs (en/14), even though
airflow-core now requires SQLAlchemy 2.x .

I don't usually open issues for documentation, but this one is better handled by
someone with SQLAlchemy domain knowledge.

---

AI Summary

What

Several SQLAlchemy documentation links across the codebase still point at the
SQLAlchemy 1.4 docs (https://docs.sqlalchemy.org/en/14/...), even though
airflow-core now requires SQLAlchemy 2.x:

• airflow-core/pyproject.toml pins sqlalchemy[asyncio]>=2.0.48
• uv.lock resolves to sqlalchemy 2.0.51

The SQLAlchemy 1.4 constraint that originally drove some of these references is
gone, so the user- and developer-facing doc links should point at the en/20/
(2.0) docs that match the version Airflow actually runs.

Acceptance criteria

• All nine links above use en/20 and still resolve to a live page + anchor.
• set-up-database.rst:201 is left untouched.
• breeze build-docs passes (no broken external-link / spellcheck failures).

Notes

Doc/comment-only — no behavior change, no newsfragment needed (the
providers/sqlite comments are a provider change, so no newsfragment there
either).

---

Drafted-by: Claude Code (Opus 4.8); AI Summary section compiled at the maintainer's request

[Dev-iL]

airflow-core/docs/howto/set-up-database.rst:201 —
https://docs.sqlalchemy.org/en/14/changelog/changelog_14.html#change-3687655465c25a39b968b4f5f6e9170b

This points at a specific SQLAlchemy 1.4 changelog entry; the anchor only
exists under en/14. Leave it as-is.

This is false. A en/20 path exists below:

https://docs.sqlalchemy.org/en/20/changelog/changelog_14.html#change-3687655465c25a39b968b4f5f6e9170b

[kalyanram07]

Hi @shahar1! I would love to fix these documentation links for my first contribution. Please assign this issue to me!

[shahar1]

airflow-core/docs/howto/set-up-database.rst:201 —
https://docs.sqlalchemy.org/en/14/changelog/changelog_14.html#change-3687655465c25a39b968b4f5f6e9170b
This points at a specific SQLAlchemy 1.4 changelog entry; the anchor only
exists under en/14. Leave it as-is.

This is false. A en/20 path exists below:

https://docs.sqlalchemy.org/en/20/changelog/changelog_14.html#change-3687655465c25a39b968b4f5f6e9170b

Got sloppy here, removed it from the AI summary.

Hi @shahar1! I would love to fix these documentation links for my first contribution. Please assign this issue to me!

Hey! Feel free to raise a PR to fix it - currently we don't assign people to issues by policy.

[AshleyAHuang]

There are now three open PRs addressing this issue:

• docs: update SQLAlchemy documentation links from 1.4 to 2.0 #69167 — updates the .rst doc file only
• docs: Update SQLAlchemy links from 1.4 to 2.0 docs (fixes #69164) #69168 — updates manager.py and base.py only
• Update SQLAlchemy documentation links from 1.4 to 2.0 #69200 — updates all four affected files, including the SQLite
  provider hook (providers/sqlite/src/airflow/providers/sqlite/hooks/sqlite.py)
  that the other two miss

Flagging so a maintainer can pick whichever is preferred and close the
others per the "better PR wins" convention — happy to close mine in favor
of either of the other two if one is extended to cover the missing file.

---

Drafted-by: Claude Code (Sonnet 5); reviewed by @AshleyAHuang before posting