sqlbuilder

package

Go to main page

Versions in this module

v0

v0.16.0

Apr 6, 2026

v0.15.0

Apr 4, 2026

v0.14.1

Apr 4, 2026

v0.14.0

Apr 3, 2026

v0.13.1

Apr 2, 2026

v0.13.0

Apr 1, 2026

v0.12.3

Mar 31, 2026

v0.12.2

Mar 31, 2026

v0.12.1

Mar 30, 2026

v0.12.0

Mar 30, 2026

v0.11.1

Mar 10, 2026

v0.11.0

Mar 6, 2026

v0.10.0

Mar 1, 2026

Changes in this version

+ type CaseBuilder struct

+ func Case(operand ...string) *CaseBuilder

+ func (cb *CaseBuilder) Else(result string) *CaseBuilder

+ func (cb *CaseBuilder) ElseExpr(result string, args ...any) *CaseBuilder

+ func (cb *CaseBuilder) End() Expr

+ func (cb *CaseBuilder) When(cond, result string) *CaseBuilder

+ func (cb *CaseBuilder) WhenExpr(condSQL string, condArgs []any, thenSQL string, thenArgs []any) *CaseBuilder

type DeleteBuilder

+ func (b *DeleteBuilder) ReturningExpr(exprs ...Expr) *DeleteBuilder

+ func (b *DeleteBuilder) WhereColumn(col1, op, col2 string) *DeleteBuilder

type Expr

+ func Cast(expr, typeName string) Expr

+ func CastExpr(expr Expr, typeName string) Expr

+ func Coalesce(exprs ...string) Expr

+ func CoalesceExpr(exprs ...Expr) Expr

+ func DenseRank() Expr

+ func Lag(col string) Expr

+ func Lead(col string) Expr

+ func Ntile(n int) Expr

+ func NullIf(expr1, expr2 string) Expr

+ func NullIfExpr(expr1, expr2 Expr) Expr

+ func Rank() Expr

+ func RowNumber() Expr

+ func (e Expr) Over(w *WindowBuilder) Expr

+ func (e Expr) OverRaw(clause string) Expr

type InsertBuilder

+ func (b *InsertBuilder) ReturningExpr(exprs ...Expr) *InsertBuilder

type SelectBuilder

+ func (s *SelectBuilder) DistinctOn(cols ...string) *SelectBuilder

+ func (s *SelectBuilder) FullJoinSubquery(sub *SelectBuilder, alias, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) GroupByExpr(expr Expr) *SelectBuilder

+ func (s *SelectBuilder) HavingBetween(col string, low, high any) *SelectBuilder

+ func (s *SelectBuilder) HavingIn(col string, vals ...any) *SelectBuilder

+ func (s *SelectBuilder) JoinSubquery(sub *SelectBuilder, alias, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) LeftJoinSubquery(sub *SelectBuilder, alias, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) RightJoinSubquery(sub *SelectBuilder, alias, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) WhereColumn(col1, op, col2 string) *SelectBuilder

type UpdateBuilder

+ func (b *UpdateBuilder) ReturningExpr(exprs ...Expr) *UpdateBuilder

+ func (b *UpdateBuilder) WhereColumn(col1, op, col2 string) *UpdateBuilder

+ type WindowBuilder struct

+ func Window() *WindowBuilder

+ func (w *WindowBuilder) Build() string

+ func (w *WindowBuilder) OrderBy(clauses ...string) *WindowBuilder

+ func (w *WindowBuilder) PartitionBy(cols ...string) *WindowBuilder

v0.9.0

Feb 27, 2026

v0.8.0

Feb 25, 2026

v0.7.0

Feb 25, 2026

Changes in this version

+ func Or(sql string, args ...any) condition

+ type DeleteBuilder struct

+ func Delete(table string) *DeleteBuilder

+ func DeleteWith(d Dialect, table string) *DeleteBuilder

+ func (b *DeleteBuilder) Build() (string, []any)

+ func (b *DeleteBuilder) Clone() *DeleteBuilder

+ func (b *DeleteBuilder) MustBuild() (string, []any)

+ func (b *DeleteBuilder) Query() Query

+ func (b *DeleteBuilder) Returning(cols ...string) *DeleteBuilder

+ func (b *DeleteBuilder) SetDialect(d Dialect) *DeleteBuilder

+ func (b *DeleteBuilder) String() string

+ func (b *DeleteBuilder) Using(tables ...string) *DeleteBuilder

+ func (b *DeleteBuilder) When(cond bool, fn func(*DeleteBuilder)) *DeleteBuilder

+ func (b *DeleteBuilder) Where(sql string, args ...any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereBetween(col string, low, high any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereEq(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereExists(sub *SelectBuilder) *DeleteBuilder

+ func (b *DeleteBuilder) WhereGt(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereGte(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereILike(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereIn(col string, vals ...any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereInSubquery(col string, sub *SelectBuilder) *DeleteBuilder

+ func (b *DeleteBuilder) WhereLike(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereLt(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereLte(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNeq(col string, val any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNotExists(sub *SelectBuilder) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNotIn(col string, vals ...any) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNotInSubquery(col string, sub *SelectBuilder) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNotNull(col string) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNull(col string) *DeleteBuilder

+ func (b *DeleteBuilder) WhereOr(conditions ...condition) *DeleteBuilder

+ func (b *DeleteBuilder) With(name string, q Query) *DeleteBuilder

+ func (b *DeleteBuilder) WithSelect(name string, sub *SelectBuilder) *DeleteBuilder

+ type Dialect int

+ const MySQL

+ const Postgres

+ const SQLite

+ type Expr struct

+ Args []any

+ SQL string

+ func Avg(col string) Expr

+ func Count(col string) Expr

+ func CountDistinct(col string) Expr

+ func Max(col string) Expr

+ func Min(col string) Expr

+ func Raw(sql string) Expr

+ func RawExpr(sql string, args ...any) Expr

+ func Sum(col string) Expr

+ func (e Expr) As(alias string) Expr

+ type InsertBuilder struct

+ func Insert(table string) *InsertBuilder

+ func InsertWith(d Dialect, table string) *InsertBuilder

+ func (b *InsertBuilder) BatchValues(rows [][]any) *InsertBuilder

+ func (b *InsertBuilder) Build() (string, []any)

+ func (b *InsertBuilder) Clone() *InsertBuilder

+ func (b *InsertBuilder) Columns(cols ...string) *InsertBuilder

+ func (b *InsertBuilder) FromSelect(sel *SelectBuilder) *InsertBuilder

+ func (b *InsertBuilder) MustBuild() (string, []any)

+ func (b *InsertBuilder) OnConflictDoNothing(target ...string) *InsertBuilder

+ func (b *InsertBuilder) OnConflictUpdate(target []string, updates map[string]any) *InsertBuilder

+ func (b *InsertBuilder) OnConflictUpdateExpr(target []string, updates map[string]Expr) *InsertBuilder

+ func (b *InsertBuilder) Query() Query

+ func (b *InsertBuilder) Returning(cols ...string) *InsertBuilder

+ func (b *InsertBuilder) SetDialect(d Dialect) *InsertBuilder

+ func (b *InsertBuilder) String() string

+ func (b *InsertBuilder) ValueMap(m map[string]any) *InsertBuilder

+ func (b *InsertBuilder) Values(vals ...any) *InsertBuilder

+ func (b *InsertBuilder) When(cond bool, fn func(*InsertBuilder)) *InsertBuilder

+ func (b *InsertBuilder) With(name string, q Query) *InsertBuilder

+ func (b *InsertBuilder) WithSelect(name string, sub *SelectBuilder) *InsertBuilder

+ type Query struct

+ Args []any

+ SQL string

+ type SelectBuilder struct

+ func ApplyFilters(sb *SelectBuilder, filters []request.Filter, allowedColumns map[string]string) *SelectBuilder

+ func ApplyPagination(sb *SelectBuilder, p request.Pagination) *SelectBuilder

+ func ApplySort(sb *SelectBuilder, sorts []request.SortField, allowedColumns map[string]string) *SelectBuilder

+ func Select(columns ...string) *SelectBuilder

+ func SelectExpr(exprs ...Expr) *SelectBuilder

+ func SelectWith(d Dialect, columns ...string) *SelectBuilder

+ func (s *SelectBuilder) ApplyFilters(filters []request.Filter, allowedColumns map[string]string) *SelectBuilder

+ func (s *SelectBuilder) ApplyPagination(p request.Pagination) *SelectBuilder

+ func (s *SelectBuilder) ApplySort(sorts []request.SortField, allowedColumns map[string]string) *SelectBuilder

+ func (s *SelectBuilder) Build() (string, []any)

+ func (s *SelectBuilder) Clone() *SelectBuilder

+ func (s *SelectBuilder) Column(col string) *SelectBuilder

+ func (s *SelectBuilder) ColumnExpr(expr Expr) *SelectBuilder

+ func (s *SelectBuilder) Columns(cols ...string) *SelectBuilder

+ func (s *SelectBuilder) CrossJoin(table string) *SelectBuilder

+ func (s *SelectBuilder) Distinct() *SelectBuilder

+ func (s *SelectBuilder) Except(other *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) ForShare() *SelectBuilder

+ func (s *SelectBuilder) ForUpdate() *SelectBuilder

+ func (s *SelectBuilder) From(table string) *SelectBuilder

+ func (s *SelectBuilder) FromAlias(table, alias string) *SelectBuilder

+ func (s *SelectBuilder) FromSubquery(sub *SelectBuilder, alias string) *SelectBuilder

+ func (s *SelectBuilder) FullJoin(table, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) GroupBy(cols ...string) *SelectBuilder

+ func (s *SelectBuilder) Having(sql string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) Intersect(other *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) Join(table, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) LeftJoin(table, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) Limit(n int) *SelectBuilder

+ func (s *SelectBuilder) MustBuild() (string, []any)

+ func (s *SelectBuilder) NoWait() *SelectBuilder

+ func (s *SelectBuilder) Offset(n int64) *SelectBuilder

+ func (s *SelectBuilder) OrderBy(clauses ...string) *SelectBuilder

+ func (s *SelectBuilder) OrderByAsc(cols ...string) *SelectBuilder

+ func (s *SelectBuilder) OrderByDesc(cols ...string) *SelectBuilder

+ func (s *SelectBuilder) OrderByExpr(expr Expr) *SelectBuilder

+ func (s *SelectBuilder) Query() Query

+ func (s *SelectBuilder) RightJoin(table, on string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) SetDialect(d Dialect) *SelectBuilder

+ func (s *SelectBuilder) SkipLocked() *SelectBuilder

+ func (s *SelectBuilder) String() string

+ func (s *SelectBuilder) Union(other *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) UnionAll(other *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) When(cond bool, fn func(*SelectBuilder)) *SelectBuilder

+ func (s *SelectBuilder) Where(sql string, args ...any) *SelectBuilder

+ func (s *SelectBuilder) WhereBetween(col string, low, high any) *SelectBuilder

+ func (s *SelectBuilder) WhereEq(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereExists(sub *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) WhereGt(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereGte(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereILike(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereIn(col string, vals ...any) *SelectBuilder

+ func (s *SelectBuilder) WhereInSubquery(col string, sub *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) WhereLike(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereLt(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereLte(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereNeq(col string, val any) *SelectBuilder

+ func (s *SelectBuilder) WhereNotExists(sub *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) WhereNotIn(col string, vals ...any) *SelectBuilder

+ func (s *SelectBuilder) WhereNotInSubquery(col string, sub *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) WhereNotNull(col string) *SelectBuilder

+ func (s *SelectBuilder) WhereNull(col string) *SelectBuilder

+ func (s *SelectBuilder) WhereOr(conditions ...condition) *SelectBuilder

+ func (s *SelectBuilder) With(name string, q Query) *SelectBuilder

+ func (s *SelectBuilder) WithRecursive(name string, q Query) *SelectBuilder

+ func (s *SelectBuilder) WithRecursiveSelect(name string, sub *SelectBuilder) *SelectBuilder

+ func (s *SelectBuilder) WithSelect(name string, sub *SelectBuilder) *SelectBuilder

+ type UpdateBuilder struct

+ func Update(table string) *UpdateBuilder

+ func UpdateWith(d Dialect, table string) *UpdateBuilder

+ func (b *UpdateBuilder) Build() (string, []any)

+ func (b *UpdateBuilder) Clone() *UpdateBuilder

+ func (b *UpdateBuilder) Decrement(col string, n any) *UpdateBuilder

+ func (b *UpdateBuilder) From(tables ...string) *UpdateBuilder

+ func (b *UpdateBuilder) Increment(col string, n any) *UpdateBuilder

+ func (b *UpdateBuilder) MustBuild() (string, []any)

+ func (b *UpdateBuilder) Query() Query

+ func (b *UpdateBuilder) Returning(cols ...string) *UpdateBuilder

+ func (b *UpdateBuilder) Set(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) SetDialect(d Dialect) *UpdateBuilder

+ func (b *UpdateBuilder) SetExpr(col string, expr Expr) *UpdateBuilder

+ func (b *UpdateBuilder) SetMap(m map[string]any) *UpdateBuilder

+ func (b *UpdateBuilder) String() string

+ func (b *UpdateBuilder) When(cond bool, fn func(*UpdateBuilder)) *UpdateBuilder

+ func (b *UpdateBuilder) Where(sql string, args ...any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereBetween(col string, low, high any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereEq(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereExists(sub *SelectBuilder) *UpdateBuilder

+ func (b *UpdateBuilder) WhereGt(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereGte(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereILike(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereIn(col string, vals ...any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereInSubquery(col string, sub *SelectBuilder) *UpdateBuilder

+ func (b *UpdateBuilder) WhereLike(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereLt(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereLte(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNeq(col string, val any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNotExists(sub *SelectBuilder) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNotIn(col string, vals ...any) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNotInSubquery(col string, sub *SelectBuilder) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNotNull(col string) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNull(col string) *UpdateBuilder

+ func (b *UpdateBuilder) WhereOr(conditions ...condition) *UpdateBuilder

+ func (b *UpdateBuilder) With(name string, q Query) *UpdateBuilder

+ func (b *UpdateBuilder) WithSelect(name string, sub *SelectBuilder) *UpdateBuilder

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL