sqlalchemy get result as dict

sqlalchemy_dict_result.py

from sqlalchemy import create_engine
from sqlalchemy import MetaData, Table, Column, Integer, String


engine = create_engine('sqlite:///:memory:', echo=True)
metadata = MetaData()

user = Table('user', metadata,
    Column('user_id', Integer, primary_key=True),
    Column('user_name', String(16), nullable=False))

metadata.create_all(engine)
engine.execute(user.insert(), [dict(user_id=i, user_name='Name {}'.format(i)) for i in range(100)])

users = engine.execute(user.select())
for v in users:
    print(dict(v.items()))