# `Selecto.Subfilter.SQL.AnyAllBuilder`

Builds ANY and ALL subqueries for subfilters.

These strategies are useful for more complex comparisons against a set of
values returned by a subquery.

## Example SQL (ANY)

    release_year > ANY (
      SELECT year
      FROM special_release_years
    )
    
## Example SQL (ALL)

    rating > ALL (
      SELECT rating
      FROM competing_films
    )

# `generate`

```elixir
@spec generate(
  :any | :all,
  Selecto.Subfilter.Spec.t(),
  Selecto.Subfilter.JoinPathResolver.JoinResolution.t(),
  any()
) :: {:ok, String.t(), [any()]} | {:error, Selecto.Subfilter.Error.t()}
```

Generate ANY or ALL subquery SQL for a given subfilter.

---

*Consult [api-reference.md](api-reference.md) for complete listing*