| Storage class | JavaScript to SQLite | SQLite to JavaScript |

| ------------- | --------------------------------------------------------------- | ------------------------------------- |

| `NULL` | {null} | {null} |

| `INTEGER` | {number}, {bigint}, or {boolean} | {number} or {bigint} _(configurable)_ |

| `REAL` | {number} | {number} |

| `TEXT` | {string} | {string} |

| `BLOB` | {TypedArray}, {DataView}, {ArrayBuffer}, or {SharedArrayBuffer} | {Uint8Array} |

Booleans are written as the `INTEGER` values `1` and `0`. Like any other

`INTEGER` value, they are read back as {number} by default, or as {bigint}

values (`1n` and `0n`) when reading BigInts is enabled. Writing a {bigint} that

does not fit in a signed 64-bit integer throws an `ERR_INVALID_ARG_VALUE`

error.

The `all()`, `get()`, `iterate()`, and `run()` methods bind their arguments to

the parameters of the prepared statement before executing it. Parameters are

either anonymous or named.

Anonymous parameters are written as `?` in SQL and are bound in order from the

arguments passed to the method. The `?NNN` form assigns SQLite parameter index

`NNN` to a placeholder. Avoid mixing numbered and named parameters because they

share parameter indexes.

db.prepare('SELECT ? AS a, ? AS b').get('x', 42);

db.prepare('SELECT ?2 AS a, ?1 AS b').get('first', 'second');

Named parameters begin with one of the prefix characters `$`, `:`, or `@` in

SQL. They are bound from an object passed as the first argument. Repeating a

name in the SQL binds the same value to every occurrence.

db.prepare('SELECT $a AS a, $b AS b').get({ $a: 1, $b: 2 });

db.prepare('SELECT :a AS a').get({ ':a': 1 });

db.prepare('SELECT @a AS a').get({ '@a': 1 });

db.prepare('SELECT $k AS a, $k AS b').get({ k: 7 });

The last example omits the prefix character from the object key. Bare names are

allowed by default; see [`statement.setAllowBareNamedParameters()`][] for their

caveats.

Binding a key that does not name a parameter of the statement throws an

`ERR_INVALID_STATE` error unless unknown named parameters are ignored. See

[`statement.setAllowUnknownNamedParameters()`][].

See [Type conversion between JavaScript and SQLite][] for the values that can be

bound. Binding any other value throws an `ERR_INVALID_ARG_TYPE` error.

* `...anonymousParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

Zero or more values to bind to anonymous parameters.

the values in `namedParameters` and `anonymousParameters`. See

[Binding parameters][].

* `...anonymousParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

Zero or more values to bind to anonymous parameters.

values in `namedParameters` and `anonymousParameters`. See

[Binding parameters][].

* `...anonymousParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

Zero or more values to bind to anonymous parameters.

the values in `namedParameters` and `anonymousParameters`. See

[Binding parameters][].

* `...anonymousParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

Zero or more values to bind to anonymous parameters.

values in `namedParameters` and `anonymousParameters`. See

[Binding parameters][].

The names of SQLite parameters begin with a prefix character. However, with the

exception of the dollar sign character, these prefix characters also require

extra quoting when used in object keys.

To improve ergonomics, `node:sqlite` allows bare named parameters, which do not

require the prefix character in JavaScript code, by default. This method can be

used to disable that behavior, requiring the prefix character when binding.

There are several caveats to be aware of when bare named parameters are

allowed:

* `...boundParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

* `...boundParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

* `...boundParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

* `...boundParameters` {null|number|bigint|boolean|string|Buffer|TypedArray|DataView|ArrayBuffer|SharedArrayBuffer}

[Binding parameters]: #binding-parameters

[`statement.setAllowBareNamedParameters()`]: #statementsetallowbarenamedparametersenabled

[`statement.setAllowUnknownNamedParameters()`]: #statementsetallowunknownnamedparametersenabled