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
- API
  
  Reference documentation for the pkg.go.dev API
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

quarry

package module

Go to main page

Versions in this module

v1

v1.2.0

May 20, 2026

v1.1.0

May 7, 2026

Changes in this version

+ var ErrInvalidBuilderState = errors.New("invalid builder state")

+ var ErrInvalidIdentifier = errors.New("invalid identifier")

+ var ErrPlaceholderMismatch = errors.New("placeholder mismatch")

+ var ErrUnsupportedFeature = errors.New("unsupported dialect feature")

+ type Column struct

+ func C(name string) Column

+ func Col(name string) Column

+ func (c Column) Any(values any) Predicate

+ func (c Column) As(alias string) Column

+ func (c Column) Between(low any, high any) Predicate

+ func (c Column) Eq(val any) Predicate

+ func (c Column) Gt(val any) Predicate

+ func (c Column) Gte(val any) Predicate

+ func (c Column) ILike(val any) Predicate

+ func (c Column) In(values ...any) Predicate

+ func (c Column) IsNotNull() Predicate

+ func (c Column) IsNull() Predicate

+ func (c Column) Like(val any) Predicate

+ func (c Column) Lt(val any) Predicate

+ func (c Column) Lte(val any) Predicate

+ func (c Column) Neq(val any) Predicate

+ func (c Column) NotIn(values ...any) Predicate

+ type DeleteBuilder struct

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

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

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

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

+ func (b *DeleteBuilder) Where(preds ...Predicate) *DeleteBuilder

+ func (b *DeleteBuilder) WhereIf(cond bool, pred Predicate) *DeleteBuilder

+ type Dialect string

+ const MySQL

+ const Postgres

+ const SQLite

+ func (d Dialect) Name() string

+ func (d Dialect) Placeholder(n int) string

+ func (d Dialect) QuoteIdent(ident string) (string, error)

+ func (d Dialect) Supports(feature Feature) bool

+ type Expr interface

+ type Feature string

+ const FeatureAny

+ const FeatureILike

+ const FeatureReturning

+ type Filters []Predicate

+ type InsertBuilder struct

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

+ func (b *InsertBuilder) Prefix(sql string, args ...any) *InsertBuilder

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

+ func (b *InsertBuilder) Rows(rows ...[]any) *InsertBuilder

+ func (b *InsertBuilder) SetMap(values map[string]any) *InsertBuilder

+ func (b *InsertBuilder) Suffix(sql string, args ...any) *InsertBuilder

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

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

+ type Predicate interface

+ func And(preds ...Predicate) Predicate

+ func Any(col any, values any) Predicate

+ func Between(col any, low any, high any) Predicate

+ func Eq(col string, val any) Predicate

+ func Exists(query Query) Predicate

+ func Gt(col string, val any) Predicate

+ func Gte(col string, val any) Predicate

+ func ILike(col string, val any) Predicate

+ func In(col any, values ...any) Predicate

+ func IsNotNull(col string) Predicate

+ func IsNull(col string) Predicate

+ func Like(col string, val any) Predicate

+ func Lt(col string, val any) Predicate

+ func Lte(col string, val any) Predicate

+ func Neq(col string, val any) Predicate

+ func Not(pred Predicate) Predicate

+ func NotExists(query Query) Predicate

+ func NotIn(col any, values ...any) Predicate

+ func OptionalEq(col any, val any) Predicate

+ func OptionalGt(col any, val any) Predicate

+ func OptionalGte(col any, val any) Predicate

+ func OptionalILike(col any, val any) Predicate

+ func OptionalIn(col any, values ...any) Predicate

+ func OptionalLike(col any, val any) Predicate

+ func OptionalLt(col any, val any) Predicate

+ func OptionalLte(col any, val any) Predicate

+ func OptionalNeq(col any, val any) Predicate

+ func Or(preds ...Predicate) Predicate

+ func Raw(sql string, args ...any) Predicate

+ func TupleIn(columns []any, tuples [][]any) Predicate

+ type Quarry struct

+ func New(d Dialect) *Quarry

+ func (q *Quarry) DeleteFrom(table any) *DeleteBuilder

+ func (q *Quarry) Dialect() Dialect

+ func (q *Quarry) InsertInto(table any) *InsertBuilder

+ func (q *Quarry) Select(cols ...any) *SelectBuilder

+ func (q *Quarry) Update(table any) *UpdateBuilder

+ type Query = SQLer

+ type SQLer interface

+ ToSQL func() (string, []any, error)

+ type SelectBuilder struct

+ func (b *SelectBuilder) CrossJoin(expr any) *SelectBuilder

+ func (b *SelectBuilder) Distinct() *SelectBuilder

+ func (b *SelectBuilder) From(table any) *SelectBuilder

+ func (b *SelectBuilder) FullJoin(expr any) *SelectBuilder

+ func (b *SelectBuilder) GroupBy(parts ...any) *SelectBuilder

+ func (b *SelectBuilder) Having(preds ...Predicate) *SelectBuilder

+ func (b *SelectBuilder) Join(expr any) *SelectBuilder

+ func (b *SelectBuilder) LeftJoin(expr any) *SelectBuilder

+ func (b *SelectBuilder) Limit(n uint64) *SelectBuilder

+ func (b *SelectBuilder) LimitDefault(n, fallback int) *SelectBuilder

+ func (b *SelectBuilder) Offset(n uint64) *SelectBuilder

+ func (b *SelectBuilder) OffsetDefault(n, fallback int) *SelectBuilder

+ func (b *SelectBuilder) OrderBy(parts ...any) *SelectBuilder

+ func (b *SelectBuilder) OrderBySafe(input string, allowed SortMap) *SelectBuilder

+ func (b *SelectBuilder) OrderBySafeDefault(input string, allowed SortMap, fallback string) *SelectBuilder

+ func (b *SelectBuilder) Page(page, perPage int) *SelectBuilder

+ func (b *SelectBuilder) Prefix(sql string, args ...any) *SelectBuilder

+ func (b *SelectBuilder) RightJoin(expr any) *SelectBuilder

+ func (b *SelectBuilder) Suffix(sql string, args ...any) *SelectBuilder

+ func (b *SelectBuilder) ToSQL() (string, []any, error)

+ func (b *SelectBuilder) Where(preds ...Predicate) *SelectBuilder

+ func (b *SelectBuilder) WhereIf(cond bool, pred Predicate) *SelectBuilder

+ type SortMap map[string]string

+ type Table struct

+ func T(name string) Table

+ func TableName(name string) Table

+ func (t Table) As(alias string) Table

+ func (t Table) C(name string) Column

+ func (t Table) Col(name string) Column

+ type UpdateBuilder struct

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

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

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

+ func (b *UpdateBuilder) SetIf(cond bool, col any, val any) *UpdateBuilder

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

+ func (b *UpdateBuilder) SetOptional(col any, val any) *UpdateBuilder

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

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

+ func (b *UpdateBuilder) Where(preds ...Predicate) *UpdateBuilder

+ func (b *UpdateBuilder) WhereIf(cond bool, pred Predicate) *UpdateBuilder

v1.0.0

May 6, 2026