from sqlalchemy import create_engine, func
from sqlalchemy.orm import sessionmaker
engine = create_engine('sqlite://', echo=True)
print(engine.execute(func.upper('abc')).scalar())
session = sessionmaker(bind=engine)()
print(session.execute(func.upper('abc')).scalar())
хранимые процедуры с sqlAlchemy