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

sql_select

package

Go to main page

Versions in this module

v4

v4.2.2

Jun 5, 2026

v4.2.1

Jun 5, 2026

v4.2.0

May 29, 2026

v4.1.6

May 6, 2026

v4.1.5

May 4, 2026

v4.1.4

Apr 9, 2026

v4.1.3

Apr 2, 2026

v4.1.2

Dec 30, 2025

v4.1.1

Dec 11, 2025

Changes in this version

type ISelect

+ AddLimit func(limit ...SQLObject) ISelect

+ type LimitBy struct

+ func NewLimitBy(limit SQLObject, exprs ...SQLObject) *LimitBy

+ func (l *LimitBy) GetExprs() []SQLObject

+ func (l *LimitBy) GetLimit() SQLObject

+ func (l *LimitBy) String(ctx *Ctx, options ...int) (string, error)

type Select

+ func (s *Select) AddLimit(limit ...SQLObject) ISelect

v4.1.0

Nov 10, 2025

v4.0.23

Oct 28, 2025

v4.0.22

Oct 20, 2025

Changes in this version

+ const ORDER_BY_DIRECTION_ASC

+ const ORDER_BY_DIRECTION_DESC

+ const STRING_OPT_INLINE_WITH

+ const STRING_OPT_SKIP_WITH

+ const WITH_REF_NO_ALIAS

+ type Aliased interface

+ GetAlias func() string

+ GetExpr func() SQLObject

+ String func(ctx *Ctx, options ...int) (string, error)

+ type BoolVal struct

+ func (b *BoolVal) String(ctx *Ctx, options ...int) (string, error)

+ type CNot struct

+ func (n *CNot) GetEntity() []SQLObject

+ func (n *CNot) GetFunction() string

+ func (n *CNot) String(ctx *Ctx, options ...int) (string, error)

+ type CNotNull struct

+ func (c *CNotNull) GetEntity() []SQLObject

+ func (c *CNotNull) GetFunction() string

+ func (c *CNotNull) String(ctx *Ctx, options ...int) (string, error)

+ type Col struct

+ func (c *Col) GetAlias() string

+ func (c *Col) GetExpr() SQLObject

+ func (c *Col) String(ctx *Ctx, options ...int) (string, error)

+ type Ctx struct

+ Params map[string]SQLObject

+ Result map[string]SQLObject

+ func DefaultCtx() *Ctx

+ func (c *Ctx) Id() int

+ type CtxParam struct

+ func NewCtxParam(name string, def *string) *CtxParam

+ func NewCtxParamOrDef(name string, def string) *CtxParam

+ func (c *CtxParam) String(ctx *Ctx, options ...int) (string, error)

+ type CustomCol struct

+ func (c *CustomCol) String(ctx *Ctx, options ...int) (string, error)

+ type FloatVal struct

+ func (f *FloatVal) String(ctx *Ctx, options ...int) (string, error)

+ type ISelect interface

+ AddJoin func(joins ...*Join) ISelect

+ AddWindows func(windows ...*WindowFunction) ISelect

+ AddWith func(withs ...*With) ISelect

+ AndHaving func(clauses ...SQLCondition) ISelect

+ AndPreWhere func(clauses ...SQLCondition) ISelect

+ AndWhere func(clauses ...SQLCondition) ISelect

+ Distinct func(distinct bool) ISelect

+ DropWith func(alias ...string) ISelect

+ From func(table SQLObject) ISelect

+ GetDistinct func() bool

+ GetFrom func() SQLObject

+ GetGroupBy func() []SQLObject

+ GetHaving func() SQLCondition

+ GetJoin func() []*Join

+ GetLimit func() SQLObject

+ GetOffset func() SQLObject

+ GetOrderBy func() []SQLObject

+ GetPreWhere func() SQLCondition

+ GetSelect func() []SQLObject

+ GetSettings func(table SQLObject) map[string]string

+ GetWhere func() SQLCondition

+ GetWindows func() []*WindowFunction

+ GetWith func() []*With

+ GroupBy func(fields ...SQLObject) ISelect

+ Join func(joins ...*Join) ISelect

+ Limit func(limit SQLObject) ISelect

+ Offset func(offset SQLObject) ISelect

+ OrHaving func(clauses ...SQLCondition) ISelect

+ OrPreWhere func(clauses ...SQLCondition) ISelect

+ OrWhere func(clauses ...SQLCondition) ISelect

+ OrderBy func(fields ...SQLObject) ISelect

+ Select func(cols ...SQLObject) ISelect

+ SetHaving func(having SQLCondition) ISelect

+ SetSetting func(name string, value string) ISelect

+ SetWindows func(windows ...*WindowFunction) ISelect

+ String func(ctx *Ctx, options ...int) (string, error)

+ With func(withs ...*With) ISelect

+ func NewSelect() ISelect

+ type In struct

+ func NewIn(left SQLObject, right ...SQLObject) *In

+ func (in *In) GetEntity() []SQLObject

+ func (in *In) GetFunction() string

+ func (in *In) String(ctx *Ctx, options ...int) (string, error)

+ type IntVal struct

+ func NewIntVal(val int64) *IntVal

+ func (i *IntVal) String(ctx *Ctx, options ...int) (string, error)

+ type Join struct

+ func NewJoin(tp string, table SQLObject, on SQLCondition) *Join

+ func (l *Join) GetOn() SQLCondition

+ func (l *Join) GetTable() SQLObject

+ func (l *Join) String(ctx *Ctx, options ...int) (string, error)

+ type LogicalOp struct

+ func And(clauses ...SQLCondition) *LogicalOp

+ func BinaryLogicalOp(fn string, left SQLObject, right SQLObject) *LogicalOp

+ func Eq(left SQLObject, right SQLObject) *LogicalOp

+ func Ge(left SQLObject, right SQLObject) *LogicalOp

+ func Gt(left SQLObject, right SQLObject) *LogicalOp

+ func Le(left SQLObject, right SQLObject) *LogicalOp

+ func Lt(left SQLObject, right SQLObject) *LogicalOp

+ func Neq(left SQLObject, right SQLObject) *LogicalOp

+ func NewGenericLogicalOp(fn string, clauses ...SQLCondition) *LogicalOp

+ func Or(clauses ...SQLCondition) *LogicalOp

+ func (op *LogicalOp) AppendEntity(clauses ...SQLCondition)

+ func (op *LogicalOp) GetEntity() []SQLObject

+ func (op *LogicalOp) GetFunction() string

+ func (op *LogicalOp) String(ctx *Ctx, options ...int) (string, error)

+ type OrderBy struct

+ func NewOrderBy(col SQLObject, direction int) *OrderBy

+ func (o *OrderBy) String(ctx *Ctx, options ...int) (string, error)

+ func (o *OrderBy) WithFill(from int64, to int64, step int64) *OrderBy

+ type RawObject struct

+ func FmtRawObject(tmpl string, arg ...interface{}) *RawObject

+ func NewRawObject(val string) *RawObject

+ func (r *RawObject) String(ctx *Ctx, options ...int) (string, error)

+ type SQLCondition interface

+ GetEntity func() []SQLObject

+ GetFunction func() string

+ String func(ctx *Ctx, options ...int) (string, error)

+ func Not(expr SQLObject) SQLCondition

+ func NotNull(obj SQLObject) SQLCondition

+ type SQLObject interface

+ String func(ctx *Ctx, options ...int) (string, error)

+ func NewBoolVal(b bool) SQLObject

+ func NewCol(expr SQLObject, alias string) SQLObject

+ func NewCustomCol(fn func(ctx *Ctx, options ...int) (string, error)) SQLObject

+ func NewFloatVal(f float64) SQLObject

+ func NewSimpleCol(name string, alias string) SQLObject

+ func NewStringVal(s string) SQLObject

+ type Select struct

+ func (s *Select) AddJoin(joins ...*Join) ISelect

+ func (s *Select) AddWindows(windows ...*WindowFunction) ISelect

+ func (s *Select) AddWith(withs ...*With) ISelect

+ func (s *Select) AndHaving(clauses ...SQLCondition) ISelect

+ func (s *Select) AndPreWhere(clauses ...SQLCondition) ISelect

+ func (s *Select) AndWhere(clauses ...SQLCondition) ISelect

+ func (s *Select) Distinct(distinct bool) ISelect

+ func (s *Select) DropWith(alias ...string) ISelect

+ func (s *Select) From(table SQLObject) ISelect

+ func (s *Select) GetDistinct() bool

+ func (s *Select) GetFrom() SQLObject

+ func (s *Select) GetGroupBy() []SQLObject

+ func (s *Select) GetHaving() SQLCondition

+ func (s *Select) GetJoin() []*Join

+ func (s *Select) GetLimit() SQLObject

+ func (s *Select) GetOffset() SQLObject

+ func (s *Select) GetOrderBy() []SQLObject

+ func (s *Select) GetPreWhere() SQLCondition

+ func (s *Select) GetSelect() []SQLObject

+ func (s *Select) GetSettings(table SQLObject) map[string]string

+ func (s *Select) GetWhere() SQLCondition

+ func (s *Select) GetWindows() []*WindowFunction

+ func (s *Select) GetWith() []*With

+ func (s *Select) GroupBy(fields ...SQLObject) ISelect

+ func (s *Select) Join(joins ...*Join) ISelect

+ func (s *Select) Limit(limit SQLObject) ISelect

+ func (s *Select) Offset(offset SQLObject) ISelect

+ func (s *Select) OrHaving(clauses ...SQLCondition) ISelect

+ func (s *Select) OrPreWhere(clauses ...SQLCondition) ISelect

+ func (s *Select) OrWhere(clauses ...SQLCondition) ISelect

+ func (s *Select) OrderBy(fields ...SQLObject) ISelect

+ func (s *Select) Select(cols ...SQLObject) ISelect

+ func (s *Select) SetHaving(having SQLCondition) ISelect

+ func (s *Select) SetSetting(name string, value string) ISelect

+ func (s *Select) SetWindows(windows ...*WindowFunction) ISelect

+ func (s *Select) String(ctx *Ctx, options ...int) (string, error)

+ func (s *Select) With(withs ...*With) ISelect

+ type StringVal struct

+ func (s *StringVal) String(ctx *Ctx, options ...int) (string, error)

+ type WindowFunction struct

+ Alias string

+ End WindowPoint

+ OrderBy []SQLObject

+ PartitionBy []SQLObject

+ Rows bool

+ Start WindowPoint

+ func (w *WindowFunction) String(ctx *Ctx, options ...int) (string, error)

+ type WindowFunctionRef struct

+ Fn *WindowFunction

+ func (w *WindowFunctionRef) String(ctx *Ctx, options ...int) (string, error)

+ type WindowPoint struct

+ IsFollowing bool

+ Offset int32

+ Unbounded bool

+ func (w *WindowPoint) String(ctx *Ctx, options ...int) (string, error)

+ type With struct

+ func NewWith(query ISelect, alias string) *With

+ func (w *With) GetAlias() string

+ func (w *With) GetQuery() ISelect

+ func (w *With) String(ctx *Ctx, options ...int) (string, error)

+ type WithRef struct

+ func NewWithRef(ref *With) *WithRef

+ func (w *WithRef) String(ctx *Ctx, options ...int) (string, error)