Struct CommonTableExpr 

pub struct CommonTableExpr {
    pub name: String,
    pub columns: Option<Vec<String>>,
    pub query: Box<SelectStmt>,
    pub recursive: bool,
    pub materialization: CteMaterialization,
}

Common Table Expression (CTE) definition

CTEs are temporary named result sets defined with the WITH clause that exist only for the duration of a single query.

Example: WITH regional_sales AS (SELECT region, SUM(amount) FROM orders GROUP BY region)

Recursive CTEs use UNION ALL to reference themselves: Example: WITH RECURSIVE counter(x) AS (VALUES(0) UNION ALL SELECT x+1 FROM counter WHERE x<10)

Fields

name: String

Name of the CTE

columns: Option<Vec<String>>

Optional column name list (e.g., WITH cte (col1, col2) AS (...))

query: Box<SelectStmt>

The query defining the CTE

recursive: bool

Whether this is a RECURSIVE CTE (SQLite/SQL:1999) Recursive CTEs must use UNION ALL and may reference themselves in the recursive term

materialization: CteMaterialization

Materialization hint for optimizer control (AS MATERIALIZED / AS NOT MATERIALIZED)

Trait Implementations

impl Clone for CommonTableExpr

fn clone(&self) -> CommonTableExpr

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for CommonTableExpr

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.

impl PartialEq for CommonTableExpr

fn eq(&self, other: &CommonTableExpr) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl ToSql for CommonTableExpr

fn to_sql(&self) -> String

Convert this AST node to a SQL string

impl StructuralPartialEq for CommonTableExpr