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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for Insert

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for Insert

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

Formats the value using the given formatter.

impl From<Insert> for Statement

fn from(i: Insert) -> Self

Converts to this type from the input type.

impl Hash for Insert

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

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 Serialize for Insert

fn serialize<__S>(&self, __serializer: __S) -> Result<__S::Ok, __S::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.

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 Visit for Insert

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

Visit this node with the provided Visitor.

impl VisitMut for Insert

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

Mutably visit this node with the provided VisitorMut.

impl Eq for Insert

impl StructuralPartialEq for Insert