Print SQLAlchemy queries (including bind params).

query_debug.py

"""Print SQLAlchemy queries (including bind params).

See also: http://docs.sqlalchemy.org/en/latest/faq/sqlexpressions.html#faq-sql-expression-string

"""


def show_query(query):
    qc = query.statement.compile(
        dialect=query.session.bind.dialect,
        compile_kwargs={'literal_binds': True}
    )
    return str(query)


def print_query(query):
    print(show_query(query))