FastAPI中如何高效实现类似Django filter的大于小于范围查询？

from fastapi import FastAPI, Query
from sqlalchemy import create_engine, text
from sqlalchemy.orm import sessionmaker

# ... (数据库连接配置) ...

app = FastAPI()

@app.get("/items/")
async def read_items(
    company: list[int] = Query(None),
    confirm_start: str = Query(None),
    confirm_end: str = Query(None),
    score_min: int = Query(None),
    score_max: int = Query(None),
):
    with Session() as session:
        query = session.query(YourModel).filter()  # YourModel 为你的数据库模型

        if company:
            query = query.filter(YourModel.company_id.in_(company))
        if confirm_start:
            query = query.filter(YourModel.confirm_at >= confirm_start)
        if confirm_end:
            query = query.filter(YourModel.confirm_at <= confirm_end)
        if score_min:
            query = query.filter(YourModel.rating_score >= score_min)
        if score_max:
            query = query.filter(YourModel.rating_score <= score_max)

        results = query.all()
        return results