Struct InsertBuilder 

pub struct InsertBuilder { /* private fields */ }

Fluent builder for constructing INSERT INTO statements.

Created by the insert_into() entry-point function. Supports specifying target columns via .columns(), row values via .values() (can be called multiple times for multiple rows), and INSERT … SELECT via .query().

Implementations

impl InsertBuilder

pub fn columns<I, S>(self, columns: I) -> Self

where I: IntoIterator<Item = S>, S: AsRef<str>,

Set the target column names for the INSERT statement.

pub fn values<I>(self, values: I) -> Self

where I: IntoIterator<Item = Expr>,

Append a row of values to the VALUES clause.

Call this method multiple times to insert multiple rows in a single statement.

pub fn query(self, query: SelectBuilder) -> Self

Set the source query for an INSERT INTO ... SELECT ... statement.

When a query is set, the VALUES clause is ignored during generation.

pub fn build(self) -> Expression

Consume this builder and produce the final Expression::Insert AST node.

pub fn to_sql(self) -> String

Consume this builder, generate, and return the SQL string.