Support ALTER SYSTEM

Summary

Successor to !1012 (closed). Rebased version with minor fixes

Corresponding sbroad MR: sbroad!479 (merged)

---

• Cherry-pick to: none
• Docs follow-up: docs#330 (closed)
• Related #723 (closed)