Skip to content

SQLAlchemy 查询对象转为 SQL 语句

python
from sqlalchemy.orm import Query

query = Query(User).where(User.id == 1)

statement = query.statement

print(statement.compile(compile_kwargs={"literal_binds": True}))

"literal_binds": True: 将 SQL 语句中的变量替换为实际值。

Released under the MIT License.