Struct Cte 

pub struct Cte {
    pub name: Cow<'static, str>,
    pub columns: Vec<Cow<'static, str>>,
    pub query: Option<Expr>,
    pub materialized: Option<bool>,
    pub search: CteSearch,
    pub cycle: CteCycle,
}

One common table expression.

From PostgreSQL 17, https://www.postgresql.org/docs/17/sql-select.html:

with_query_name [ ( column_name [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( select | … )
    [ SEARCH { BREADTH | DEPTH } FIRST BY column_name [, ...] SET search_seq_col_name ]
    [ CYCLE column_name [, ...] SET cycle_mark_col_name
      [ TO cycle_mark_value DEFAULT cycle_mark_default ] USING cycle_path_col_name ]

The SQL standard allows only a SELECT here; PostgreSQL also allows INSERT/UPDATE/DELETE, which is why query is an ordinary expression and not something narrower.

Fields

name: Cow<'static, str>

The name the rest of the statement refers to. Quoted on output.

columns: Vec<Cow<'static, str>>

Column names for the result. Quoted.

query: Option<Expr>

The query, rendered inside parentheses.

materialized: Option<bool>

MATERIALIZED / NOT MATERIALIZED. None writes neither and leaves the choice to the planner — which is not the same as either, so this is genuinely three-valued.

search: CteSearch

SEARCH …, for a recursive CTE.

cycle: CteCycle

CYCLE …, for a recursive CTE over cyclic data.

Implementations

impl Cte

pub fn new(name: impl Into<Cow<'static, str>>, query: impl IntoExpr) -> Self

A named CTE over query.

pub fn is_empty(&self) -> bool

Whether this is an untouched CTE, so that nothing will be written.

Trait Implementations

impl Clone for Cte

fn clone(&self) -> Cte

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Cte

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

Formats the value using the given formatter.

impl Default for Cte

fn default() -> Cte

Returns the “default value” for a type.

impl Expression for Cte

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.