Draft: Fix/acknowledge more cross-DB modifications

What does this MR do and why?

This is based on !78098 (merged) which needs to be merged first.

This MR shrinks allowlist even further by fixing specs or adding allow_cross_database_modification_within_transaction.

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.