Skip to main content
Go to Latest
type alias QueryParameterSet
import { type QueryParameterSet } from "https://deno.land/x/sqlite@v3.7.2/mod.ts";

A set of query parameters.

When a query is constructed, it can contain either positional or named parameters. For more information see https://www.sqlite.org/lang_expr.html#parameters.

A set of parameters can be passed to a query method either as an array of parameters (in positional order), or as an object which maps parameter names to their values:

SQL Parameter QueryParameterSet
?NNN or ? NNN-th value in array
:AAAA value AAAA or :AAAA
@AAAA value @AAAA
$AAAA value $AAAA

See QueryParameter for documentation on how values are converted between SQL and JavaScript types.

definition: Record<string, QueryParameter> | Array<QueryParameter>