Versions in this module Expand all Collapse all v0 v0.42.5 Jan 27, 2026 v0.42.4 Jan 27, 2026 Changes in this version + const CrossJoin + const Except + const FullJoin + const InnerJoin + const Intersect + const LeftJoin + const LockStrengthKeyShare + const LockStrengthNoKeyUpdate + const LockStrengthShare + const LockStrengthUpdate + const LockWaitNoWait + const LockWaitSkipLocked + const RightJoin + const SearchBreadth + const SearchDepth + const StraightJoin + const Union + var ErrEmptySetExpression = errors.New("SET clause must have at least one assignment expression") + var ErrNoCombinationStrategy = errors.New("combination strategy must be set") + var ErrNoLockStrength = errors.New("no lock strength specified") + type CTE struct + Columns []string + Cycle CTECycle + Materialized *bool + Name string + Query bob.Query + Search CTESearch + func (c CTE) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type CTECycle struct + Columns []string + DefaultVal any + Set string + SetVal any + Using string + func (c CTECycle) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type CTESearch struct + Columns []string + Order string + Set string + func (c CTESearch) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Combine struct + All bool + Query bob.Query + Strategy string + func (s *Combine) SetCombine(c Combine) + func (s Combine) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Combines struct + Queries []Combine + func (c *Combines) AppendCombine(combine Combine) + type Conflict struct + Expression bob.Expression + func (c *Conflict) SetConflict(conflict bob.Expression) + type ConflictClause struct + Do string + Target ConflictTarget + func (c ConflictClause) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type ConflictTarget struct + Columns []any + Constraint string + Where []any + func (c ConflictTarget) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Fetch struct + Count any + WithTies bool + func (f *Fetch) SetFetch(fetch Fetch) + func (f Fetch) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Frame struct + Defined bool + End any + Exclusion string + Mode string + Start any + func (f *Frame) SetEnd(end any) + func (f *Frame) SetExclusion(excl string) + func (f *Frame) SetMode(mode string) + func (f *Frame) SetStart(start any) + func (f Frame) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type GroupBy struct + Distinct bool + Groups []any + With string + func (g *GroupBy) AppendGroup(e any) + func (g *GroupBy) SetGroupByDistinct(distinct bool) + func (g *GroupBy) SetGroupWith(with string) + func (g *GroupBy) SetGroups(groups ...any) + func (g GroupBy) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type GroupingSet struct + Groups []bob.Expression + Type string + func (g GroupingSet) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Having struct + Conditions []any + func (h *Having) AppendHaving(e ...any) + func (h Having) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type IndexHint struct + For string + Indexes []string + Type string + func (f IndexHint) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Join struct + Natural bool + On []bob.Expression + To TableRef + Type string + Using []string + func (j Join) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Limit struct + Count any + func (l *Limit) SetLimit(limit any) + func (l Limit) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Lock struct + Strength string + Tables []string + Wait string + func (f Lock) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Locks struct + Locks []bob.Expression + func (f *Locks) AppendLock(lock bob.Expression) + type NamedWindow struct + Definition Window + Name string + func (n NamedWindow) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Offset struct + Count any + func (o *Offset) SetOffset(offset any) + func (o Offset) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type OrderBy struct + Expressions []bob.Expression + func (o *OrderBy) AppendOrder(order bob.Expression) + func (o *OrderBy) ClearOrderBy() + func (o OrderBy) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type OrderDef struct + Collation string + Direction string + Expression any + Nulls string + func (o OrderDef) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Returning struct + Expressions []any + func (r *Returning) AppendReturning(columns ...any) + func (r *Returning) HasReturning() bool + func (r Returning) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type SelectList struct + Columns []any + PreloadColumns []any + func (s *SelectList) AppendPreloadSelect(columns ...any) + func (s *SelectList) AppendSelect(columns ...any) + func (s *SelectList) CountSelectCols() int + func (s *SelectList) SetPreloadSelect(columns ...any) + func (s *SelectList) SetSelect(columns ...any) + func (s SelectList) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Set struct + Set []any + func (s *Set) AppendSet(exprs ...any) + func (s Set) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type TableRef struct + Alias string + Columns []string + Expression any + IndexHints []IndexHint + IndexedBy *string + Joins []Join + Lateral bool + Only bool + Partitions []string + WithOrdinality bool + func (f *TableRef) AppendIndexHint(i IndexHint) + func (f *TableRef) AppendJoin(j Join) + func (f *TableRef) AppendPartition(partitions ...string) + func (f *TableRef) SetIndexedBy(i *string) + func (f *TableRef) SetLateral(lateral bool) + func (f *TableRef) SetOnly(only bool) + func (f *TableRef) SetTable(table any) + func (f *TableRef) SetTableAlias(alias string, columns ...string) + func (f *TableRef) SetWithOrdinality(to bool) + func (f TableRef) As(alias string, columns ...string) TableRef + func (f TableRef) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Value []bob.Expression + func (v Value) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Values struct + Query bob.Query + Vals []Value + func (v *Values) AppendValues(vals ...bob.Expression) + func (v Values) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Where struct + Conditions []any + func (wh *Where) AppendWhere(e ...any) + func (wh Where) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Window struct + BasedOn string + func (wi *Window) AddPartitionBy(condition ...any) + func (wi *Window) SetBasedOn(from string) + func (wi Window) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type Windows struct + Windows []bob.Expression + func (wi *Windows) AppendWindow(w bob.Expression) + func (wi Windows) WriteSQL(ctx context.Context, w io.StringWriter, d bob.Dialect, start int) ([]any, error) + type With struct + CTEs []bob.Expression + Recursive bool + func (w *With) AppendCTE(cte bob.Expression) + func (w *With) SetRecursive(r bool) + func (w With) WriteSQL(ctx context.Context, wr io.StringWriter, d bob.Dialect, start int) ([]any, error)
Go to main page