Skip to main content
PATCH
Update

Authorizations

Authorization
string
header
required

OAuth 2.0 Client Credentials flow. The tokenUrl shown is for the production environment. For other environments, replace prod with the target environment name (e.g., auth.staging.oleria.io for staging).

Path Parameters

query_id
string<uuid>
required

The opaque saved-query identifier.

Body

application/json

Partial update. expected_version must equal the query's current version (optimistic concurrency); a mismatch returns 409 VERSION_CONFLICT. Omitted fields are left unchanged.

expected_version
integer
required

The version the caller last read.

Example:

3

name
string
Required string length: 1 - 200
Example:

"Disabled MFA — prod"

description
string
Maximum string length: 2000
query_string
string
Required string length: 1 - 100000
model
string

Semantic model the query targets. Validated against the available models (/v1/schema/models) at save.

Example:

"oleria_identity"

Response

The updated saved query.

A stored SQL query with authorship metadata.

query_id
string<uuid>
required

Opaque stable identifier. Clients key on this, never the name.

Example:

"550e8400-e29b-41d4-a716-446655440000"

name
string
required

Free-form label, unique within the tenant (case-insensitive).

Example:

"Disabled MFA accounts"

query_string
string
required

The stored SQL text.

Example:

"SELECT account_id, mfa_status FROM oleria_account WHERE mfa_status = :status"

model
string
required

Semantic model the query targets.

Example:

"oleria_identity"

created_by
object
required

The principal (user or service client) that created or last modified the saved query, identified by a stable, opaque id.

last_modified_by
object
required

The principal (user or service client) that created or last modified the saved query, identified by a stable, opaque id.

version
integer
required

Monotonic version — 1 on create, incremented on every update. Doubles as the optimistic-concurrency token on update.

Example:

3

created_at
string<date-time>
required
Example:

"2026-06-01T10:00:00Z"

last_modified_at
string<date-time>
required
Example:

"2026-06-04T09:30:00Z"

description
string

Optional free-form context about the query.

Example:

"Accounts where MFA is disabled — weekly review"