sqlrunner

Overview ¶

Package sqlrunner provides the studio SQL-runner HTTP handler.

Route (requires service-role Bearer token unless explicitly insecure):

POST /sql   — execute a SQL query and return rows as JSON

The Postgres search_path is determined server-side from the JWT role claim. Clients may request a schema override in the body, but it is only honoured when the JWT role is "service_role" (or SUPATYPE_MODE=dev).