Struct Cte 

pub struct Cte { /* private fields */ }

A Common Table Expression (WITH clause).

Implementations

impl Cte

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

Create a new non-recursive CTE.

Arguments

• name - The name of the CTE (used to reference it in the main query)

Example

let recent_orders = Cte::new("recent_orders")
    .as_select("SELECT * FROM orders WHERE created_at > NOW() - INTERVAL '7 days'");

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

Create a new recursive CTE.

Recursive CTEs require an initial (anchor) term and a recursive term joined with UNION ALL.

Example

// Traverse an employee hierarchy
let hierarchy = Cte::recursive("org_chart")
    .columns(&["id", "name", "level"])
    .as_select("SELECT id, name, 0 FROM employees WHERE manager_id IS NULL")
    .union_all("SELECT e.id, e.name, h.level + 1 FROM employees e JOIN org_chart h ON e.manager_id = h.id");

pub fn columns(self, cols: &[&str]) -> Self

Specify column aliases for the CTE.

Example

Cte::new("totals")
    .columns(&["category", "total_amount"])
    .as_select("SELECT category, SUM(amount) FROM orders GROUP BY category");

pub fn as_select(self, sql: impl Into<String>) -> Self

Set the CTE query from a raw SQL string.

Arguments

• sql - The SQL query for the CTE

pub fn as_select_with_params( self, sql: impl Into<String>, params: Vec<Value>, ) -> Self

Set the CTE query from SQL with parameters.

Arguments

• sql - The SQL query for the CTE
• params - Parameters to bind

pub fn union_all(self, sql: impl Into<String>) -> Self

Add a UNION ALL clause for recursive CTEs.

Arguments

• sql - The recursive term SQL

pub fn union_all_with_params( self, sql: impl Into<String>, params: Vec<Value>, ) -> Self

Add a UNION ALL clause with parameters.

pub fn name(&self) -> &str

Get the name of this CTE.

pub fn is_recursive(&self) -> bool

Check if this is a recursive CTE.

pub fn as_ref(&self) -> CteRef

Create a reference to this CTE for use in queries.

Example

let cte = Cte::new("active_users").as_select("...");
let cte_ref = cte.as_ref();

// Use in expressions
let expr = cte_ref.col("name").eq("Alice");

pub fn build(&self, dialect: Dialect) -> (String, Vec<Value>)

Build the CTE definition SQL.

Returns the SQL for use in a WITH clause and the parameters.

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.