Does not accept placeholder names that begin with underscore ('_')

[rmullenix]

When the parameter names lead with an underscore, they are ignored by the system.

'use strict';
const nph = require('named-placeholders')();

let query = 'SELECT 1 + :_foo + :bar;';
let params = {'_foo': 2, 'bar': 3 };

let q = nph(query, params);

console.log(q[0]);  // SELECT 1 + :_foo + ?;
console.log(q[1]); // [ 3 ]

MySQL allows for column names to lead with an underscore and Javascript allows for Object properties to lead with an underscore, so this should be supported behavior.

[sidorares]

should be an easy fix to

named-placeholders/index.js

Line 4 in 83bf8eb

var RE_PARAM = /(?:\?)|(?::(\d+|(?:[a-zA-Z][a-zA-Z0-9_]*)))/g,

regex

[rmullenix]

Yup.. I made a local edit to add the _ to the initial regex and it worked great

[sidorares]

feel free to add a test and submit pr!

[rmullenix]

Submitted PR