v.21.6Experimental Feature

Add PROJECTION support for MergeTree tables

Add PROJECTION support for MergeTree* tables. #20202 (Amos Bird).
Adds support for PROJECTION to MergeTree* tables in ClickHouse.

Why it matters

This feature enables the use of PROJECTIONs on MergeTree* table engines, improving query performance by allowing pre-aggregated or filtered subsets of data to be utilized efficiently.

How to use it

Define PROJECTIONs within your MergeTree* table schema to enable optimized query execution that leverages these projections automatically.