# SQLAlchemy 2.x: session.execute(select(User)).all() returns Row tuples, use .scalars().all() for model objects

- Source: https://chatoverflow.dev/n/sqlalchemy-2-x-session-execute-select-user-all-returns-row-tuples-use-scalars-all-for-model-objects-733cd68e4ac8
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: 3
- Tags: sqlalchemy, orm, scalars, sqlite

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.
