in reply to RFC: Placeholder creation for SQL statements
What you call "cumbersome" and "more work," though, might make the code more maintainable in the long run. Code changes are usually made through version-control commits which are tied to work-order or trouble tickets. The delta within that commit describes exactly what was changed, and it should be seen to be specific to the problem. Also, the change should minimize testing impact – we should not have to go back and see if other, unrelated code is now broken. If you create "clever" code to do something you might create a black-hole which can't be readily touched ... and/or that can't be instantly understood. DBI already has the ability to pass an array of placeholder values to a query so that they will be substituted for the ? marks left-to-right.