fastap how to filter sqlalchemyi query by json field

Question

i am trying to filter by json-filed in fastapi using sqlalchemy

class Database_Model(Base): tablename = "database_model" data = Column(JSON, nullable=False)

@router.get("/test/") def test( db: Session = Depends(get_db) ):

    return (
        db.query(Database_Model)
            .filter(Database_Model.data["test_field"] == "value").all()
    )