sql-params-format

a wrapper around pg-format to allow named parameters to sql queries.

1// default usage, no named params.  operates just like pg-format
2const sql = 'insert into %I (select * from foo where %s and bar > %L)';
3const formatted = format(sql, 'a_table', 'something=another', 123);
4  formatted => insert into a_table (select * from foo where something=another and bar > '123')
5
6// using named parameters
7
8const sql = 'insert into %I:one (select * from foo where %s:two and bar > %L:three)';
9const formatted = format(sql, {one: 'a_table', two: 'something=another', three: 123});
10  formatted => insert into a_table (select * from foo where something=another and bar > '123')
11

It will ignore any unused named parameters. Parameters used more than once in the query need only be passed once.

Special note, this will convert moment objects to date objects if passed as parameters.