Raw D1 Database query

POST /accounts/{account_id}/d1/database/{database_id}/raw

Copy endpoint

https://api.cloudflare.com/client/v4

Returns the query result rows as arrays rather than objects. This is a performance-optimized version of the /query endpoint.

Parameters

Name	Type
`account_id` required	type D1AccountIdentifier = string
`database_id` required	type D1DatabaseIdentifier = string

application/json required

{ params?:

D1Params

type D1Params = string[]

;sql:

D1Sql

Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch.

type D1Sql = string

; }

200 application/json

Raw query response

interface D1ApiResponseCommon {
errors:

D1Messages

type D1Messages = { code: number;message: string; }[]

;
messages:

D1Messages

type D1Messages = { code: number;message: string; }[]

;
result: {};
success: true;
} & { result?:

D1RawResultResponse

interface D1RawResultResponse {
meta?: D1QueryMeta;
results?: { columns?: string[];rows?: ({} | string | number)[][]; };
success?: boolean;
}

[]; }

4XX application/json

Query response failure

interface D1ApiResponseCommonFailure {
errors:

D1Messages

type D1Messages = { code: number;message: string; }[]

;
messages:

D1Messages

type D1Messages = { code: number;message: string; }[]

;
result: null;
success: false;
}