Is your feature request related to a problem? Please describe.
In general, we want to minimize locking time when interacting with Cockroach DB.

When removing and mutating Operational Intent References (OIR), we may do several round-trips to the database.

It is likely that these could be reduced (by eg moving some logic to the SQL and have it executed at the database level)

Describe the solution you'd like
The logic that has been factored into a separate method in #1057 could possibly be directly integrated into some CRDB queries, instead of the current back-and forth between the database and the backend.

Describe alternatives you've considered
An option is to keep things as-is: this is not urgent but is worth keeping track off.

Whether or not it is worth doing this right away depends on how easy we can push down the cleanup: I'll spend a little bit of time investigating this. If anyone things it is not worth the effort at the moment, please let me know.

Additional context
The opportunity for pushing down the cleanup logic became apparent while investigating some dangling implicit subscription issue for the uss_qualifier that led to #1057

Note that with #1057, creation or update of any OIR with implicit subscriptions requires at least an additional roundtrip to the database, so the present issue feels worth adressing.

Tasks

• deletion: [dss] scd: inline oir deletion implicit subscription cleanup into CRDB calls #1107
• upsert: [dss] scd: oir upsert - inline cleanup of implicit subscription into CRDB #1064
• update CI qualifier config to cover these with the implicit cleanup scenario