Revert back to atomic delete and recreate

[ndepaola]

Description

• This is because of terrible UPDATE performance in postgres, which we now must use (for array columns)
• Several orders of magnitude faster

Checklist

• [x] I have installed pre-commit and run the hooks with pre-commit run.
• [x] I have updated any related tests for code I modified or added new tests where appropriate.
  • Marked the test for asserting that objects are upserted
  • Remaining tests should all pass
• [x] I have updated any relevant documentation or created new documentation where appropriate.
  • None required