Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  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

squirrel

package module

Go to main page

Versions in this module

v1

v1.8.0

May 18, 2023

Changes in this version

+ type CTE struct

+ Alias string

+ ColumnList []string

+ Expression Sqlizer

+ Recursive bool

+ func (c CTE) ToSql() (string, []interface{}, error)

type SelectBuilder

+ func (b SelectBuilder) With(alias string, expr Sqlizer) SelectBuilder

+ func (b SelectBuilder) WithCTE(cte Sqlizer) SelectBuilder

+ func (b SelectBuilder) WithRecursive(alias string, expr Sqlizer) SelectBuilder

v1.7.0

Mar 14, 2022

v1.6.0

Mar 7, 2022

Changes in this version

+ var AtP = atpFormat

+ var Colon = colonFormat

+ var Dollar = dollarFormat

+ var NoContextSupport = errors.New("DB does not support Context")

+ var Question = questionFormat

+ var RunnerNotQueryRunner = fmt.Errorf("cannot QueryRow; Runner is not a QueryRower")

+ var RunnerNotSet = fmt.Errorf("cannot run; no Runner set (RunWith)")

+ var StatementBuilder = StatementBuilderType(builder.EmptyBuilder).PlaceholderFormat(Question)

+ func Alias(expr Sqlizer, alias string) aliasExpr

+ func ConcatExpr(parts ...interface{}) concatExpr

+ func DebugSqlizer(s Sqlizer) string

+ func ExecContextWith(ctx context.Context, db ExecerContext, s Sqlizer) (res pgconn.CommandTag, err error)

+ func ExecWith(db Execer, s Sqlizer) (commandTag pgconn.CommandTag, err error)

+ func Placeholders(count int) string

+ func QueryContextWith(ctx context.Context, db QueryerContext, s Sqlizer) (rows pgx.Rows, err error)

+ func QueryRowContextWith(ctx context.Context, db QueryRowerContext, s Sqlizer) pgx.Row

+ func QueryRowWith(db QueryRower, s Sqlizer) pgx.Row

+ func QueryWith(db Queryer, s Sqlizer) (rows pgx.Rows, err error)

+ type And conj

+ func (a And) ToSql() (string, []interface{}, error)

+ type BaseRunner interface

+ type CaseBuilder builder.Builder

+ func Case(what ...interface{}) CaseBuilder

+ func (b CaseBuilder) Else(expr interface{}) CaseBuilder

+ func (b CaseBuilder) MustSql() (string, []interface{})

+ func (b CaseBuilder) ToSql() (string, []interface{}, error)

+ func (b CaseBuilder) When(when interface{}, then interface{}) CaseBuilder

+ type DeleteBuilder builder.Builder

+ func Delete(from string) DeleteBuilder

+ func (b DeleteBuilder) Exec() (pgconn.CommandTag, error)

+ func (b DeleteBuilder) ExecContext(ctx context.Context) (pgconn.CommandTag, error)

+ func (b DeleteBuilder) From(from string) DeleteBuilder

+ func (b DeleteBuilder) Limit(limit uint64) DeleteBuilder

+ func (b DeleteBuilder) MustSql() (string, []interface{})

+ func (b DeleteBuilder) Offset(offset uint64) DeleteBuilder

+ func (b DeleteBuilder) OrderBy(orderBys ...string) DeleteBuilder

+ func (b DeleteBuilder) PlaceholderFormat(f PlaceholderFormat) DeleteBuilder

+ func (b DeleteBuilder) Prefix(sql string, args ...interface{}) DeleteBuilder

+ func (b DeleteBuilder) PrefixExpr(expr Sqlizer) DeleteBuilder

+ func (b DeleteBuilder) Query() (pgx.Rows, error)

+ func (b DeleteBuilder) QueryContext(ctx context.Context) (pgx.Rows, error)

+ func (b DeleteBuilder) QueryRowContext(ctx context.Context) pgx.Row

+ func (b DeleteBuilder) RunWith(runner BaseRunner) DeleteBuilder

+ func (b DeleteBuilder) ScanContext(ctx context.Context, dest ...interface{}) error

+ func (b DeleteBuilder) Suffix(sql string, args ...interface{}) DeleteBuilder

+ func (b DeleteBuilder) SuffixExpr(expr Sqlizer) DeleteBuilder

+ func (b DeleteBuilder) ToSql() (string, []interface{}, error)

+ func (b DeleteBuilder) Where(pred interface{}, args ...interface{}) DeleteBuilder

+ type Eq map[string]interface

+ func (eq Eq) ToSql() (sql string, args []interface{}, err error)

+ type Execer interface

+ Exec func(ctx context.Context, sql string, arguments ...interface{}) (commandTag pgconn.CommandTag, err error)

+ type ExecerContext interface

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (pgconn.CommandTag, error)

+ type Gt Lt

+ func (gt Gt) ToSql() (sql string, args []interface{}, err error)

+ type GtOrEq Lt

+ func (gtOrEq GtOrEq) ToSql() (sql string, args []interface{}, err error)

+ type ILike Like

+ func (ilk ILike) ToSql() (sql string, args []interface{}, err error)

+ type InsertBuilder builder.Builder

+ func Insert(into string) InsertBuilder

+ func Replace(into string) InsertBuilder

+ func (b InsertBuilder) Columns(columns ...string) InsertBuilder

+ func (b InsertBuilder) Exec() (pgconn.CommandTag, error)

+ func (b InsertBuilder) ExecContext(ctx context.Context) (pgconn.CommandTag, error)

+ func (b InsertBuilder) Into(from string) InsertBuilder

+ func (b InsertBuilder) MustSql() (string, []interface{})

+ func (b InsertBuilder) Options(options ...string) InsertBuilder

+ func (b InsertBuilder) PlaceholderFormat(f PlaceholderFormat) InsertBuilder

+ func (b InsertBuilder) Prefix(sql string, args ...interface{}) InsertBuilder

+ func (b InsertBuilder) PrefixExpr(expr Sqlizer) InsertBuilder

+ func (b InsertBuilder) Query() (pgx.Rows, error)

+ func (b InsertBuilder) QueryContext(ctx context.Context) (pgx.Rows, error)

+ func (b InsertBuilder) QueryRow() pgx.Row

+ func (b InsertBuilder) QueryRowContext(ctx context.Context) pgx.Row

+ func (b InsertBuilder) RunWith(runner BaseRunner) InsertBuilder

+ func (b InsertBuilder) Scan(dest ...interface{}) error

+ func (b InsertBuilder) ScanContext(ctx context.Context, dest ...interface{}) error

+ func (b InsertBuilder) Select(sb SelectBuilder) InsertBuilder

+ func (b InsertBuilder) SetMap(clauses map[string]interface{}) InsertBuilder

+ func (b InsertBuilder) Suffix(sql string, args ...interface{}) InsertBuilder

+ func (b InsertBuilder) SuffixExpr(expr Sqlizer) InsertBuilder

+ func (b InsertBuilder) ToSql() (string, []interface{}, error)

+ func (b InsertBuilder) Values(values ...interface{}) InsertBuilder

+ type Like map[string]interface

+ func (lk Like) ToSql() (sql string, args []interface{}, err error)

+ type Lt map[string]interface

+ func (lt Lt) ToSql() (sql string, args []interface{}, err error)

+ type LtOrEq Lt

+ func (ltOrEq LtOrEq) ToSql() (sql string, args []interface{}, err error)

+ type NotEq Eq

+ func (neq NotEq) ToSql() (sql string, args []interface{}, err error)

+ type NotILike Like

+ func (nilk NotILike) ToSql() (sql string, args []interface{}, err error)

+ type NotLike Like

+ func (nlk NotLike) ToSql() (sql string, args []interface{}, err error)

+ type Or conj

+ func (o Or) ToSql() (string, []interface{}, error)

+ type PlaceholderFormat interface

+ ReplacePlaceholders func(sql string) (string, error)

+ type QueryRower interface

+ QueryRow func(ctx context.Context, query string, args ...interface{}) pgx.Row

+ type QueryRowerContext interface

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) pgx.Row

+ type Queryer interface

+ Query func(ctx context.Context, sql string, args ...interface{}) (pgx.Rows, error)

+ type QueryerContext interface

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (pgx.Rows, error)

+ type Row struct

+ func (r *Row) Scan(dest ...interface{}) error

+ type RowScanner interface

+ Scan func(...interface{}) error

+ type Runner interface

+ func WrapStdSql(stdSql StdSql) Runner

+ type RunnerContext interface

+ func WrapStdSqlCtx(stdSqlCtx StdSqlCtx) RunnerContext

+ type SelectBuilder builder.Builder

+ func Select(columns ...string) SelectBuilder

+ func (b SelectBuilder) Column(column interface{}, args ...interface{}) SelectBuilder

+ func (b SelectBuilder) Columns(columns ...string) SelectBuilder

+ func (b SelectBuilder) CrossJoin(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) Distinct() SelectBuilder

+ func (b SelectBuilder) Exec() (pgconn.CommandTag, error)

+ func (b SelectBuilder) ExecContext(ctx context.Context) (pgconn.CommandTag, error)

+ func (b SelectBuilder) From(from string) SelectBuilder

+ func (b SelectBuilder) FromSelect(from SelectBuilder, alias string) SelectBuilder

+ func (b SelectBuilder) GroupBy(groupBys ...string) SelectBuilder

+ func (b SelectBuilder) Having(pred interface{}, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) InnerJoin(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) Join(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) JoinClause(pred interface{}, args ...interface{}) SelectBuilder

+ func (b SelectBuilder) LeftJoin(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) Limit(limit uint64) SelectBuilder

+ func (b SelectBuilder) MustSql() (string, []interface{})

+ func (b SelectBuilder) Offset(offset uint64) SelectBuilder

+ func (b SelectBuilder) Options(options ...string) SelectBuilder

+ func (b SelectBuilder) OrderBy(orderBys ...string) SelectBuilder

+ func (b SelectBuilder) OrderByClause(pred interface{}, args ...interface{}) SelectBuilder

+ func (b SelectBuilder) PlaceholderFormat(f PlaceholderFormat) SelectBuilder

+ func (b SelectBuilder) Prefix(sql string, args ...interface{}) SelectBuilder

+ func (b SelectBuilder) PrefixExpr(expr Sqlizer) SelectBuilder

+ func (b SelectBuilder) Query() (pgx.Rows, error)

+ func (b SelectBuilder) QueryContext(ctx context.Context) (pgx.Rows, error)

+ func (b SelectBuilder) QueryRow() pgx.Row

+ func (b SelectBuilder) QueryRowContext(ctx context.Context) pgx.Row

+ func (b SelectBuilder) RemoveLimit() SelectBuilder

+ func (b SelectBuilder) RemoveOffset() SelectBuilder

+ func (b SelectBuilder) RightJoin(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) RunWith(runner BaseRunner) SelectBuilder

+ func (b SelectBuilder) Scan(dest ...interface{}) error

+ func (b SelectBuilder) ScanContext(ctx context.Context, dest ...interface{}) error

+ func (b SelectBuilder) Suffix(sql string, args ...interface{}) SelectBuilder

+ func (b SelectBuilder) SuffixExpr(expr Sqlizer) SelectBuilder

+ func (b SelectBuilder) ToSql() (string, []interface{}, error)

+ func (b SelectBuilder) Where(pred interface{}, args ...interface{}) SelectBuilder

+ type Sqlizer interface

+ ToSql func() (string, []interface{}, error)

+ func Expr(sql string, args ...interface{}) Sqlizer

+ type StatementBuilderType builder.Builder

+ func (b StatementBuilderType) Delete(from string) DeleteBuilder

+ func (b StatementBuilderType) Insert(into string) InsertBuilder

+ func (b StatementBuilderType) PlaceholderFormat(f PlaceholderFormat) StatementBuilderType

+ func (b StatementBuilderType) Replace(into string) InsertBuilder

+ func (b StatementBuilderType) RunWith(runner BaseRunner) StatementBuilderType

+ func (b StatementBuilderType) Select(columns ...string) SelectBuilder

+ func (b StatementBuilderType) Update(table string) UpdateBuilder

+ func (b StatementBuilderType) Where(pred interface{}, args ...interface{}) StatementBuilderType

+ type StdSql interface

+ Exec func(ctx context.Context, sql string, arguments ...interface{}) (commandTag pgconn.CommandTag, err error)

+ Query func(ctx context.Context, sql string, args ...interface{}) (pgx.Rows, error)

+ QueryRow func(ctx context.Context, sql string, args ...interface{}) pgx.Row

+ type StdSqlCtx interface

+ ExecContext func(context.Context, string, ...interface{}) (pgconn.CommandTag, error)

+ QueryContext func(context.Context, string, ...interface{}) (pgx.Rows, error)

+ QueryRowContext func(context.Context, string, ...interface{}) pgx.Row

+ type StmtCache struct

+ type UpdateBuilder builder.Builder

+ func Update(table string) UpdateBuilder

+ func (b UpdateBuilder) Exec(ctx context.Context) (pgconn.CommandTag, error)

+ func (b UpdateBuilder) ExecContext(ctx context.Context) (pgconn.CommandTag, error)

+ func (b UpdateBuilder) Limit(limit uint64) UpdateBuilder

+ func (b UpdateBuilder) MustSql() (string, []interface{})

+ func (b UpdateBuilder) Offset(offset uint64) UpdateBuilder

+ func (b UpdateBuilder) OrderBy(orderBys ...string) UpdateBuilder

+ func (b UpdateBuilder) PlaceholderFormat(f PlaceholderFormat) UpdateBuilder

+ func (b UpdateBuilder) Prefix(sql string, args ...interface{}) UpdateBuilder

+ func (b UpdateBuilder) PrefixExpr(expr Sqlizer) UpdateBuilder

+ func (b UpdateBuilder) Query() (pgx.Rows, error)

+ func (b UpdateBuilder) QueryContext(ctx context.Context) (pgx.Rows, error)

+ func (b UpdateBuilder) QueryRow() pgx.Row

+ func (b UpdateBuilder) QueryRowContext(ctx context.Context) pgx.Row

+ func (b UpdateBuilder) RunWith(runner BaseRunner) UpdateBuilder

+ func (b UpdateBuilder) Scan(dest ...interface{}) error

+ func (b UpdateBuilder) ScanContext(ctx context.Context, dest ...interface{}) error

+ func (b UpdateBuilder) Set(column string, value interface{}) UpdateBuilder

+ func (b UpdateBuilder) SetMap(clauses map[string]interface{}) UpdateBuilder

+ func (b UpdateBuilder) Suffix(sql string, args ...interface{}) UpdateBuilder

+ func (b UpdateBuilder) SuffixExpr(expr Sqlizer) UpdateBuilder

+ func (b UpdateBuilder) Table(table string) UpdateBuilder

+ func (b UpdateBuilder) ToSql() (string, []interface{}, error)

+ func (b UpdateBuilder) Where(pred interface{}, args ...interface{}) UpdateBuilder