http://stackoverflow.com/questions/1958219/convert-sqlalchemy-row-object-to-python-dict/25446105?noredirect=1#comment62216996_25446105

_asdict.py

from sqlalchemy import Column, Integer, Text, create_engine
from sqlalchemy.orm import sessionmaker
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite://')
Base = declarative_base()

Session = sessionmaker(bind=engine)


class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(Text)

Base.metadata.create_all(bind=engine)

session = Session()

session.add(User(name='Alice'))

for u in session.query(User).all():
    print(u._asdict())