at one point i was using upserts for everything but then had a case where it was impossible to get it working with generated id.

wrote about it very roughly here https://blog.geekodour.org/posts/upserts/