Selecto.Subfilter.SQL.InBuilder (Selecto v0.4.5)

Copy Markdown

Builds IN subqueries for subfilters.

This strategy is useful when you need to filter the main query based on a set of IDs returned by the subquery. It can be more performant than EXISTS in some cases, especially when the subquery returns a small number of rows.

Example SQL

film_id IN (
  SELECT fc.film_id
  FROM film_category fc
  JOIN category c ON fc.category_id = c.category_id
  WHERE c.name IN ('Action', 'Comedy')
)

Summary

Functions

generate(spec, join_resolution, registry)

Generate IN subquery SQL for a given subfilter.

Functions

generate(spec, join_resolution, registry)

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

Generate IN subquery SQL for a given subfilter.