Query Console REST API

The query console is an optional development endpoint.

Availability

This route may be deployment-dependent and can be omitted by conservative runtime configurations.

Route

Method	Route
POST	/api/query

Request body:

{
  "sql": "SELECT * FROM \"dereg\".\"Employee$Events\";"
}

Validation Rules

• SQL must start with SELECT or WITH
• Mutation keywords are rejected even if they appear later in the text
• On success, result batches are returned as Arrow IPC

Errors

Status	Meaning
403	Non-read-only SQL was supplied
404	Route not registered or not available in the current deployment
500	Query execution or IPC serialization failure

Notes

• This endpoint is intended for debugging, exploration, and lightweight integrations.
• It is not the primary path for schema mutation or command execution.