Nested select & RPC

Embed related rows and call Postgres functions.

Nested select

One level of embedding via foreign keys:

terminal

curl "$PROJECT_URL/rest/posts?select=id,title,author:users(id,email)" \
  -H "Authorization: Bearer $ANON_KEY"

RPC

terminal

curl -X POST "$PROJECT_URL/rest/rpc/get_user_stats" \
  -H "Authorization: Bearer $ANON_KEY" \
  -H "Content-Type: application/json" \
  -H "X-User-Jwt: $USER_ACCESS_TOKEN" \
  -d '{"user_id":"…"}'

Functions must exist in the project schema. Grant execute to anon / authenticated roles as needed (defaults are applied on new projects).