Struct WithQuery 

pub struct WithQuery { /* private fields */ }

A query with one or more CTEs.

Implementations

impl WithQuery

pub fn new() -> Self

Create a new query with CTEs.

pub fn with_cte(self, cte: Cte) -> Self

Add a CTE to this query.

CTEs are added in order and can reference previously defined CTEs.

pub fn with_ctes(self, ctes: Vec<Cte>) -> Self

Add multiple CTEs to this query.

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

Set the main query.

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

Set the main query with parameters.

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

Build the complete SQL with WITH clause.

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

Build the complete SQL with a specific dialect.

Trait Implementations

impl Clone for WithQuery

fn clone(&self) -> WithQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for WithQuery

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

Formats the value using the given formatter.

impl Default for WithQuery

fn default() -> Self

Returns the “default value” for a type.