FastAPI如何高效实现类似Django-filter的大于小于范围筛选？

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

# ... (数据库连接配置) ...
engine = create_engine("你的数据库连接字符串")  # 请替换为你的数据库连接字符串
SessionLocal = sessionmaker(autocommit=False, autoflush=False, bind=engine)

app = FastAPI()

@app.get("/series")
async def get_series(
    company: Optional[List[int]] = Query(None),
    confirm_start: Optional[str] = Query(None),
    confirm_end: Optional[str] = Query(None),
    score_min: Optional[int] = Query(None),
    score_max: Optional[int] = Query(None),
):
    with SessionLocal() as db:
        query = db.query(Series)  # Series 为你的数据库模型

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

        results = query.all()
        return results