Struct Cte 

pub struct Cte {
    pub name: String,
    pub columns: Vec<String>,
    pub query: String,
    pub recursive: bool,
    pub materialized: Option<Materialized>,
    pub search: Option<SearchClause>,
    pub cycle: Option<CycleClause>,
}

A Common Table Expression (CTE) definition.

Fields

name: String

Name of the CTE (used in FROM clause).

columns: Vec<String>

Optional column aliases.

query: String

The query that defines the CTE.

recursive: bool

Whether this is a recursive CTE.

materialized: Option<Materialized>

PostgreSQL: MATERIALIZED / NOT MATERIALIZED hint.

search: Option<SearchClause>

Search clause for recursive CTEs (PostgreSQL).

cycle: Option<CycleClause>

Cycle detection for recursive CTEs (PostgreSQL).

Implementations

impl Cte

pub fn new(name: impl Into<String>) -> Self

Create a new CTE with the given name.

pub fn builder(name: impl Into<String>) -> CteBuilder

Create a new CTE builder.

pub fn columns<I, S>(self, columns: I) -> Self

where I: IntoIterator<Item = S>, S: Into<String>,

Set the column aliases.

pub fn as_query(self, query: impl Into<String>) -> Self

Set the query that defines this CTE.

pub fn recursive(self) -> Self

Mark this as a recursive CTE.

pub fn materialized(self, mat: Materialized) -> Self

Set materialization hint (PostgreSQL only).

pub fn to_sql(&self, db_type: DatabaseType) -> String

Generate the CTE definition SQL.

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<'de> Deserialize<'de> for Cte

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for Cte

fn eq(&self, other: &Cte) -> 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 Serialize for Cte

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for Cte

impl StructuralPartialEq for Cte