How do you execute raw SQL in SQLAlchemy?
I have a python web app that runs on flask and interfaces to the database through SQLAlchemy.
I need a way to run the raw SQL. The query involves multiple table joins along with Inline views.
connection = db.session.connection()
But I keep getting gateway errors.
Have you tried:
result = db.engine.execute(“
from sqlalchemy import text
sql = text(‘select name from penguins’)
result = db.engine.execute(sql)
names = [row for row in result]