Struct MergeBuilder 

pub struct MergeBuilder { /* private fields */ }

Fluent builder for constructing MERGE INTO statements.

Created by the merge_into() entry-point function.

Implementations

impl MergeBuilder

pub fn using(self, source: &str, on: Expr) -> Self

Set the source table and ON join condition.

pub fn when_matched_update(self, assignments: Vec<(&str, Expr)>) -> Self

Add a WHEN MATCHED THEN UPDATE SET clause.

pub fn when_matched_update_where( self, condition: Expr, assignments: Vec<(&str, Expr)>, ) -> Self

Add a WHEN MATCHED THEN UPDATE SET clause with an additional condition.

pub fn when_matched_delete(self) -> Self

Add a WHEN MATCHED THEN DELETE clause.

pub fn when_not_matched_insert( self, columns: &[&str], values: Vec<Expr>, ) -> Self

Add a WHEN NOT MATCHED THEN INSERT (cols) VALUES (vals) clause.

pub fn build(self) -> Expression

Consume this builder and produce the final Expression::Merge AST node.

pub fn to_sql(self) -> String

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