Struct SetOpBuilder 

pub struct SetOpBuilder { /* private fields */ }

Fluent builder for UNION, INTERSECT, and EXCEPT set operations.

Created by the free functions union(), union_all(), intersect(), intersect_all(), except_(), except_all(), or the corresponding methods on SelectBuilder. Supports optional .order_by(), .limit(), and .offset() clauses applied to the combined result.

Examples

use polyglot_sql::builder::*;

let sql = union_all(
    select(["id"]).from("a"),
    select(["id"]).from("b"),
)
.order_by(["id"])
.limit(10)
.to_sql();

Implementations

impl SetOpBuilder

pub fn order_by<I, E>(self, expressions: I) -> Self

where I: IntoIterator<Item = E>, E: IntoExpr,

Add an ORDER BY clause applied to the combined set operation result.

Expressions not already wrapped with .asc() or .desc() default to ascending order.

pub fn limit(self, count: usize) -> Self

Restrict the combined set operation result to count rows.

pub fn offset(self, count: usize) -> Self

Skip the first count rows from the combined set operation result.

pub fn build(self) -> Expression

Consume this builder and produce the final set operation Expression AST node.

The returned expression is one of Expression::Union, Expression::Intersect, or Expression::Except depending on how the builder was created.

pub fn to_sql(self) -> String

Consume this builder, generate, and return the SQL string.