GeezerVison

const { DatabaseSync } = require('node:sqlite');

const db = new DatabaseSync('tmp.sqlite');
db.exec('CREATE TABLE a (t TEXT NOT NULL) STRICT;');

const targetStringSize = 1024 * 1024 * 1024;

const nRows = 10_000;
const valueLength = targetStringSize / nRows;

const stmt = db.prepare(`INSERT INTO a (t) VALUES ${[...Array(nRows).keys()].map(() => '(?)').join(',')};`);
const value = 'A'.repeat(valueLength);
const allValues = [...Array(nRows).keys()].map(() => value);
stmt.run(...allValues);
console.log(stmt.expandedSQL());

$ node -v
v22.7.0
$ time node --experimental-sqlite trigger-it.js 
Segmentation fault (core dumped)

real    0m3.872s
user    0m1.444s
sys     0m1.590s

$ ./node --experimental-sqlite trigger-it.js 
/home/tniessen/dev/node/trigger-it.js:15
console.log(stmt.expandedSQL());
                 ^

Error: Expanded SQL text would exceed configured limits
    at Object.<anonymous> (/home/tniessen/dev/node/trigger-it.js:15:18)
    at Module._compile (node:internal/modules/cjs/loader:1546:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1691:10)
    at Module.load (node:internal/modules/cjs/loader:1317:32)
    at Module._load (node:internal/modules/cjs/loader:1127:12)
    at TracingChannel.traceSync (node:diagnostics_channel:315:14)
    at wrapModuleLoad (node:internal/modules/cjs/loader:217:24)
    at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:166:5)
    at node:internal/main/run_main_module:30:49 {
  code: 'ERR_SQLITE_ERROR'
}

Node.js v23.0.0-pre