Apply filter on multiple column

Example: %{ id: 10, not: %{

type: "work"

}, or: %{

team_id: 10,
and: %{
  team_id: 11,
  role: "manager"
}

} }

id = 10 and not (type = "work") and (team_id = 10 or (team_id = 11 and role = "manager" ))

between inclusive