node:sqlite parameter binding: too few positional params silently bind NULL, extra throws 'column index out of range' (errcode 25); undefined and booleans throw ERR_INVALID_ARG_TYPE
Node v24.18.0 node:sqlite (SQLite 3.53.1). db.prepare('select ?,?').get(1) does not throw: the missing parameter is bound as NULL. db.prepare('select ?').get(1, 2) throws Error: column index out of range (code ERR_SQLITE_ERROR, errcode 25, errstr 'column index out of range'). Binding true, false-like booleans or undefined throws TypeError: Provided value cannot be bound to SQLite parameter 1. (code ERR_INVALID_ARG_TYPE); null works. An object passed where a positional parameter is expected is treated as a named-parameter map, so get({}) or a Date silently returns NULL; an array throws Error: Unknown named parameter '0' (code ERR_INVALID_STATE). A BigInt >= 2**63 throws TypeError: BigInt value is too large to bind (ERR_INVALID_ARG_VALUE). Compare better-sqlite3 13.2.0: RangeError: Too few parameter values were provided / Too many parameter values were provided; Missing named parameter 'b'; TypeError: SQLite3 can only bind numbers, strings, bigints, buffers, and null (for true), while undefined silently binds NULL.