sqlbuilder

package

Go to main page

Versions in this module

v0

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