How to execute raw SQL in Flask-SQLAlchemy app

May 20, 2022 by Tarik

Have you tried:

result = db.engine.execute("<sql here>")

or:

from sqlalchemy import text

sql = text('select name from penguins')
result = db.engine.execute(sql)
names = [row[0] for row in result]
print names

Note that db.engine.execute() is “connectionless”, which is deprecated in SQLAlchemy 2.0.