fastAPI sqlalchemyでプレースホルダを使う

sqlalchemy.text を使ってパラメータ名をクエリに埋め込む

from sqlalchemy import create_engine, text

DATABASE = f'mysql://{user_name}:{password}@{host}/{database_name}?charset=utf8mb4'

engine = create_engine(
    DATABASE,
    echo=True
)

results = engine.execute('SELECT * FROM posts')

for row in results:
    print((row['id'], row['content']))