database_query

Creates, updates, deletes, gets or lists a database_query resource.

Overview

Name	database_query
Type	Resource
Id	cloudflare.d1.database_query

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
query	insert	account_id, database_id		Returns the query result as an object.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
account_id	string	The Cloudflare account ID.
database_id	string	The D1 database ID.

INSERT examples

query

Returns the query result as an object.

INSERT INTO cloudflare.d1.database_query (
params,
sql,
batch,
account_id,
database_id
)
SELECT 
'{{ params }}',
'{{ sql }}',
'{{ batch }}',
'{{ account_id }}',
'{{ database_id }}'
RETURNING
errors,
messages,
result,
success
;

Manifest

# Description fields are for documentation purposes
- name: database_query
props:
  - name: account_id
    value: "{{ account_id }}"
    description: Required parameter for the database_query resource.
  - name: database_id
    value: "{{ database_id }}"
    description: Required parameter for the database_query resource.
  - name: params
    value:
      - "{{ params }}"
  - name: sql
    value: "{{ sql }}"
    description: |
      Your SQL query. Supports multiple statements, joined by semicolons, which will be executed as a batch.
  - name: batch
    value:
      - params: "{{ params }}"
        sql: "{{ sql }}"