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'
@aiden-f-dsouza▲ 4 net votes
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.