Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

builder

package

Go to main page

Versions in this module

v1

v1.0.2

Feb 25, 2026

v1.0.1

Feb 24, 2026

v1.0.0

Feb 20, 2026

Changes in this version

+ func ColOf(model any, fieldPtr any) string

+ func MarshalClause(c Clause) string

+ func NormalizeClauseSQL(sql string, qualifiers ...ClauseQualifier) string

+ func StripStorageBucketFilter(sql string, bucketName string) string

+ func TableFromModel(model any) (schema, table string)

+ type Clause string

+ var False Clause = "FALSE"

+ var True Clause = "TRUE"

+ func And(cs ...Clause) Clause

+ func ArrayContainedBy(col string, arr Exp) Clause

+ func ArrayContains(col string, arr Exp) Clause

+ func ArrayOverlaps(col string, arr Exp) Clause

+ func Between(col string, low, high Exp) Clause

+ func ContainsText(col, needle string) Clause

+ func EndsWith(col, suffix string) Clause

+ func Eq(col string, rhs Exp) Clause

+ func EqAll(col string, arr Exp) Clause

+ func EqAny(col string, arr Exp) Clause

+ func EqS(col, s string) Clause

+ func EqString(col, s string) Clause

+ func Exists(rawSelectSQL string) Clause

+ func ExistsFrom(table string, joinCond Clause, extra ...Clause) Clause

+ func Ge(col string, rhs Exp) Clause

+ func Gt(col string, rhs Exp) Clause

+ func ILike(col, pattern string) Clause

+ func IRegex(col, re string) Clause

+ func If(cond bool, c Clause) Clause

+ func IfString(notEmpty string, f func(string) Clause) Clause

+ func In(col string, items ...Exp) Clause

+ func InOrg(col string) Clause

+ func InS(col string, values ...string) Clause

+ func InStrings(col string, values ...string) Clause

+ func IsDistinctFrom(col string, rhs Exp) Clause

+ func IsFalse(col string) Clause

+ func IsNotDistinctFrom(col string, rhs Exp) Clause

+ func IsNull(col string) Clause

+ func IsTrue(col string) Clause

+ func JSONContains(col string, json Exp) Clause

+ func JSONHasAllKeys(col string, keys ...string) Clause

+ func JSONHasAnyKeys(col string, keys ...string) Clause

+ func JSONHasKey(col, key string) Clause

+ func Le(col string, rhs Exp) Clause

+ func Like(col, pattern string) Clause

+ func Lt(col string, rhs Exp) Clause

+ func Ne(col string, rhs Exp) Clause

+ func Not(c Clause) Clause

+ func NotBetween(col string, low, high Exp) Clause

+ func NotExists(rawSelectSQL string) Clause

+ func NotILike(col, pattern string) Clause

+ func NotIn(col string, items ...Exp) Clause

+ func NotLike(col, pattern string) Clause

+ func NotNull(col string) Clause

+ func Or(cs ...Clause) Clause

+ func OwnerIsAuth(col string) Clause

+ func RangeContainedBy(col string, rhs Exp) Clause

+ func RangeContains(col string, rhs Exp) Clause

+ func RangeOverlaps(col string, rhs Exp) Clause

+ func Regex(col, re string) Clause

+ func RoleIs(role string) Clause

+ func RolesAny(roles ...string) Clause

+ func Search(col, q, config string) Clause

+ func StartsWith(col, prefix string) Clause

+ func StorageBucketClause(bucketName string) Clause

+ func StorageCheckClause(bucketName string, clause Clause) Clause

+ func StorageUsingClause(bucketName string, clause Clause) Clause

+ func TenantMatch(col string, settingKey, cast string) Clause

+ func TsMatches(vector Exp, query Exp) Clause

+ func UnmarshalClause(sql string, qualifiers ...ClauseQualifier) (Clause, string, bool)

+ func (c Clause) IsEmpty() bool

+ func (c Clause) Paren() Clause

+ func (c Clause) String() string

+ type ClauseQualifier struct

+ Schema string

+ Table string

+ type Exp string

+ func Array(items ...Exp) Exp

+ func ArrayStrings(values ...string) Exp

+ func AuthUID() Exp

+ func Bool(b bool) Exp

+ func Cast(rhs Exp, typ string) Exp

+ func Claim(key string) Exp

+ func Coalesce(args ...Exp) Exp

+ func CurrentSetting(key string) Exp

+ func CurrentSettingAs(key, typ string) Exp

+ func CurrentSettingCast(key, cast string) Exp

+ func CurrentUser() Exp

+ func Date(s string) Exp

+ func F64(f float64) Exp

+ func Float64(f float64) Exp

+ func Func(name string, args ...Exp) Exp

+ func I64(n int64) Exp

+ func Ident(name string) Exp

+ func Int64(n int64) Exp

+ func Interval(s string) Exp

+ func JSONB(s string) Exp

+ func JSONGet(col, key string) Exp

+ func JSONGetText(col, key string) Exp

+ func JSONPath(col string, path ...string) Exp

+ func JSONPathText(col string, path ...string) Exp

+ func Now() Exp

+ func NullIf(a, b Exp) Exp

+ func Raw(s string) Exp

+ func S(s string) Exp

+ func SessionUser() Exp

+ func String(s string) Exp

+ func Timestamp(s string) Exp

+ func Timestamptz(s string) Exp

+ func TsVector(doc Exp, config ...string) Exp

+ func UUID(s string) Exp

+ func UUIDLit(s string) Exp

+ func Val(s string) Exp

+ func WebSearchQuery(q string, config ...string) Exp

+ func (e Exp) String() string

v1.0.0-beta.75

Jan 30, 2026

v1.0.0-beta.74

Jan 30, 2026

v1.0.0-beta.73

Jan 30, 2026

v1.0.0-beta.72

Jan 29, 2026

v1.0.0-beta.71

Jan 26, 2026

v1.0.0-beta.70

Jan 25, 2026

v1.0.0-beta.69

Jan 13, 2026

v1.0.0-beta.68

Jan 13, 2026

v1.0.0-beta.67

Dec 7, 2025

v1.0.0-beta.66

Nov 25, 2025

v1.0.0-beta.65

Nov 25, 2025

v1.0.0-beta.64

Nov 24, 2025

v1.0.0-beta.63

Nov 14, 2025

v1.0.0-beta.62

Oct 20, 2025