Struct CTEHoister 

pub struct CTEHoister { /* private fields */ }

CTE Hoister - Analyzes and rewrites nested CTEs

This module implements automatic CTE hoisting to transform nested WITH clauses into a flat list of CTEs at the query’s top level. This enables natural nested query writing while maintaining compatibility with SQL execution.

Example transformation:

-- Input (nested):
SELECT * FROM (
  WITH inner_cte AS (SELECT ...)
  SELECT * FROM inner_cte
)

-- Output (hoisted):
WITH inner_cte AS (SELECT ...)
SELECT * FROM inner_cte

Implementations

impl CTEHoister

pub fn new() -> Self

pub fn hoist_ctes(statement: SelectStatement) -> SelectStatement

Hoist all nested CTEs to the top level