Struct Insert 

pub struct Insert {

    pub insert_token: AttachedToken,
    pub optimizer_hints: Vec<OptimizerHint>,
    pub or: Option<SqliteOnConflict>,
    pub ignore: bool,
    pub into: bool,
    pub table: TableObject,
    pub table_alias: Option<TableAliasWithoutColumns>,
    pub columns: Vec<ObjectName>,
    pub overwrite: bool,
    pub source: Option<Box<Query>>,
    pub assignments: Vec<Assignment>,
    pub partitioned: Option<Vec<Expr>>,
    pub after_columns: Vec<Ident>,
    pub has_table_keyword: bool,
    pub on: Option<OnInsert>,
    pub returning: Option<Vec<SelectItem>>,
    pub output: Option<OutputClause>,
    pub replace_into: bool,
    pub priority: Option<MysqlInsertPriority>,
    pub insert_alias: Option<InsertAliases>,
    pub settings: Option<Vec<Setting>>,
    pub format_clause: Option<InputFormatClause>,
    pub multi_table_insert_type: Option<MultiTableInsertType>,
    pub multi_table_into_clauses: Vec<MultiTableInsertIntoClause>,
    pub multi_table_when_clauses: Vec<MultiTableInsertWhenClause>,
    pub multi_table_else_clause: Option<Vec<MultiTableInsertIntoClause>>,
}

INSERT statement.

Fields

insert_token: AttachedToken

Token for the INSERT keyword (or its substitutes)

optimizer_hints: Vec<OptimizerHint>

Query optimizer hints

MySQL Oracle

or: Option<SqliteOnConflict>

Only for Sqlite

ignore: bool

Only for mysql

into: bool

INTO - optional keyword

table: TableObject

TABLE

table_alias: Option<TableAliasWithoutColumns>

table_name as foo (for PostgreSQL) table_name foo (for Oracle)

columns: Vec<ObjectName>

COLUMNS

overwrite: bool

Overwrite (Hive)

source: Option<Box<Query>>

A SQL query that specifies what to insert

assignments: Vec<Assignment>

MySQL INSERT INTO ... SET See: https://dev.mysql.com/doc/refman/8.4/en/insert.html

partitioned: Option<Vec<Expr>>

partitioned insert (Hive)

after_columns: Vec<Ident>

Columns defined after PARTITION

has_table_keyword: bool

whether the insert has the table keyword (Hive)

on: Option<OnInsert>

ON INSERT

returning: Option<Vec<SelectItem>>

RETURNING

output: Option<OutputClause>

OUTPUT (MSSQL) See https://learn.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql

replace_into: bool

Only for mysql

priority: Option<MysqlInsertPriority>

Only for mysql

insert_alias: Option<InsertAliases>

Only for mysql

settings: Option<Vec<Setting>>

Settings used for ClickHouse.

ClickHouse syntax: INSERT INTO tbl SETTINGS format_template_resultset = '/some/path/resultset.format'

ClickHouse INSERT INTO

format_clause: Option<InputFormatClause>

Format for INSERT statement when not using standard SQL format. Can be e.g. CSV, JSON, JSONAsString, LineAsString and more.

ClickHouse syntax: INSERT INTO tbl FORMAT JSONEachRow {"foo": 1, "bar": 2}, {"foo": 3}

ClickHouse formats JSON insert

multi_table_insert_type: Option<MultiTableInsertType>

For Snowflake multi-table insert: specifies the type (ALL or FIRST)

• None means this is a regular single-table INSERT
• Some(All) means INSERT ALL (all matching WHEN clauses are executed)
• Some(First) means INSERT FIRST (only the first matching WHEN clause is executed)

See: https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table

multi_table_into_clauses: Vec<MultiTableInsertIntoClause>

For multi-table insert: additional INTO clauses (unconditional)

Used for INSERT ALL INTO t1 INTO t2 ... SELECT ...

See: https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table

multi_table_when_clauses: Vec<MultiTableInsertWhenClause>

For conditional multi-table insert: WHEN clauses

Used for INSERT ALL/FIRST WHEN cond THEN INTO t1 ... SELECT ...

See: https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table

multi_table_else_clause: Option<Vec<MultiTableInsertIntoClause>>

For conditional multi-table insert: ELSE clause

See: https://docs.snowflake.com/en/sql-reference/sql/insert-multi-table

Trait Implementations

impl Clone for Insert

fn clone(&self) -> Insert

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Insert

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

Formats the value using the given formatter.

impl Display for Insert

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

Formats the value using the given formatter.

impl Eq for Insert

impl From<Insert> for Statement

fn from(i: Insert) -> Statement

Converts to this type from the input type.

impl Hash for Insert

fn hash<__H>(&self, state: &mut __H)

where __H: Hasher,

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for Insert

fn cmp(&self, other: &Insert) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for Insert

fn eq(&self, other: &Insert) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl PartialOrd for Insert

fn partial_cmp(&self, other: &Insert) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

fn lt(&self, other: &Rhs) -> bool

Tests less than (for self and other) and is used by the < operator.

fn le(&self, other: &Rhs) -> bool

Tests less than or equal to (for self and other) and is used by the <= operator.

fn gt(&self, other: &Rhs) -> bool

Tests greater than (for self and other) and is used by the > operator.

fn ge(&self, other: &Rhs) -> bool

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Spanned for Insert

partial span

Missing spans:ever

• Insert::insert_alias

fn span(&self) -> Span

Return the Span (the minimum and maximum Location) for this AST node, by recursively combining the spans of its children.

impl StructuralPartialEq for Insert

impl Visit for Insert

fn visit<V>(&self, visitor: &mut V) -> ControlFlow<<V as Visitor>::Break>

where V: Visitor,

Visit this node with the provided Visitor.

impl VisitMut for Insert

fn visit<V>(&mut self, visitor: &mut V) -> ControlFlow<<V as VisitorMut>::Break>

where V: VisitorMut,

Mutably visit this node with the provided VisitorMut.