SQLAlchemy 2 compatibility issue with JupyterHub<3.0

[Sheila-nk]

Bug description

JupyterHub backported the sqalchemy compatibility fix to JupyterHub>=3.0 but didn't restrict the sqlalchemy version to < 2.0 for JupyterHub<3.0. Tests on GitHub Actions are failing due to this. More info: jupyterhub/jupyterhub#4312

Expected behaviour

Tests on GHA should pass or fail without any error messages related to sqlalchemy

Actual behaviour

See bug description

How to reproduce

Making a pull request or a draft pull request triggers GHA to run, exposing the failing tests due to this bug.

Your personal set up

• OS:

• Version(s):

Full environment

# paste output of `pip freeze` or `conda list` here

Configuration

# jupyterhub_config.py

Logs

[welcome]

Thank you for opening your first issue in this project! Engagement like this is essential for open source projects! 🤗

If you haven't done so already, check out Jupyter's Code of Conduct. Also, please try to follow the issue template as it helps other other community members to contribute more effectively.

You can meet the other Jovyans by joining our Discourse forum. There is also an intro thread there where you can stop by and say Hi! 👋

Welcome to the Jupyter community! 🎉

[GeorgianaElena]

Thanks for opening this issue @Sheila-nk!

My proposal would be to not frame this issue like a bug report, but rather a proposal for discussion on the best solution forward:

• dropping support for older JupyterHub versions (see also @manics's comment in Experiment: Configure test suite to use Jupyterhub Pytest Plugin #476 (comment))
  or
• pinning sqalchemy in older JupyterHub's versions, or in dockerspawner

Also, this is not a bug necessarily since jupyterhub >= 3 has the compatibility issue fixed.

[Sheila-nk]

Closed in favor of #478