method IDatabaseService.query
Since 0.1.0
IDatabaseService.query<T>(
sql: string,
params?: unknown[]
): Promise<T[]>

Execute a raw SQL query and return results.

Type Parameters

Expected row shape

Parameters

sql: string

SQL query string

optional
params: unknown[]

Query parameters (replaced positionally)

Return Type

Promise<T[]>

Query result rows

Usage

import { type IDatabaseService } from "database-plugin/src/index.ts";