sql-params-format
a wrapper around pg-format to allow named parameters to sql queries.
// default usage, no named params. operates just like pg-formatconst sql = 'insert into %I (select * from foo where %s and bar > %L)';const formatted = ; insert into // using named parameters const sql = 'insert into %I:one (select * from foo where %s:two and bar > %L:three)';const formatted = ; insert into
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.