Struct SetOperation 

pub struct SetOperation { /* private fields */ }

A set operation combining multiple queries.

Implementations

impl SetOperation

pub fn new(query_sql: impl Into<String>, params: Vec<Value>) -> Self

Create a new set operation from a single query.

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

Add a UNION operation with another query.

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

Add a UNION ALL operation with another query.

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

Add an INTERSECT operation with another query.

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

Add an INTERSECT ALL operation with another query.

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

Add an EXCEPT operation with another query.

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

Add an EXCEPT ALL operation with another query.

pub fn order_by(self, order: OrderBy) -> Self

Add ORDER BY to the final result.

pub fn order_by_many(self, orders: Vec<OrderBy>) -> Self

Add multiple ORDER BY clauses.

pub fn limit(self, limit: u64) -> Self

Set LIMIT on the final result.

pub fn offset(self, offset: u64) -> Self

Set OFFSET on the final result.

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

Build the SQL query with default dialect (PostgreSQL).

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

Build the SQL query with a specific dialect.

Trait Implementations

impl Clone for SetOperation

fn clone(&self) -> SetOperation

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for SetOperation

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

Formats the value using the given formatter.