Skip to main content
POST
Execute read-only SQL query

Authorizations

Authorization
string
header
required

The access token received from the authorization server in the OAuth 2.0 flow.

Body

application/json
sql
string
required
Minimum string length: 1
limit
integer
default:100
Required range: 1 <= x <= 10000
timeout_ms
integer
default:30000
Required range: 1000 <= x <= 120000
row_format
enum<string>
default:both

Which row representation result should carry. Each value names the key it returns. rows is the compact map-per-row form: its column names are camelCased and therefore NOT the source names (order_id arrives as orderId), and because it is a map, output columns whose names collide after camelCasing — or that the query aliased to the same name — collapse to a single cell. rows_with_column_order preserves source names, order, and duplicates. both is the default and returns each of them. Choosing one drops the other, substantially reducing response size on wide reads; the chosen key is always present, empty when no rows match.

Available options:
both,
rows,
rows_with_column_order

Response

Successful Response