sql

package

Go to main page

Versions in this module

v0

v0.3.1

Sep 19, 2026

Changes in this version

type DeleteBuilder

+ func (d *DeleteBuilder) Conjunctive() bool

+ func (d *DeleteBuilder) Equalities() []Equality

+ type Equality struct

+ Column string

+ Values []any

type Selector

+ func (s *Selector) Conjunctive() bool

+ func (s *Selector) Equalities() []Equality

+ func (s *Selector) Locked() bool

+ func (s *Selector) TableReferences() map[string]int

+ func (s *Selector) Tables() []string

type UpdateBuilder

+ func (u *UpdateBuilder) Conjunctive() bool

+ func (u *UpdateBuilder) Equalities() []Equality

v0.3.0

Sep 19, 2026

Changes in this version

+ const Default

+ func ScanReflect(rows dialect.Rows, destination any) error

+ func VarsFromContext(ctx context.Context) [][2]string

type Builder

+ func (b *Builder) Byte(c byte) *Builder

type ConflictOption

+ func DoSelect() ConflictOption

type DeleteBuilder

+ func (d *DeleteBuilder) QueryErr() (string, []any, error)

+ func (d *DeleteBuilder) Returning(columns ...string) *DeleteBuilder

+ func (d *DeleteBuilder) ReturningOldNew(old, new []string) *DeleteBuilder

type Driver

+ func (d *Driver) Capabilities() dialect.Capabilities

type InsertBuilder

+ func (i *InsertBuilder) ConflictDoSelect() bool

+ func (i *InsertBuilder) ReturningOldNew(old, new []string) *InsertBuilder

+ type Option func(*Driver)

+ func WithCapabilities(capabilities dialect.Capabilities) Option

type Rows

+ func (r *Rows) Close() error

+ func (r *Rows) Err() error

+ func (r *Rows) Scan(destinations ...any) error

type Selector

+ func (s *Selector) OrderTerms() []Querier

type Tx

+ func (t *Tx) Commit() error

+ func (t *Tx) Rollback() error

type UpdateBuilder

+ func (u *UpdateBuilder) QueryErr() (string, []any, error)

+ func (u *UpdateBuilder) ReturningOldNew(old, new []string) *UpdateBuilder

v0.2.0

Aug 15, 2026

v0.1.0

Jul 7, 2026

Changes in this version

+ func AndPredicates[P ~func(*Selector)](predicates ...P) func(*Selector)

+ func As(ident string, as string) string

+ func Asc(column string) string

+ func Avg(ident string) string

+ func Count(ident string) string

+ func Desc(column string) string

+ func Distinct(idents ...string) string

+ func FieldContains(name string, substr string) func(*Selector)

+ func FieldContainsFold(name string, substr string) func(*Selector)

+ func FieldEQ(name string, v any) func(*Selector)

+ func FieldEqualFold(name string, substr string) func(*Selector)

+ func FieldGT(name string, v any) func(*Selector)

+ func FieldGTE(name string, v any) func(*Selector)

+ func FieldHasPrefix(name string, prefix string) func(*Selector)

+ func FieldHasPrefixFold(name string, prefix string) func(*Selector)

+ func FieldHasSuffix(name string, suffix string) func(*Selector)

+ func FieldHasSuffixFold(name string, suffix string) func(*Selector)

+ func FieldIn[T any](name string, vs ...T) func(*Selector)

+ func FieldIsNull(name string) func(*Selector)

+ func FieldLT(name string, v any) func(*Selector)

+ func FieldLTE(name string, v any) func(*Selector)

+ func FieldNEQ(name string, v any) func(*Selector)

+ func FieldNotIn[T any](name string, vs ...T) func(*Selector)

+ func FieldNotNull(name string) func(*Selector)

+ func FieldsEQ(field1, field2 string) func(*Selector)

+ func FieldsGT(field1, field2 string) func(*Selector)

+ func FieldsGTE(field1, field2 string) func(*Selector)

+ func FieldsHasPrefix(field1, field2 string) func(*Selector)

+ func FieldsLT(field1, field2 string) func(*Selector)

+ func FieldsLTE(field1, field2 string) func(*Selector)

+ func FieldsNEQ(field1, field2 string) func(*Selector)

+ func Lower(ident string) string

+ func Max(ident string) string

+ func Min(ident string) string

+ func NotPredicates[P ~func(*Selector)](predicates ...P) func(*Selector)

+ func OrPredicates[P ~func(*Selector)](predicates ...P) func(*Selector)

+ func OrderByRand() func(*Selector)

+ func ScanBool(rows ColumnScanner) (bool, error)

+ func ScanInt(rows ColumnScanner) (int, error)

+ func ScanInt64(rows ColumnScanner) (int64, error)

+ func ScanOne(rows ColumnScanner, v any) error

+ func ScanSlice(rows ColumnScanner, v any) error

+ func ScanString(rows ColumnScanner) (string, error)

+ func ScanTypeOf(rows *Rows, i int) any

+ func ScanValue(rows ColumnScanner) (driver.Value, error)

+ func Sum(ident string) string

+ func VarFromContext(ctx context.Context, name string) (string, bool)

+ func WithIntVar(ctx context.Context, name string, value int) context.Context

+ func WithVar(ctx context.Context, name, value string) context.Context

+ type Builder struct

+ func (b *Builder) AddError(err error) *Builder

+ func (b *Builder) Arg(a any) *Builder

+ func (b *Builder) Argf(format string, a any) *Builder

+ func (b *Builder) Args(a ...any) *Builder

+ func (b *Builder) Comma() *Builder

+ func (b *Builder) Err() error

+ func (b *Builder) Ident(s string) *Builder

+ func (b *Builder) IdentComma(s ...string) *Builder

+ func (b *Builder) Join(qs ...Querier) *Builder

+ func (b *Builder) JoinComma(qs ...Querier) *Builder

+ func (b *Builder) Len() int

+ func (b *Builder) Nested(f func(*Builder)) *Builder

+ func (b *Builder) Pad() *Builder

+ func (b *Builder) Quote(ident string) string

+ func (b *Builder) Reset() *Builder

+ func (b *Builder) S(s string) *Builder

+ func (b *Builder) SetDialect(dialect string)

+ func (b *Builder) SetTotal(total int)

+ func (b *Builder) String() string

+ func (b *Builder) Wrap(f func(*Builder)) *Builder

+ func (b *Builder) WriteByte(c byte) *Builder

+ func (b *Builder) WriteOp(op Op) *Builder

+ func (b *Builder) WriteString(s string) *Builder

+ func (b Builder) Dialect() string

+ func (b Builder) Query() (string, []any)

+ func (b Builder) Total() int

+ type ColumnBuilder struct

+ func Column(name string) *ColumnBuilder

+ func (c *ColumnBuilder) Query() (string, []any)

+ func (c *ColumnBuilder) Type(t string) *ColumnBuilder

+ type ColumnCheck func(table, column string) error

+ func NewColumnCheck(checks map[string]func(string) bool) ColumnCheck

+ type ColumnScanner interface

+ Close func() error

+ ColumnTypes func() ([]*sql.ColumnType, error)

+ Columns func() ([]string, error)

+ Err func() error

+ Next func() bool

+ NextResultSet func() bool

+ Scan func(dest ...any) error

+ type ConflictOption func(*conflict)

+ func ConflictColumns(names ...string) ConflictOption

+ func ConflictConstraint(name string) ConflictOption

+ func ConflictWhere(p *Predicate) ConflictOption

+ func DoNothing() ConflictOption

+ func ResolveWith(fn func(*UpdateSet)) ConflictOption

+ func ResolveWithIgnore() ConflictOption

+ func ResolveWithNewValues() ConflictOption

+ func UpdateWhere(p *Predicate) ConflictOption

+ type Conn struct

+ func (c Conn) Exec(ctx context.Context, query string, args, v any) (rerr error)

+ func (c Conn) Query(ctx context.Context, query string, args, v any) error

+ type DeleteBuilder struct

+ func Delete(table string) *DeleteBuilder

+ func (d *DeleteBuilder) FromSelect(s *Selector) *DeleteBuilder

+ func (d *DeleteBuilder) Query() (string, []any)

+ func (d *DeleteBuilder) Schema(name string) *DeleteBuilder

+ func (d *DeleteBuilder) Where(p *Predicate) *DeleteBuilder

+ type DialectBuilder struct

+ func Dialect(name string) *DialectBuilder

+ func (d *DialectBuilder) Column(name string) *ColumnBuilder

+ func (d *DialectBuilder) CreateView(name string) *ViewBuilder

+ func (d *DialectBuilder) Delete(table string) *DeleteBuilder

+ func (d *DialectBuilder) Expr(f func(*Builder)) Querier

+ func (d *DialectBuilder) Insert(table string) *InsertBuilder

+ func (d *DialectBuilder) Select(columns ...string) *Selector

+ func (d *DialectBuilder) SelectExpr(exprs ...Querier) *Selector

+ func (d *DialectBuilder) String(f func(*Builder)) string

+ func (d *DialectBuilder) Table(name string) *SelectTable

+ func (d *DialectBuilder) Update(table string) *UpdateBuilder

+ func (d *DialectBuilder) With(name string) *WithBuilder

+ type Driver struct

+ func NewDriver(dialect string, c Conn) *Driver

+ func Open(dialect, source string) (*Driver, error)

+ func OpenDB(dialect string, db *sql.DB) *Driver

+ func (d *Driver) BeginTx(ctx context.Context, opts *TxOptions) (dialect.Tx, error)

+ func (d *Driver) Close() error

+ func (d *Driver) Tx(ctx context.Context) (dialect.Tx, error)

+ func (d Driver) DB() *sql.DB

+ func (d Driver) Dialect() string

+ type ExecQuerier interface

+ ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error)

+ type Func struct

+ func (f *Func) Append(fn func(*Builder)) *Func

+ func (f *Func) Avg(ident string)

+ func (f *Func) Count(ident string)

+ func (f *Func) Lower(ident string)

+ func (f *Func) Max(ident string)

+ func (f *Func) Min(ident string)

+ func (f *Func) String() string

+ func (f *Func) Sum(ident string)

+ type InsertBuilder struct

+ func Insert(table string) *InsertBuilder

+ func (i *InsertBuilder) Columns(columns ...string) *InsertBuilder

+ func (i *InsertBuilder) Default() *InsertBuilder

+ func (i *InsertBuilder) OnConflict(opts ...ConflictOption) *InsertBuilder

+ func (i *InsertBuilder) Query() (string, []any)

+ func (i *InsertBuilder) QueryErr() (string, []any, error)

+ func (i *InsertBuilder) Returning(columns ...string) *InsertBuilder

+ func (i *InsertBuilder) Schema(name string) *InsertBuilder

+ func (i *InsertBuilder) Set(column string, v any) *InsertBuilder

+ func (i *InsertBuilder) Values(values ...any) *InsertBuilder

+ type LockAction string

+ const NoWait

+ const SkipLocked

+ type LockOption func(*LockOptions)

+ func WithLockAction(action LockAction) LockOption

+ func WithLockClause(clause string) LockOption

+ func WithLockTables(tables ...string) LockOption

+ type LockOptions struct

+ Action LockAction

+ Strength LockStrength

+ Tables []string

+ type LockStrength string

+ const LockKeyShare

+ const LockNoKeyUpdate

+ const LockShare

+ const LockUpdate

+ type NullBool = sql.NullBool

+ type NullFloat64 = sql.NullFloat64

+ type NullInt64 = sql.NullInt64

+ type NullScanner struct

+ S sql.Scanner

+ Valid bool

+ func (n *NullScanner) Scan(value any) error

+ type NullString = sql.NullString

+ type NullTime = sql.NullTime

+ type Op int

+ const OpAdd

+ const OpDiv

+ const OpEQ

+ const OpGT

+ const OpGTE

+ const OpIn

+ const OpIsNull

+ const OpLT

+ const OpLTE

+ const OpLike

+ const OpMod

+ const OpMul

+ const OpNEQ

+ const OpNotIn

+ const OpNotNull

+ const OpSub

+ type OrderExprTerm struct

+ Expr func(*Selector) Querier

+ func OrderByCount(field string, opts ...OrderTermOption) *OrderExprTerm

+ func OrderBySum(field string, opts ...OrderTermOption) *OrderExprTerm

+ type OrderFieldTerm struct

+ Field string

+ func OrderByField(field string, opts ...OrderTermOption) *OrderFieldTerm

+ func (f *OrderFieldTerm) ToFunc() func(*Selector)

+ type OrderTerm interface

+ type OrderTermOption func(*OrderTermOptions)

+ func OrderAs(as string) OrderTermOption

+ func OrderAsc() OrderTermOption

+ func OrderDesc() OrderTermOption

+ func OrderNullsFirst() OrderTermOption

+ func OrderNullsLast() OrderTermOption

+ func OrderSelectAs(as string) OrderTermOption

+ func OrderSelected() OrderTermOption

+ type OrderTermOptions struct

+ As string

+ Desc bool

+ NullsFirst bool

+ NullsLast bool

+ Selected bool

+ func NewOrderTermOptions(opts ...OrderTermOption) *OrderTermOptions

+ type ParamFormatter interface

+ FormatParam func(placeholder string, info *StmtInfo) string

+ type Predicate struct

+ func And(preds ...*Predicate) *Predicate

+ func ColumnsEQ(col1, col2 string) *Predicate

+ func ColumnsGT(col1, col2 string) *Predicate

+ func ColumnsGTE(col1, col2 string) *Predicate

+ func ColumnsHasPrefix(col, prefixC string) *Predicate

+ func ColumnsLT(col1, col2 string) *Predicate

+ func ColumnsLTE(col1, col2 string) *Predicate

+ func ColumnsNEQ(col1, col2 string) *Predicate

+ func ColumnsOp(col1, col2 string, op Op) *Predicate

+ func CompositeGT(columns []string, args ...any) *Predicate

+ func CompositeLT(columns []string, args ...any) *Predicate

+ func Contains(col, sub string) *Predicate

+ func ContainsFold(col, sub string) *Predicate

+ func EQ(col string, value any) *Predicate

+ func EqualFold(col, sub string) *Predicate

+ func Exists(query Querier) *Predicate

+ func ExprP(exr string, args ...any) *Predicate

+ func False() *Predicate

+ func GT(col string, value any) *Predicate

+ func GTE(col string, value any) *Predicate

+ func HasPrefix(col, prefix string) *Predicate

+ func HasPrefixFold(col, prefix string) *Predicate

+ func HasSuffix(col, suffix string) *Predicate

+ func HasSuffixFold(col, suffix string) *Predicate

+ func In(col string, args ...any) *Predicate

+ func InInts(col string, args ...int) *Predicate

+ func InValues(col string, args ...driver.Value) *Predicate

+ func IsFalse(col string) *Predicate

+ func IsNull(col string) *Predicate

+ func IsTrue(col string) *Predicate

+ func LT(col string, value any) *Predicate

+ func LTE(col string, value any) *Predicate

+ func Like(col, pattern string) *Predicate

+ func NEQ(col string, value any) *Predicate

+ func Not(pred *Predicate) *Predicate

+ func NotExists(query Querier) *Predicate

+ func NotIn(col string, args ...any) *Predicate

+ func NotNull(col string) *Predicate

+ func Or(preds ...*Predicate) *Predicate

+ func P(fns ...func(*Builder)) *Predicate

+ func (p *Predicate) Append(f func(*Builder)) *Predicate

+ func (p *Predicate) ColumnsEQ(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsGT(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsGTE(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsHasPrefix(col, prefixC string) *Predicate

+ func (p *Predicate) ColumnsLT(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsLTE(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsNEQ(col1, col2 string) *Predicate

+ func (p *Predicate) ColumnsOp(col1, col2 string, op Op) *Predicate

+ func (p *Predicate) CompositeGT(columns []string, args ...any) *Predicate

+ func (p *Predicate) CompositeLT(columns []string, args ...any) *Predicate

+ func (p *Predicate) Contains(col, substr string) *Predicate

+ func (p *Predicate) ContainsFold(col, substr string) *Predicate

+ func (p *Predicate) EQ(col string, arg any) *Predicate

+ func (p *Predicate) EqualFold(col, sub string) *Predicate

+ func (p *Predicate) Exists(query Querier) *Predicate

+ func (p *Predicate) False() *Predicate

+ func (p *Predicate) GT(col string, arg any) *Predicate

+ func (p *Predicate) GTE(col string, arg any) *Predicate

+ func (p *Predicate) HasPrefix(col, prefix string) *Predicate

+ func (p *Predicate) HasPrefixFold(col, prefix string) *Predicate

+ func (p *Predicate) HasSuffix(col, suffix string) *Predicate

+ func (p *Predicate) HasSuffixFold(col, suffix string) *Predicate

+ func (p *Predicate) In(col string, args ...any) *Predicate

+ func (p *Predicate) InInts(col string, args ...int) *Predicate

+ func (p *Predicate) InValues(col string, args ...driver.Value) *Predicate

+ func (p *Predicate) IsFalse(col string) *Predicate

+ func (p *Predicate) IsNull(col string) *Predicate

+ func (p *Predicate) IsTrue(col string) *Predicate

+ func (p *Predicate) LT(col string, arg any) *Predicate

+ func (p *Predicate) LTE(col string, arg any) *Predicate

+ func (p *Predicate) Like(col, pattern string) *Predicate

+ func (p *Predicate) NEQ(col string, arg any) *Predicate

+ func (p *Predicate) Not() *Predicate

+ func (p *Predicate) NotExists(query Querier) *Predicate

+ func (p *Predicate) NotIn(col string, args ...any) *Predicate

+ func (p *Predicate) NotNull(col string) *Predicate

+ func (p *Predicate) Query() (string, []any)

+ type Querier interface

+ Query func() (string, []any)

+ func DescExpr(x Querier) Querier

+ func Except(selectors ...*Selector) Querier

+ func ExceptAll(selectors ...*Selector) Querier

+ func Expr(exr string, args ...any) Querier

+ func ExprFunc(fn func(*Builder)) Querier

+ func Intersect(selectors ...*Selector) Querier

+ func IntersectAll(selectors ...*Selector) Querier

+ func Raw(s string) Querier

+ func Union(selectors ...*Selector) Querier

+ func UnionAll(selectors ...*Selector) Querier

+ type Queries []Querier

+ func (n Queries) Query() (string, []any)

+ type Result = sql.Result

+ type Rows struct

+ type SelectTable struct

+ func Table(name string) *SelectTable

+ func (s *SelectTable) As(alias string) *SelectTable

+ func (s *SelectTable) C(column string) string

+ func (s *SelectTable) Columns(columns ...string) []string

+ func (s *SelectTable) Schema(name string) *SelectTable

+ func (s *SelectTable) Unquote() *SelectTable

+ type SelectValues map[string]any

+ func (s *SelectValues) Set(name string, v any)

+ func (s SelectValues) Get(name string) (any, error)

+ type Selector struct

+ func Select(columns ...string) *Selector

+ func SelectExpr(exprs ...Querier) *Selector

+ func (s *Selector) AppendFrom(t TableView) *Selector

+ func (s *Selector) AppendFromExpr(x Querier) *Selector

+ func (s *Selector) AppendSelect(columns ...string) *Selector

+ func (s *Selector) AppendSelectAs(column, as string) *Selector

+ func (s *Selector) AppendSelectExpr(exprs ...Querier) *Selector

+ func (s *Selector) AppendSelectExprAs(expr Querier, as string) *Selector

+ func (s *Selector) As(alias string) *Selector

+ func (s *Selector) C(column string) string

+ func (s *Selector) ClearOrder() *Selector

+ func (s *Selector) Clone() *Selector

+ func (s *Selector) CollectPredicates() *Selector

+ func (s *Selector) CollectedPredicates() []*Predicate

+ func (s *Selector) Columns(columns ...string) []string

+ func (s *Selector) Context() context.Context

+ func (s *Selector) Count(columns ...string) *Selector

+ func (s *Selector) Distinct() *Selector

+ func (s *Selector) Except(t TableView) *Selector

+ func (s *Selector) ExceptAll(t TableView) *Selector

+ func (s *Selector) FindSelection(name string) (matches []string)

+ func (s *Selector) For(l LockStrength, opts ...LockOption) *Selector

+ func (s *Selector) ForShare(opts ...LockOption) *Selector

+ func (s *Selector) ForUpdate(opts ...LockOption) *Selector

+ func (s *Selector) From(t TableView) *Selector

+ func (s *Selector) FromExpr(x Querier) *Selector

+ func (s *Selector) FromSelect(s2 *Selector) *Selector

+ func (s *Selector) FullJoin(t TableView) *Selector

+ func (s *Selector) GroupBy(columns ...string) *Selector

+ func (s *Selector) HasJoins() bool

+ func (s *Selector) Having(p *Predicate) *Selector

+ func (s *Selector) Intersect(t TableView) *Selector

+ func (s *Selector) IntersectAll(t TableView) *Selector

+ func (s *Selector) Join(t TableView) *Selector

+ func (s *Selector) JoinedTable(name string) (*SelectTable, bool)

+ func (s *Selector) JoinedTableView(name string) (TableView, bool)

+ func (s *Selector) LeftJoin(t TableView) *Selector

+ func (s *Selector) Limit(limit int) *Selector

+ func (s *Selector) New() *Selector

+ func (s *Selector) Not() *Selector

+ func (s *Selector) Offset(offset int) *Selector

+ func (s *Selector) On(c1, c2 string) *Selector

+ func (s *Selector) OnP(p *Predicate) *Selector

+ func (s *Selector) Or() *Selector

+ func (s *Selector) OrderBy(columns ...string) *Selector

+ func (s *Selector) OrderColumns() []string

+ func (s *Selector) OrderExpr(exprs ...Querier) *Selector

+ func (s *Selector) OrderExprFunc(f func(*Builder)) *Selector

+ func (s *Selector) P() *Predicate

+ func (s *Selector) Prefix(queries ...Querier) *Selector

+ func (s *Selector) Query() (string, []any)

+ func (s *Selector) RightJoin(t TableView) *Selector

+ func (s *Selector) Select(columns ...string) *Selector

+ func (s *Selector) SelectDistinct(columns ...string) *Selector

+ func (s *Selector) SelectExpr(exprs ...Querier) *Selector

+ func (s *Selector) SelectedColumns() []string

+ func (s *Selector) SetDistinct(v bool) *Selector

+ func (s *Selector) SetP(p *Predicate) *Selector

+ func (s *Selector) Table() *SelectTable

+ func (s *Selector) TableName() string

+ func (s *Selector) UncollectedPredicates() *Selector

+ func (s *Selector) Union(t TableView) *Selector

+ func (s *Selector) UnionAll(t TableView) *Selector

+ func (s *Selector) UnionDistinct(t TableView) *Selector

+ func (s *Selector) UnqualifiedColumns() []string

+ func (s *Selector) Where(p *Predicate) *Selector

+ func (s *Selector) WithContext(ctx context.Context) *Selector

+ type StmtInfo struct

+ Dialect string

+ type TableView interface

+ C func(string) string

+ type Tx struct

+ type TxOptions = sql.TxOptions

+ type UnknownType any

+ type UpdateBuilder struct

+ func Update(table string) *UpdateBuilder

+ func (u *UpdateBuilder) Add(column string, v any) *UpdateBuilder

+ func (u *UpdateBuilder) Empty() bool

+ func (u *UpdateBuilder) FromSelect(s *Selector) *UpdateBuilder

+ func (u *UpdateBuilder) Limit(limit int) *UpdateBuilder

+ func (u *UpdateBuilder) OrderBy(columns ...string) *UpdateBuilder

+ func (u *UpdateBuilder) Prefix(stmts ...Querier) *UpdateBuilder

+ func (u *UpdateBuilder) Query() (string, []any)

+ func (u *UpdateBuilder) Returning(columns ...string) *UpdateBuilder

+ func (u *UpdateBuilder) Schema(name string) *UpdateBuilder

+ func (u *UpdateBuilder) Set(column string, v any) *UpdateBuilder

+ func (u *UpdateBuilder) SetNull(column string) *UpdateBuilder

+ func (u *UpdateBuilder) Where(p *Predicate) *UpdateBuilder

+ type UpdateSet struct

+ func (u *UpdateSet) Add(column string, v any) *UpdateSet

+ func (u *UpdateSet) Columns() []string

+ func (u *UpdateSet) Set(column string, v any) *UpdateSet

+ func (u *UpdateSet) SetExcluded(name string) *UpdateSet

+ func (u *UpdateSet) SetIgnore(name string) *UpdateSet

+ func (u *UpdateSet) SetNull(column string) *UpdateSet

+ func (u *UpdateSet) Table() *SelectTable

+ func (u *UpdateSet) UpdateColumns() []string

+ type ViewBuilder struct

+ func CreateView(name string) *ViewBuilder

+ func (v *ViewBuilder) As(as Querier) *ViewBuilder

+ func (v *ViewBuilder) Column(c *ColumnBuilder) *ViewBuilder

+ func (v *ViewBuilder) Columns(columns ...*ColumnBuilder) *ViewBuilder

+ func (v *ViewBuilder) IfNotExists() *ViewBuilder

+ func (v *ViewBuilder) Query() (string, []any)

+ func (v *ViewBuilder) Schema(name string) *ViewBuilder

+ type WindowBuilder struct

+ func RowNumber() *WindowBuilder

+ func Window(fn func(*Builder)) *WindowBuilder

+ func (w *WindowBuilder) OrderBy(columns ...string) *WindowBuilder

+ func (w *WindowBuilder) OrderExpr(exprs ...Querier) *WindowBuilder

+ func (w *WindowBuilder) PartitionBy(columns ...string) *WindowBuilder

+ func (w *WindowBuilder) PartitionExpr(x Querier) *WindowBuilder

+ func (w *WindowBuilder) Query() (string, []any)

+ type WithBuilder struct

+ func With(name string, columns ...string) *WithBuilder

+ func WithRecursive(name string, columns ...string) *WithBuilder

+ func (w *WithBuilder) As(s Querier) *WithBuilder

+ func (w *WithBuilder) C(column string) string

+ func (w *WithBuilder) Name() string

+ func (w *WithBuilder) Query() (string, []any)

+ func (w *WithBuilder) With(name string, columns ...string) *WithBuilder

+ type Wrapper struct

+ func (w *Wrapper) Dialect() string

+ func (w *Wrapper) Query() (string, []any)

+ func (w *Wrapper) SetDialect(name string)

+ func (w *Wrapper) SetTotal(total int)

+ func (w *Wrapper) Total() int

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL