MergeInsertExpr in sqlparser::ast

MergeInsertExpr in sqlparser::ast - Rust

Struct MergeInsertExpr

pub struct MergeInsertExpr {
    pub insert_token: AttachedToken,
    pub columns: Vec<ObjectName>,
    pub kind_token: AttachedToken,
    pub kind: MergeInsertKind,
    pub insert_predicate: Option<Expr>,
}

Expand description

The expression used to insert rows within a MERGE statement.

Examples

INSERT (product, quantity) VALUES(product, quantity)
INSERT ROW

Snowflake BigQuery Oracle

The INSERT token that starts the sub-expression.

§columns: Vec<ObjectName>

Columns (if any) specified by the insert.

Example:

INSERT (product, quantity) VALUES(product, quantity)
INSERT (product, quantity) ROW

The token, [VALUES | ROW] starting kind.

The insert type used by the statement.

An optional condition to restrict the insertion (Oracle specific)