feat: initial dml support for global tbls

Summary

• feat: support dml for global tbls

---

• Close sbroad#577 (closed)
• Changes should be cherry-picked to 24.2: no
• Docs follow-up: docs#266 (closed)

Depends on sbroad!429 (merged)