Further parser changes for ALTER TABLE ADD COLUMN and certain options

Summary

• test: alter table timeout and wait applied

• feat: add timeout and wait_applied_globally options to alter table

• feat: alter table parsing

---

• Relates to #327
• Cherry-pick to: none
• Docs follow-up: docs#484 (closed)
• Changelog is updated