[PLA-16772] workaround for not having ACID transactions

---

Issue metadata

• Issue type: Sub-task
• Priority: Minor
• Parent issue: [PLA-16120] Inverse Search Staging MVP