Support for ALTER TABLE t DELETE WHERE in Non-Replicated MergeTree Tables

Why it matters

This feature enables users to delete rows based on a condition from non-replicated MergeTree tables using the ALTER TABLE ... DELETE WHERE syntax. Previously, this operation was only available for replicated tables, so this enhancement increases flexibility and usability for non-replicated table management.

How to use it

Use the ALTER TABLE table_name DELETE WHERE condition SQL statement to delete rows matching the specified condition from a non-replicated MergeTree table. For example:

ALTER TABLE t DELETE WHERE <condition>;