Support Index Creation and TTL Modification in a Single ALTER Query

Why it matters

This feature improves efficiency and convenience by allowing users to execute multiple related changes in one atomic ALTER operation. It eliminates the need for multiple queries to create and materialize indexes or to modify and materialize TTLs separately, simplifying schema maintenance and reducing operational overhead.

How to use it

Users can now write a single ALTER TABLE query that includes both index creation and materialization clauses, or both TTL modification and materialization clauses. For example, combining ALTER TABLE ... ADD INDEX ... MATERIALIZE INDEX or ALTER TABLE ... MODIFY TTL ... MATERIALIZE TTL in one query.