pub struct Cte {
pub name: String,
pub aliases: Vec<String>,
pub columns: Vec<Column>,
pub query: Box<Query>,
pub recursive: bool,
pub materialized: Option<bool>,
pub search: Option<SearchClause>,
pub cycle: Option<CycleClause>,
pub write: Option<usize>,
}Expand description
A query of WITH after the analysis, as a CommonTableExpr of the list cteList of a query.
Fields§
§name: Stringctename.
aliases: Vec<String>The names of the columns after the name of the query, as aliascolnames.
columns: Vec<Column>The columns of the query, with the names of Cte::aliases first, then the columns of Cte::search and Cte::cycle.
query: Box<Query>The query as the statement gives it. With SEARCH or CYCLE, each reference reads the query after the rewrite of the clauses.
recursive: boolcterecursive: the query reads itself.
materialized: Option<bool>Some(true) for MATERIALIZED, Some(false) for NOT MATERIALIZED, None when the query gives neither.
search: Option<SearchClause>search_clause.
cycle: Option<CycleClause>cycle_clause.
write: Option<usize>For an INSERT, an UPDATE, a DELETE or a MERGE, the number of the statement among the statements of WITH of the statement that change data, in the order of their analysis. Then Cte::query is the statement, and a reference reads the rows of its RETURNING.