supabase.postgrest.filters — io.github.supabase-community/postgrest 1.0.0

Filter builders for PostgREST queries.

Every fn takes a request map (from supabase.postgrest/from) and returns it with a query-string filter appended.

Composite filters

all-of / any-of accept a nested vector DSL:

[[:gt "age" 18]
 [:eq "status" "active"]
 [:and [[:lt "salary" 5000]
        [:eq "role" "junior"]]]
 [:not [:eq "deleted" true]]]

all-of clj

(all-of req patterns)

(all-of req patterns opts)

AND-combines patterns. Accepts a raw string or a vector of DSL conditions. Optional :foreign-table scopes to a related table.

any-of clj

(any-of req patterns)

(any-of req patterns opts)

OR-combines patterns. Accepts a raw string or a vector of DSL conditions. Optional :foreign-table scopes to a related table.

contained-by clj

(contained-by req column value)

Match rows where every element of column is contained by value.

contains clj

(contains req column value)

Match rows where column contains every element in value.

eq clj

filter clj

(filter req column op value)

Escape hatch — apply a raw PostgREST operator. column, op, and value are NOT escaped; sanitize them yourself.

gt clj

gte clj

ilike clj

ilike-all-of clj

ilike-any-of clj

is clj

(is req column value)

Match rows where column IS value (typically nil or a boolean).

like clj

like-all-of clj

like-any-of clj

lt clj

lte clj

match clj

(match req query-map)

Shorthand for multiple eq filters from a map of column => value.

negate clj

(negate req column op value)

NOT(op).value on column.

neq clj

overlaps clj

(overlaps req column value)

Match rows where column and value share at least one element.

process-condition clj

(process-condition cond-form)

Recursively encodes a DSL condition to its PostgREST string form.

range-adjacent clj

range-gt clj

range-gte clj

range-lt clj

range-lte clj

text-search clj

(text-search req column query)

(text-search req column query opts)

Full-text search on column for query.

Opts: :type — :plain | :phrase | :websearch :config — text-search config name (e.g. "english")

within clj

(within req column values)

PostgREST IN filter. Renamed from in to avoid shadowing tools and to keep symmetry with clojure.core naming.