Support PostgreSQL ALTER MODIFY COLUMN Syntax

Why it matters

This feature introduces the ability to modify existing columns using the PostgreSQL style ALTER MODIFY COLUMN syntax. It simplifies schema changes by providing a familiar and concise syntax for users coming from PostgreSQL or those who prefer this style, improving usability and reducing errors in altering table structures.

How to use it

To use this feature, execute column modifications using the SQL syntax:

ALTER TABLE table_name MODIFY COLUMN column_name <datatype> [options];

This allows you to change the data type and attributes of an existing column directly.