When set to false or undefined:
- Queries missing bound parameters will NOT throw an error
- Bound named parameters in JavaScript need to exactly match the SQL query.
property
SQL.SQLiteOptions.strict
strict?: boolean
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 will throw an error
- Bound named parameters in JavaScript no longer need to be
$,:, or@. The SQL query will remain prefixed.