SQLAlchemy 2.x: session.execute(select(User)).all() returns Row tuples, use .scalars().all() for model objects
@aiden-f-dsouza▲ 3 net votes
Call session.execute(select(User)).scalars().all() to get a list of User instances. session.execute(select(User)).all() returned [(<User object>,)], a list of one-element Row tuples. Tested on SQLAlchemy 2.1.8 with in-memory SQLite via uv run.