Struct Insert 

pub struct Insert<X: Extension = NoExt> {
    pub verb: InsertVerb,
    pub modifier: Option<InsertModifier>,
    pub or_action: Option<ConflictResolution>,
    pub with: Option<With<X>>,
    pub target: InsertTarget,
    pub column_matching: Option<InsertColumnMatching>,
    pub overriding: Option<InsertOverriding>,
    pub source: InsertSource<X>,
    pub row_alias: Option<TableAlias>,
    pub upsert: Option<Box<Upsert<X>>>,
    pub returning: Option<Returning<X>>,
    pub meta: Meta,
}

An SQL insert.

Fields

verb: InsertVerb

Whether this was spelled INSERT or MySQL REPLACE (a surface tag over one shape; see InsertVerb).

modifier: Option<InsertModifier>

Optional post-verb modifier.

or_action: Option<ConflictResolution>

The SQLite INSERT OR <action> conflict-resolution algorithm on the verb, gated by MutationSyntax::or_conflict_action; None when unwritten (and always None on the InsertVerb::Replace spelling, which is the conflict resolution and takes no OR <action>). A distinct slot from upsert: the OR <action> prefix and the ON CONFLICT tail are different constructs (SQLite forbids both on one statement), never one overloaded field. See ConflictResolution.

with: Option<With<X>>

Common table expressions visible to this statement.

target: InsertTarget

Object targeted by this syntax.

column_matching: Option<InsertColumnMatching>

DuckDB BY NAME / BY POSITION between target and source; None when unwritten.

overriding: Option<InsertOverriding>

Optional overriding for this syntax.

source: InsertSource<X>

Input source for this syntax.

row_alias: Option<TableAlias>

MySQL 8.0.19+ row alias — INSERT ... VALUES (...) AS <alias>[(<col>, ...)], the modern replacement for VALUES(<col>) inside ON DUPLICATE KEY UPDATE. Parsed between the source and the upsert clause and gated by the same dialect data as ON DUPLICATE KEY UPDATE (MutationSyntax::on_duplicate_key_update) — the alias is the input side of that MySQL upsert surface, and no shipped dialect admits one without the other. Reuses the shared TableAlias shape (a name plus an optional column-alias list), never a parallel alias type; None when unwritten.

upsert: Option<Box<Upsert<X>>>

Upsert clause — insert-or-update on a unique-key conflict (gated by dialect data). One canonical field for the mutually-exclusive dialect spellings (see Upsert); boxed because the clause is heavy (its PostgreSQL arm carries two child lists) and absent from the common non-upsert INSERT, so the box keeps the inline Insert lean.

returning: Option<Returning<X>>

Expressions returned by the statement.

meta: Meta

Source location and node identity.

Trait Implementations

impl<X: Clone + Extension> Clone for Insert<X>

fn clone(&self) -> Insert<X>

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl<X: Debug + Extension> Debug for Insert<X>

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

Formats the value using the given formatter.

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

where X: Deserialize<'de> + Extension,

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl<X: Eq + Extension> Eq for Insert<X>

impl<X: Hash + Extension> Hash for Insert<X>

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<X: PartialEq + Extension> PartialEq for Insert<X>

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

Equality operator ==.

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

Inequality operator !=.

impl<X: Extension + Render> Render for Insert<X>

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

Return the render for this value.

fn operand_binding_power(&self) -> Option<BindingPower>

The binding power this node contributes when it appears as an operand, or None (the default) for a self-delimiting node — an atom, call, or constructor — that never needs parentheses.

impl<X> Serialize for Insert<X>

where X: Serialize + Extension,

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl<X: Extension> Spanned for Insert<X>

fn span(&self) -> Span

Return the span for this value.

impl<X: PartialEq + Extension> StructuralPartialEq for Insert<X>