SQLalchemy - Simple Select Query

26 Dec 2013

Updated 2026-09-23: fixed the example and updated it for SQLAlchemy 2.0.

from sqlalchemy import create_engine, MetaData, Table

engine = create_engine('sqlite:///cars.db', echo=False)
metadata = MetaData()

cars = Table('cars', metadata, autoload_with=engine)

with engine.connect() as conn:
    for row in conn.execute(cars.select()):
        print(row)