It appears that the answer to my question is that it is not possible to do in a single transaction but instead requires a rather large query to be dynamically...