Named parameters facilitate building advanced queries.
This implementation simply converts the sql statement into the version
with “?” and builds an array of parameters to be passed in.
Two tests are written and they are passing.
There are few caveats as to how to use the function, but accounting for
named parameter like text within quotes is not easy without writing a
parser.
The workaround provided for this rare case is to pass in custom regexes.
Named parameters facilitate building advanced queries. This implementation simply converts the sql statement into the version with “?” and builds an array of parameters to be passed in. Two tests are written and they are passing. There are few caveats as to how to use the function, but accounting for named parameter like text within quotes is not easy without writing a parser. The workaround provided for this rare case is to pass in custom regexes.