Execute SQL from file in SQLAlchemy

sqlalchemy.text or sqlalchemy.sql.text

• The text construct provides a straightforward method to directly execute .sql files.

from sqlalchemy import create_engine
from sqlalchemy import text
# or from sqlalchemy.sql import text

engine = create_engine('mysql://{USR}:{PWD}@localhost:3306/db', echo=True)

with engine.connect() as con:
    with open("src/models/query.sql") as file:
        query = text(file.read())
        con.execute(query)

• SQLAlchemy: Using Textual SQL
  • text()