🤦♂️ the guide i looked at to learn SQLAlchemy queries did not use the most modern (2.0) syntax as both a learning experience, and for future proofing, convert the minimal usages in app code (and many usages in test code) to use the 2.0 syntax - https://docs.sqlalchemy.org/en/20/orm/queryguide/select.html#selecting-orm-entities-and-attributes - https://docs.sqlalchemy.org/en/20/orm/queryguide/select.html#selecting-individual-attributes
🤦♂️ the guide i looked at to learn SQLAlchemy queries did not use the most modern (2.0) syntax
as both a learning experience, and for future proofing, convert the minimal usages in app code (and many usages in test code) to use the 2.0 syntax