@photostructure/sqlite
    Preparing search index...

    Interface StatementOptions

    Options for creating a prepared statement.

    Note: The per-statement override options (readBigInts, returnArrays, allowBareNamedParameters, allowUnknownNamedParameters) are a Node.js v25+ feature. On Node.js v24 and earlier, node:sqlite silently ignores these options. This library implements them for forward compatibility with Node.js v25+.

    interface StatementOptions {
        allowBareNamedParameters?: boolean;
        allowUnknownNamedParameters?: boolean;
        anonymousParameters?: boolean;
        expandedSQL?: boolean;
        readBigInts?: boolean;
        returnArrays?: boolean;
    }
    Index

    Properties

    allowBareNamedParameters? allowUnknownNamedParameters? anonymousParameters? expandedSQL? readBigInts? returnArrays?

    Properties

    allowBareNamedParameters?: boolean

    If true, allows bare named parameters (without prefix). Overrides database-level setting. Node.js v25+ feature - silently ignored by node:sqlite on v24 and earlier.

    database default
    allowUnknownNamedParameters?: boolean

    If true, unknown named parameters are ignored. Overrides database-level setting. Node.js v25+ feature - silently ignored by node:sqlite on v24 and earlier.

    database default
    anonymousParameters?: boolean

    If true, anonymous parameters are enabled for the statement.

    false
    expandedSQL?: boolean

    If true, the prepared statement's expandedSQL property will contain the expanded SQL.

    false
    readBigInts?: boolean

    If true, read integer values as JavaScript BigInt. Overrides database-level setting. Node.js v25+ feature - silently ignored by node:sqlite on v24 and earlier.

    database default
    returnArrays?: boolean

    If true, return results as arrays rather than objects. Overrides database-level setting. Node.js v25+ feature - silently ignored by node:sqlite on v24 and earlier.

    database default

    Settings

    Member Visibility

    On This Page

    Properties