sqlalchemy_compile_orm_query.py

#################################################################
def compile_query(query):
    return str(query.statement.compile(compile_kwargs={"literal_binds": True}))
#################################################################


############################## EXAMPLE ##############################
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String
from sqlalchemy import create_engine
from sqlalchemy.orm import Session

engine = create_engine('sqlite://')

Base = declarative_base()
class User(Base):
    __tablename__ = 'user'

    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)

    def __repr__(self):
        return "<User(%r, %r)>" % (
                self.name, self.fullname
            )

Base.metadata.create_all(engine)
ed_user = User(name='ed', fullname='Edward Jones')
session = Session(bind=engine)
session.add(ed_user)

query = session.query(User).filter_by(name='ed')
print 'Query SQL:',compile_query(query)
print 'Result:',query.first()