SQLAlchemy 2.0 is the latest and greatest in SQLAlchemy. it features

• typed declarative properties in a sane way (YAY NO MORE SQUIGGLIES)
• changes from nullslast to nulls_last
• zero cost abstractions
• ...

anyway... here's the steps we need to do to migrate to SQLAlchemy 2.0

https://docs.sqlalchemy.org/en/14/changelog/migration_20.html

• A working 1.3 application!
• A working 1.4 application!
• Be >Python 3.7 or later (SQL 1.4 supported Py2 😨)
• Turn on RemovedIn20Warnings
• Resolve all RemovedIn20Warnings
• Use future=True in the engine
• Use future=True in the session
• Add __allow_unmapped__ to explicitly typed ORM models (https://docs.sqlalchemy.org/en/14/changelog/migration_20.html#migration-to-2-0-step-six-add-allow-unmapped-to-explicitly-typed-orm-models) (WE SHOULD DEFINITELY TYPE OUR MODELS)
• Test it against SQLAlchemy 2.0