Struct InsertSelectStmt 

pub struct InsertSelectStmt {
    pub table: TableName,
    pub columns: Vec<ColumnName>,
    pub select_exprs: Vec<Expr>,
    pub unnest: Unnest,
    pub on_conflict: Option<OnConflict>,
    pub returning: Vec<ColumnName>,
}

An INSERT … SELECT statement for bulk inserts.

Used with UNNEST for efficient bulk operations:

INSERT INTO products (handle, status, created_at)
SELECT handle, status, NOW()
FROM UNNEST($1::text[], $2::text[]) AS t(handle, status)
RETURNING id, handle, status

Fields

table: TableName

The table to insert into.

columns: Vec<ColumnName>

Column names for the insert.

select_exprs: Vec<Expr>

Expressions to select (parallel to columns).

unnest: Unnest

The UNNEST source.

on_conflict: Option<OnConflict>

Optional ON CONFLICT clause for upsert behavior.

returning: Vec<ColumnName>

Columns to return after insert (RETURNING clause).

Implementations

impl InsertSelectStmt

pub fn new(table: TableName, unnest: Unnest) -> Self

pub fn column(self, name: ColumnName, expr: Expr) -> Self

Add a column with its select expression.

pub fn on_conflict(self, conflict: OnConflict) -> Self

pub fn returning(self, cols: impl IntoIterator<Item = ColumnName>) -> Self

Trait Implementations

impl Clone for InsertSelectStmt

fn clone(&self) -> InsertSelectStmt

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for InsertSelectStmt

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

Formats the value using the given formatter.

impl Render for InsertSelectStmt

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