Struct CteChain 

pub struct CteChain { /* private fields */ }

A common table expression under construction.

with("recent", body) is already a complete mod; the methods add the optional parts of SQLite’s common-table-expression production (https://www.sqlite.org/syntax/common-table-expression.html):

table-name [ ( column-name [, ...] ) ] AS [ [ NOT ] MATERIALIZED ] ( select-stmt )

PostgreSQL’s SEARCH and CYCLE sub-clauses have no counterpart in SQLite, so they are not reachable from here. Nor is a data-modifying CTE: SQLite’s grammar admits only a select-stmt between the parentheses.

Implementations

impl CteChain

pub fn columns( self, columns: impl IntoIterator<Item = impl Into<Cow<'static, str>>>, ) -> CteChain

Name the CTE’s output columns: WITH "c" ("a", "b") AS (…).

pub fn materialized(self) -> CteChain

AS MATERIALIZED (…) — compute it once into a transient table. SQLite 3.35 and later.

pub fn not_materialized(self) -> CteChain

AS NOT MATERIALIZED (…) — allow it to be folded into the outer query.

Trait Implementations

impl Clone for CteChain

fn clone(&self) -> CteChain

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for CteChain

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

Formats the value using the given formatter.

impl<Q: HasWith> Mod<Q> for CteChain

fn apply(self, q: &mut Q)

Apply this modification to q.