repsertMany admits backends to provide a custom implementation via connRepsertManySql. in the case of the postrgres backend, repsertMany becomes an atomic operation. It would be nice to take advantage of this for repsert as well. (it's fairly well known as a gotcha in our codebase but this would be a nice QoL improvement for us)

Before submitting your PR, check that you've:

• Documented new APIs with Haddock markup
• Added @since declarations to the Haddock
• Ran stylish-haskell on any changed files.
• Adhered to the code style (see the .editorconfig file for details)

After submitting your PR:

• Update the Changelog.md file with a link to your PR
• Bumped the version number if there isn't an (unreleased) on the Changelog
• Check that CI passes (or if it fails, for reasons unrelated to your change, like CI timeouts)