um

func CrossJoin ¶

func CrossJoin(e any) dialect.JoinChain[*dialect.UpdateQuery]

func From ¶

func From(table any, joins ...dialect.JoinChain[*dialect.UpdateQuery]) dialect.FromChain[*dialect.UpdateQuery]

func FromFunction ¶

func FromFunction(funcs ...*dialect.Function) bob.Expression

FromFunction returns an expression for um.From when the source is one or more table functions (ROWS FROM when multiple).

func FullJoin ¶

func FullJoin(e any) dialect.JoinChain[*dialect.UpdateQuery]

func InnerJoin ¶

func InnerJoin(e any) dialect.JoinChain[*dialect.UpdateQuery]

func LeftJoin ¶

func LeftJoin(e any) dialect.JoinChain[*dialect.UpdateQuery]

func Only ¶

func Only() bob.Mod[*dialect.UpdateQuery]

func Recursive ¶

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

func Returning ¶

func Returning(clauses ...any) mods.Returning[*dialect.UpdateQuery]

func RightJoin ¶

func RightJoin(e any) dialect.JoinChain[*dialect.UpdateQuery]

func Set ¶

func Set(sets ...bob.Expression) bob.Mod[*dialect.UpdateQuery]

func SetCol ¶ added in v0.23.0

func SetCol(from string) mods.Set[*dialect.UpdateQuery]

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

func SetCols ¶ added in v0.44.0

func SetCols(columns ...string) clause.SetCols[*dialect.UpdateQuery]

SetCols creates a multi-column setter: (columns...) = ROW(...) | (values...) | (subquery)

func SetExpr ¶ added in v0.45.0

func SetExpr(col bob.Expression) mods.Set[*dialect.UpdateQuery]

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

func Table ¶

func Table(name any) bob.Mod[*dialect.UpdateQuery]

func TableAs ¶

func TableAs(name any, alias string) bob.Mod[*dialect.UpdateQuery]

func Where ¶

func Where(e bob.Expression) mods.Where[*dialect.UpdateQuery]

func WhereCurrentOf ¶ added in v0.44.0

func WhereCurrentOf(cursor string) mods.WhereCurrentOf[*dialect.UpdateQuery]

func With ¶

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

With starts a CTE. The name and column list are quoted as SQL identifiers.