Sometimes, we want to execute raw SQL in Python Flask-SQLAlchemy app.

In this article, we’ll look at how to execute raw SQL in Python Flask-SQLAlchemy app.

How to execute raw SQL in Python Flask-SQLAlchemy app?

To execute raw SQL in Python Flask-SQLAlchemy app, we can call db.session.execute.

For instance, we write

result = db.session.execute('SELECT * FROM my_table WHERE my_column = :val', {'val': 5})

to call db.session.execute with a SQL string with the :val placeholder.

Then we set the value of val in the dictionary in the 2nd argument.

The selected results are returned.

Conclusion

To execute raw SQL in Python Flask-SQLAlchemy app, we can call db.session.execute.