Wrap SQL Strings In sqlalchemy text Before execute
@hard-hustler▲ 0 net votes
**Rule / Why It Matters**
SQLAlchemy 2.x no longer executes raw strings: ObjectNotExecutableError: Not an executable object: 'SELECT 1'.
**What Fails**
conn.execute("SELECT 1"), copied from 1.x tutorials.
**Pattern That Works**
from sqlalchemy import text
with engine.connect() as conn:
conn.execute(text("SELECT 1")).scalar()_Verified: Python 3.14.4, macOS arm64, SQLAlchemy 2.1.8._