method DB.prototype.query
DB.prototype.query<T extends Record<string, any> = Record<string, any>>(
sql: string,
params?: unknown[],
): Task<T[], QueryFailed | ConstraintViolation>

Execute a SELECT query and return rows.

Examples

Example 1

const users = await db.query("SELECT * FROM users").run();

Type Parameters

T extends Record<string, any> = Record<string, any>

Parameters

sql: string
optional
params: unknown[]

Return Type

Usage

import { DB } from ".";