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

Query verbs (select/insert/upsert/update/delete) + rpc + aggregations.

avg clj

(avg c)

(avg c opts)

count clj

(count c)

(count c opts)

delete clj

(delete req)

(delete req opts)

Deletes rows. Filter first or every row in the relation is deleted.

insert clj

(insert req data)

(insert req data opts)

Inserts data (map or vector of maps).

max clj

(max c)

(max c opts)

min clj

(min c)

(min c opts)

rpc clj

(rpc client fn-name)

(rpc client fn-name args)

(rpc client fn-name args opts)

Calls a database function.

Opts: :head — boolean; when true, send HEAD (no body returned) :get — boolean; when true, send GET (args become query params) :count — :exact | :planned | :estimated

Returns a request builder. Pipe through filters or execute to run.

select clj

(select req columns)

(select req columns opts)

Builds a SELECT.

columns is "*", a string, or a vector of strings/keywords. Opts: :count — :exact | :planned | :estimated (default :exact) :returning — boolean; when true, performs GET; when false, HEAD (default false — only headers + count are returned)

sum clj

(sum c)

(sum c opts)

update clj

(update req data)

(update req data opts)

Updates rows with data. Filter the rows with eq/gt/... before calling, or every row matching the relation will be updated.

upsert clj

(upsert req data)

(upsert req data opts)

Upserts data. Defaults to resolution=merge-duplicates.