python - SQLAlchemy：打印实际的原始 SQL 查询及其绑定参数

Question

很清楚类似的事情已经详细讨论过（here），但是我的问题涉及必须执行原始 SQL 的情况。鉴于以下来自QLAlchemy 官方文档的示例：

>>> from sqlalchemy.sql import text
>>> s = text(
...     "SELECT users.fullname || ', ' || addresses.email_address AS title "
...         "FROM users, addresses "
...         "WHERE users.id = addresses.user_id "
...         "AND users.name BETWEEN :x AND :y "
...         "AND (addresses.email_address LIKE :e1 "
...             "OR addresses.email_address LIKE :e2)")
>>> conn.execute(s, x='m', y='z', e1='[e-mail]', e2='[e-mail]').fetchall()

如何打印带有参数的实际 SQL 语句？

标签： pythonsqlalchemy