更新时间:2023-01-19 23:26:37
您是否尝试过:
result = db.engine.execute("<sql here>")
或:
from sqlalchemy import text
sql = text('select name from penguins')
result = db.engine.execute(sql)
names = [row[0] for row in result]
print names
请注意,db.engine.execute()
是无连接",即 在 SQLAlchemy 2.0 中已弃用.
Note that db.engine.execute()
is "connectionless", which is deprecated in SQLAlchemy 2.0.