ydb/yt/yql/tests/sql/suites/materialize, branch main

Change `MATERIALIZE` grammar to exclude `WITH` statement ambiguity

2026-07-10T15:57:46Z

#### Change MATERIALIZE grammar to exclude hints ambiguity ✎ - Restructured the MATERIALIZE statement grammar to resolve ambiguity between table hints and cluster specification by reordering clauses to place hints after the target cluster - Updated minimum language version requirement for the MATERIALIZE feature to 2026.02 - Modified format tests and validation logic to align with the new grammar structure - Added tests for single and multiple hints to ensure proper parsing and handling - Updated canonical test outputs to reflect the new syntax order with hints positioned after the INTO clause and before the ON clause Autodescription by Yandex Code Assistant commit_hash:0dec4e34cf45e66962a8e8884c6cee893ad3dfb2

Support PruneUnusedColumns in Materialize

2026-07-10T09:30:27Z

#### Support PruneUnusedColumns in Materialize ✎ - Adds support for the `prune_unused_columns` setting in Materialize operations, enabling optimization to remove unused columns from materialized tables - Extends the YtProvider to recognize and validate the new PruneUnusedColumns setting for both Materialize and Persist operations - Implements optimizations to handle column pruning in Materialize operations, including handling ExtractMembers over Materialize cases and multi-usage scenarios - Updates physical finalizing logic to properly handle Persist operations with PruneUnusedColumns setting - Adds new test cases to verify the functionality of column pruning in Materialize operations with various filtering scenarios - Modifies existing tests to reflect changes in behavior and ensure compatibility with the new optimization feature Autodescription by Yandex Code Assistant commit_hash:83c18981b8767ac2b789c1b1ae81aaa1ee164a92

Support new Materialize in YT provider

2026-07-03T19:55:44Z

#### Support new Materialize in YT provider ✎ - Introduces support for the new Materialize operation in the YT provider, enabling materialization of query results into temporary tables - Adds necessary type annotations, constraint handling, and execution logic for the Materialize operation - Implements physical optimization rules to properly handle Materialize operations during query planning - Includes support for persisting materialized data and integrating it with existing YT operations like Publish and Copy - Adds comprehensive test cases covering various Materialize scenarios including basic usage, sorting preservation, and complex expressions - Updates SQL-to-YQL conversion to properly handle Materialize statements in SQL queries Autodescription by Yandex Code Assistant commit_hash:f915520020d0958e0e8c2a298b197564d3298675