im

func Excluded ¶ added in v0.44.0

func Excluded(column string) dialect.Expression

Excluded references a column from the EXCLUDED pseudo-table in ON CONFLICT DO UPDATE.

func Into ¶

func Into(name any, columns ...string) bob.Mod[*dialect.InsertQuery]

func IntoAs ¶

func IntoAs(name any, alias string, columns ...string) bob.Mod[*dialect.InsertQuery]

func OnConflict ¶

func OnConflict(columns ...any) mods.Conflict[*dialect.InsertQuery]

func OrAbort ¶

func OrAbort() bob.Mod[*dialect.InsertQuery]

func OrFail ¶

func OrFail() bob.Mod[*dialect.InsertQuery]

func OrIgnore ¶

func OrIgnore() bob.Mod[*dialect.InsertQuery]

func OrReplace ¶

func OrReplace() bob.Mod[*dialect.InsertQuery]

func OrRollback ¶

func OrRollback() bob.Mod[*dialect.InsertQuery]

func Query ¶

func Query(q bob.Query) bob.Mod[*dialect.InsertQuery]

Insert from a query

func Recursive ¶

func Recursive(r bool) bob.Mod[*dialect.InsertQuery]

func Returning ¶

func Returning(clauses ...any) bob.Mod[*dialect.InsertQuery]

func Rows ¶

func Rows(rows ...[]bob.Expression) bob.Mod[*dialect.InsertQuery]

func Set ¶ added in v0.23.0

func Set(sets ...bob.Expression) bob.Mod[*clause.ConflictClause]

func SetCol ¶ added in v0.23.0

func SetCol(from string) mods.Set[*clause.ConflictClause]

SetCol sets one column in ON CONFLICT DO UPDATE SET. The column name is quoted automatically. For qualified names or other expressions on the LHS, use SetExpr.

func SetExcluded ¶ added in v0.23.0

func SetExcluded(cols ...string) bob.Mod[*clause.ConflictClause]

func SetExpr ¶ added in v0.45.0

func SetExpr(col bob.Expression) mods.Set[*clause.ConflictClause]

SetExpr is like SetCol but the column LHS is any expression (e.g. sqlite.Quote("t", "col")).

func Values ¶

func Values(clauses ...bob.Expression) bob.Mod[*dialect.InsertQuery]

func Where ¶ added in v0.23.0

func Where(e bob.Expression) bob.Mod[*clause.ConflictClause]

func With ¶

func With(name string, columns ...string) dialect.CTEChain[*dialect.InsertQuery]