V1Table

Query a table using PostgREST-style filters

Mirrors the Supabase PostgREST query syntax. Supply filter expressions (`column.eq=value`, `column.lt=value`, `or=(cond1,cond2)`, etc.), `select`, `limit`, `offset`, `order`, and the optional `Range` header (`items=0-24`). The handler also honors `Prefer: return=minimal`.

Path Parameters

table*string

Target table name (sanitized before execution).

Query Parameters

select?string

PostgREST select clause (comma separated columns).

limit?integer

Maximum number of rows to return (default 100).

offset?integer

Row offset (default 0).

order?string

Column ordering using .asc/.desc (e.g. id.desc).

or?string

PostgREST or expression to build grouped filters ((a.eq.1,b.eq.2)).

Header Parameters

X-Athena-Client*string

Selects which Postgres pool executes the query.

apikey*string

Gateway API key (can also be passed via Authorization or x-api-key).

x-api-key?string

Mirror of apikey useful for proxies.

Range?string

Optional items=start-end range header that overrides offset/limit.

Response Body

`application/json`

curl -X GET "https://athena-cluster.com/rest/v1/string" \  -H "X-Athena-Client: string" \  -H "apikey: string"

{
  "data": [
    {}
  ]
}

Empty

Delete rows using PostgREST-style filters DELETE

Filters are mandatory. Use the same query syntax as GET and include `Prefer: return=minimal` for HTTP 204 responses.

Update rows filtered via PostgREST expressions PATCH

Filters are required (`column.eq=value`, `column.lte=value`, `or=(...)`). The request body must be an object describing the columns to patch. `Prefer: return=minimal` controls whether the response returns data.