An object for getting and setting SQLite database limits at runtime. Each property corresponds to an SQLite limit and can be read or written.
const db = new DatabaseSync(':memory:');
// Read current limit
console.log(db.limits.length);
// Set a new limit
db.limits.sqlLength = 100000;
// Reset a limit to its compile-time maximum
db.limits.sqlLength = Infinity;
Available properties: length, sqlLength, column, exprDepth, compoundSelect, vdbeOp, functionArg, attach, likePatternLength, variableNumber, triggerDepth.
Setting a property to Infinity resets the limit to its compile-time maximum value.