Struct WithClauseRef 

pub struct WithClauseRef<'a> {
    pub ctes: SmallVec<[CteRef<'a>; 4]>,
    pub recursive: bool,
}

A builder for WITH clauses using zero-copy CTEs.

Example

use prax_query::zero_copy::{CteRef, WithClauseRef};
use prax_query::sql::DatabaseType;

let with = WithClauseRef::new()
    .cte(CteRef::new("active_users")
        .columns(&["id", "name"])
        .query("SELECT id, name FROM users WHERE active = true"))
    .cte(CteRef::new("recent_orders")
        .columns(&["user_id", "total"])
        .query("SELECT user_id, SUM(amount) FROM orders GROUP BY user_id"));

let sql = with.build_select(&["*"], "active_users", DatabaseType::PostgreSQL);

Fields

ctes: SmallVec<[CteRef<'a>; 4]>

CTEs in this WITH clause.

recursive: bool

Whether this is a recursive WITH.

Implementations

impl<'a> WithClauseRef<'a>

pub fn new() -> Self

Create a new empty WITH clause.

pub fn cte(self, cte: CteRef<'a>) -> Self

Add a CTE.

pub fn recursive(self) -> Self

Mark as recursive.

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

Build the WITH clause SQL.

pub fn build_select( &self, columns: &[&str], from: &str, db_type: DatabaseType, ) -> String

Build a complete SELECT query with this WITH clause.

Trait Implementations

impl<'a> Clone for WithClauseRef<'a>

fn clone(&self) -> WithClauseRef<'a>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<'a> Debug for WithClauseRef<'a>

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

Formats the value using the given formatter.

impl<'a> Default for WithClauseRef<'a>

fn default() -> WithClauseRef<'a>

Returns the “default value” for a type.