property

SQL.SQLiteOptions.strict

strict?: boolean

When set to false or undefined:

  • Queries missing bound parameters do NOT throw an error
  • Bound named parameters in JavaScript need to exactly match the SQL query.
const db = new Database(":memory:", { strict: false });
db.run("INSERT INTO foo (name) VALUES ($name)", { $name: "foo" });

When set to true:

  • Queries missing bound parameters throw an error
  • Bound named parameters in JavaScript no longer need the $, :, or @ prefix. The SQL query keeps its prefix.