Yes, ClickHouse supports copying new data from one table to another using the INSERT INTO ... SELECT syntax.

INSERT INTO target_table SELECT * FROM source_table WHERE condition;