MergeClause in sqlparser::ast - Rust

Struct MergeClause 

Source

pub struct MergeClause {
    pub when_token: AttachedToken,
    pub clause_kind: MergeClauseKind,
    pub predicate: Option<Expr>,
    pub action: MergeAction,
}
Expand description

A WHEN clause within a MERGE Statement

Example:

WHEN NOT MATCHED BY SOURCE AND product LIKE '%washer%' THEN DELETE

Snowflake BigQuery

The WHEN token that starts the sub-expression.

The type of WHEN clause.

An optional predicate to further restrict the clause.

The action to perform when the clause is matched.

§
§
§
§
§
§