GeezerVison

Summary
This PR addresses the issue with #2114 to parse specific MySQL-specific features in ALTER TABLE statements, such as ENCRYPTION, AUTO_INCREMENT, and ENGINE options. Previously, these clauses were categorized as UNSPECIFIC.

Changes
Modified the parser to correctly identify and handle the ENCRYPTION option in ALTER TABLE statements.
Added support for parsing the AUTO_INCREMENT option in ALTER TABLE statements.
Implemented parsing functionality for the ENGINE option in ALTER TABLE statements.
These options are now categorized under SET_TABLE_OPTION instead of UNSPECIFIC.

References
MySQL Documentation: ALTER TABLE Partition Operations