Struct InsertBuilder 

pub struct InsertBuilder<T> { /* private fields */ }

Builder for INSERT queries. Implements Modifiable (for count). Call .select() to add RETURNING clause.

Implementations

impl<T> InsertBuilder<T>

pub fn schema(self, schema: &str) -> Self

Override the schema for this query.

Generates "schema"."table" instead of the default schema.

pub fn select(self) -> Self

Add RETURNING clause to get inserted rows back.

pub fn select_columns(self, columns: &str) -> Self

Add RETURNING clause with specific columns.

impl<T> InsertBuilder<T>

where T: DeserializeOwned + Send,

pub async fn execute(self) -> SupabaseResponse<T>

Execute the INSERT query.

Trait Implementations

impl<T> Modifiable for InsertBuilder<T>

fn parts_mut(&mut self) -> &mut SqlParts

Get a mutable reference to the SQL parts.

fn order(self, column: &str, direction: OrderDirection) -> Self

Order by a column.

fn order_with_nulls( self, column: &str, direction: OrderDirection, nulls: NullsPosition, ) -> Self

Order by a column with explicit nulls positioning.

fn limit(self, count: i64) -> Self

Limit the number of rows returned.

fn range(self, from: i64, to: i64) -> Self

Set the range of rows to return (offset..offset+limit).

fn single(self) -> Self

Expect exactly one row. Returns error if 0 or >1 rows.

fn maybe_single(self) -> Self

Expect zero or one row. Returns error if >1 rows.

fn count(self) -> Self

Request an exact row count.

fn count_option(self, option: CountOption) -> Self

Request a row count with a specific counting strategy.