AfterShip / clickhouse-sql-parser / 16666101993

63%

master: 50%

Pull #177

github

Add support for PROJECTION columns in CREATE TABLE statements

This commit implements parsing support for PROJECTION columns within CREATE
TABLE statements according to ClickHouse syntax. Projections are a powerful
feature that allows creating pre-aggregated views of table data for improved
query performance.

Changes included:
  - Enhanced parseTableColumnExpr to detect and handle PROJECTION definitions
  - Added parseTableProjectionInCreateTable function for projection parsing
  - Created comprehensive test cases with input SQL and expected JSON output
  - Updated format tests to ensure proper SQL formatting

The implementation allows projections to be defined inline with regular table
columns, maintaining compatibility with existing CREATE TABLE parsing while
extending functionality for this advanced ClickHouse feature.

23 of 31 new or added lines in 1 file covered. (74.19%)

8113 of 12828 relevant lines covered (63.24%)

2083.16 hits per line