首先，您需要创建一个引擎：

from sqlalchemy import create_engine
engine = engine = create_engine('sqlite:///...')

然后你就可以使用

from sqlalchemy.sql import text
with engine.connect() as conn:
    statement = text("SELECT zone, count(fall_status) from events WHERE events.timestamp BETWEEN 1663460366 AND 1663546766 AND events.fall_status = 1 GROUP by zone")
conn.execute(statement)

q = (
    db.query(
        Events.zone, 
        func.count(Events.fall_status),
    )
    .filter(Events.fall_status == 1)
    .filter(Events.timestamp.between(to_date,from_date))
    .group_by(Events.zone)
).all()

请参阅函数.计数