Because I may want to insert a large number of rows. The above requires me to do so one by one, which is pretty inefficient. There are other ways to emulate up

Because I may want to insert a large number of rows. The above requires me to do so one by one, which is pretty inefficient. There are other ways to emulate upserts, but they tend to have performance and/or concurrency considerations.