SQL query

//native

type Xata = {

	apiKey: string

	workspaceUrl: string

}

/**

 * SQL query

 * Run an SQL query across the database branch.

 */

export async function main(

	auth: Xata,

	db_branch_name: string,

	body: { statement: string; params?: unknown[] } & {

		consistency?: 'strong' | 'eventual'

		responseType?: 'json' | 'array'

	}

) {

	const url = new URL(`${auth.workspaceUrl}/db/${db_branch_name}/sql`)

	const response = await fetch(url, {

		method: 'POST',

		headers: {

			'Content-Type': 'application/json',

			Authorization: 'Bearer ' + auth.apiKey

		},

		body: JSON.stringify(body)

	})

	if (!response.ok) {

		const text = await response.text()

		throw new Error(`${response.status} ${text}`)

	}

	return await response.json()

}