René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"docs: sqlite statement.setAllowBareNamedParameters()","articleBody":"### Affected URL(s)\n\nhttps://nodejs.org/docs/latest/api/sqlite.html#statementsetallowbarenamedparametersenabled\n\n### Description of the problem\n\nFor sqlite `statement.setAllowBareNamedParameters()` the docs say:\n\n> By default, node:sqlite requires that this prefix character is present when binding parameters .. To improve ergonomics, this method can be used to also allow bare named parameters\n\nbut this is not right, the default value for `allowBareNamedParameters` is true, see [database.prepare(sql[, options])](https://nodejs.org/docs/latest-v25.x/api/sqlite.html#databasepreparesql-options) and [new DatabaseSync(path[, options])](https://nodejs.org/docs/latest-v25.x/api/sqlite.html#new-databasesyncpath-options), which means the prefix is not required. This needs to be re-written to account for `allowBareNamedParameters` defaulting to true not false.\n\nExample showing `allowBareNamedParameters` defaults to true:\n\n```js\nimport { DatabaseSync } from 'node:sqlite';\nconst db = new DatabaseSync(':memory:');\n\ndb.exec('CREATE TABLE t (c1, c2, c3)');\n\n// named parameters $c1, $c2, $c3\nconst insert = db.prepare('INSERT INTO t VALUES ($c1, $c2, $c3)');\n\n// bare named parameters, prefix not required by default\ninsert.run({ c1: 1, c2: 2, c3: 3 });\n\nconsole.log(db.prepare('SELECT * FROM t').get());\n// { c1: 1, c2: 2, c3: 3 }\n```\n\n","author":{"url":"https://github.com/mike-git374","@type":"Person","name":"mike-git374"},"datePublished":"2026-02-14T20:53:14Z","url":"https://github.com/nodejs/node/issues/61823"}