Implement DDL execution for ALTER TABLE ADD COLUMN

Summary

• test: alter table logic

• test: sqltester expect no error on - error

• fix: null/not null alter table parsing

• feat: alter table ddl execution

---

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