Make dynamic SQL a little easier
ethanpailes opened this issue · 0 comments
ethanpailes commented
We don't need a full-on query builder, but I think it might be worth giving people some support on lining up query indexes. You should be able to pass in a string with a number of ?
s and ??
s embedded in it. ??
s become literal ?
and ?
get replaced by an ascending-order number. Maybe we allow ?<identifier>
so that you can re-use the same arg in multiple places in the query. You could also pass in the actual arguments so that we can sanity check the length of the argument list against the generated query string. I think type checking would be a bridge too far.