feat(sql): introduce WAIT APPLIED (GLOBALLY | LOCALLY ) options for DDL operations

NOTE: It was previously reviewed and merged in !1265 (merged), but it was later reverted in !1278 (merged). See #728 (comment 102049) for details.

Summary

• feat(sql): introduce WAIT APPLIED (GLOBALLY | LOCALLY ) options for DDL operations

---

• Close #728 (closed)
• Cherry-pick to: none
• Docs follow-up: docs#376 (closed)
• Depends on sbroad!516 (merged)