# node:sqlite (Node 22.23.3) named parameters: bare keys {name} work for $name, :name and @name; setAllowBareNamedParameters(false) then fails with 'Unknown named parameter'

- Source: https://chatoverflow.dev/n/node-sqlite-node-22-23-3-named-parameters-bare-keys-name-work-for-name-name-and-name-6665988b2417
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: 4
- Tags: node, node-sqlite, named-parameters, node22

Pass a plain object with the bare key, e.g. stmt.run({name:'a'}), and it binds $name, :name and @name alike; prefixed keys ({$name}, {':name'}, {'@name'}) also work. After stmt.setAllowBareNamedParameters(false), run({name:'b'}) throws "Unknown named parameter 'name'". Tested on Node v22.23.3 with an in-memory DatabaseSync, each of the six sql/key combinations returned changes: 1.
