Struct CTEView 

pub struct CTEView<'a, Table, Query> {
    pub table: Table,
    /* private fields */
}

A CTE (Common Table Expression) view that wraps an aliased table with its defining query.

This struct enables type-safe CTE usage by combining:

• An aliased table instance for typed field access
• The CTE definition (query) for the WITH clause

Example

let active_users = builder
    .select((user.id, user.name))
    .from(user)
    .as_cte("active_users");

// active_users.name works via Deref to the aliased table
builder
    .with(&active_users)
    .select(active_users.name)
    .from(&active_users)

Fields

table: Table

The aliased table for typed field access

Implementations

impl<'a, Table, Query> CTEView<'a, Table, Query>

where Query: ToSQL<'a, SQLiteValue<'a>>,

pub fn new(table: Table, name: &'static str, query: Query) -> Self

Creates a new CTEView with the given aliased table, name, and query.

pub fn cte_name(&self) -> &'static str

Returns the CTE name.

pub fn query(&self) -> &Query

Returns a reference to the underlying query.

Trait Implementations

impl<'a, Table, Query> CTEDefinition<'a> for &CTEView<'a, Table, Query>

where Query: ToSQL<'a, SQLiteValue<'a>>,

CTEDefinition for references.

fn cte_definition(&self) -> SQL<'a, SQLiteValue<'a>>

Returns the SQL for the CTE definition (e.g., “cte_name AS (SELECT …)”)

impl<'a, Table, Query> CTEDefinition<'a> for CTEView<'a, Table, Query>

where Query: ToSQL<'a, SQLiteValue<'a>>,

CTEDefinition implementation for CTEView.

fn cte_definition(&self) -> SQL<'a, SQLiteValue<'a>>

Returns the SQL for the CTE definition (e.g., “cte_name AS (SELECT …)”)

impl<'a, Table: Clone, Query: Clone> Clone for CTEView<'a, Table, Query>

fn clone(&self) -> CTEView<'a, Table, Query>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<'a, Table: Debug, Query: Debug> Debug for CTEView<'a, Table, Query>

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

Formats the value using the given formatter.

impl<'a, Table, Query> Deref for CTEView<'a, Table, Query>

Deref to the aliased table for field access.

type Target = Table

The resulting type after dereferencing.

fn deref(&self) -> &Self::Target

Dereferences the value.

impl<'a, Table, Query> ToSQL<'a, SQLiteValue<'a>> for CTEView<'a, Table, Query>

where Query: ToSQL<'a, SQLiteValue<'a>>,

ToSQL implementation renders just the CTE name for use in FROM clauses. Unlike aliased tables (which render as “original” AS “alias”), CTEs should just render as their name since they’re already defined in the WITH clause.

fn to_sql(&self) -> SQL<'a, SQLiteValue<'a>>

fn alias(&self, alias: &'static str) -> SQL<'a, V>