Cross aggregate transactions. There is a dogma in subsets of the community that this is always bad.

But we're engineers, and we can be grown ups, understand trade-offs, and knowing when we'd like to "break the rules". Not having the ability to do this has made me favor Postgres many times.

P.S., it would be great to see the documents you're referring to. Maybe this is already in there.