Versions in this module Expand all Collapse all v0 v0.1.0 Oct 11, 2026 Changes in this version + const DialectClickHouse + const DialectMySQL + const DialectPostgres + const DialectSQLite + const DialectUnknown + const FrameRange + const FrameRows + const JoinCross + const JoinInner + const JoinLeft + const JoinRight + const LogicAnd + const LogicNot + const LogicOr + const NullsFirst + const NullsLast + const OpAdd + const OpConcat + const OpDiv + const OpEq + const OpGreater + const OpGreaterEq + const OpIn + const OpIsDistinctFrom + const OpIsFalse + const OpIsNotDistinctFrom + const OpIsNotNull + const OpIsNull + const OpIsTrue + const OpIsUnknown + const OpLess + const OpLessEq + const OpLike + const OpMod + const OpMul + const OpNotEq + const OpNotIn + const OpNotLike + const OpSub + const SlotAfterColumns + const SlotAfterFrom + const SlotAfterGroupBy + const SlotAfterHaving + const SlotAfterInsert + const SlotAfterOffset + const SlotAfterOrder + const SlotAfterSelect + const SlotAfterSet + const SlotAfterTarget + const SlotAfterVerb + const SlotAfterWhere + const SlotBeforeOrder + const SlotBeforeValues + const SlotBeforeWhere + const SlotInsertBody + const SlotTail + const SortAsc + const SortDesc + var ErrDuplicateAlias = stmt.ErrDuplicateAlias + var ErrJoinWithoutFrom = stmt.ErrJoinWithoutFrom + var ErrMultipleRows = exec.ErrMultipleRows + var ErrNoAssignments = stmt.ErrNoAssignments + var ErrNoColumns = stmt.ErrNoColumns + var ErrNoLikeEscape = expr.ErrNoLikeEscape + var ErrNoLiteralQuoting = render.ErrNoLiteralQuoting + var ErrNoReturning = stmt.ErrNoReturning + var ErrNoRows = exec.ErrNoRows + var ErrNoTargets = stmt.ErrNoTargets + var ErrNoWhere = stmt.ErrNoWhere + var ErrNotAColumn = stmt.ErrNotAColumn + var ErrNotInlinable = render.ErrNotInlinable + var ErrQueryInUse = stmt.ErrQueryInUse + var ErrRowWidth = stmt.ErrRowWidth + var ErrSetOpArity = stmt.ErrSetOpArity + var ErrUnknownSlot = stmt.ErrUnknownSlot + var ErrUnknownValue = expr.ErrUnknownValue + var ErrUnsupportedDialect = render.ErrUnsupportedDialect + var ErrZeroExpr = expr.ErrZeroExpr + var FrameModeValues = expr.FrameModeValues + var JoinTypeValues = stmt.JoinTypeValues + var NullsOrderValues = expr.NullsOrderValues + var OpValues = expr.OpValues + var SlotValues = stmt.SlotValues + var SortDirectionValues = expr.SortDirectionValues + func CheckedFunctionName(a *render.Args, name, what string) string + func CheckedKeyword(a *render.Args, s, what string) string + func CheckedOperator(a *render.Args, op, what string) string + func DialectName(d Dialect) string + func Each(ctx context.Context, db DBTX, q Query, fn func() error) error + func EngineGuard(a *Args, engine, construct string) bool + func EngineList(a *Args, items []SQLer) string + func EscapeLike(s string) string + func One(ctx context.Context, db DBTX, q Query) error + func PredicateSQL(p Predicate, a *render.Args) string + func Quote(s string, q byte) string + func QuoteList(d render.Dialect, names []string) string + func Row(items ...render.SQLer) render.SQLer + func Targets(bs []Binding) []any + type AggOption = expr.AggOption + func Distinct() AggOption + type AggSpec = expr.AggSpec + type AnyClause = stmt.AnyClause + type AnySelect = stmt.AnySelect + type Args = render.Args + func NewArgs(d Dialect) *Args + func NewInlineArgs(d Dialect) *Args + type Assignment = stmt.Assignment + func AssignTarget(col string, target func(a *Args) string, value SQLer) Assignment + func SetDefault[T any](col Expr[T]) Assignment + func SetExpr[T any](col Expr[T], e Expr[T]) Assignment + func Set[T any](col Expr[T], v T) Assignment + type Binding = stmt.Binding + func Bind[T any](e Expr[T], dst *T) Binding + func Bindings(groups ...[]Binding) []Binding + type CTE = stmt.CTE + type CaseBuilder = expr.CaseBuilder[T] + func Case[T any]() CaseBuilder[T] + type CaseInsensitiveLike = render.CaseInsensitiveLike + type Clause = stmt.Clause[D, K] + func EngineClause[D render.Dialect, K any](construct string, slot Slot, render func(a *Args) string) Clause[D, K] + type ClickHouseDialect = clickhouse.Dialect + type CombinedAlter = render.CombinedAlter + type DBTX = exec.DBTX + type Delete = stmt.Delete[D] + func NewDelete[D render.Dialect](d D) *Delete[D] + type DeleteKind = stmt.DeleteKind + type Dialect = render.Dialect + type Expr = expr.Expr[T] + func Add[T Number](l, r Expr[T]) Expr[T] + func Aggregate[R any](name string, args []render.SQLer, opts ...AggOption) Expr[R] + func As[T any](e Expr[T], name string) Expr[T] + func AssertNotNull[T any](e Expr[*T]) Expr[T] + func Avg[T Number](e Expr[T], opts ...AggOption) Expr[float64] + func Binary[R any](left render.SQLer, op string, right render.SQLer) Expr[R] + func BoolExpr(p Predicate) Expr[bool] + func Cast[R, T any](e Expr[T], sqlType string) Expr[R] + func Coalesce[T any](first Expr[T], rest ...Expr[T]) Expr[T] + func Col[T any](t Table, name string) Expr[T] + func Concat(parts ...Expr[string]) Expr[string] + func Count(opts ...AggOption) Expr[int64] + func CountOf[T any](e Expr[T], opts ...AggOption) Expr[int64] + func Div[T Number](l, r Expr[T]) Expr[T] + func EngineBinOp[R any](engine, construct, op string, l, r SQLer) Expr[R] + func EngineExpr[T any](engine, construct string, render func(a *Args) string) Expr[T] + func EngineFn[R any](engine, construct, name string, args ...SQLer) Expr[R] + func EngineLit[T any](engine, construct, sql string) Expr[T] + func Fn[R any](name string, args ...render.SQLer) Expr[R] + func Literal[T any](sql string) Expr[T] + func Lower(e Expr[string]) Expr[string] + func Max[T any](e Expr[T], opts ...AggOption) Expr[T] + func Min[T any](e Expr[T], opts ...AggOption) Expr[T] + func Mod[T Number](l, r Expr[T]) Expr[T] + func Mul[T Number](l, r Expr[T]) Expr[T] + func Neg[T Number](e Expr[T]) Expr[T] + func New[T any](render func(a *render.Args) string) Expr[T] + func NullIf[T any](l, r Expr[T]) Expr[*T] + func Nullable[T any](e Expr[T]) Expr[*T] + func OutputCol[T any](name string) Expr[T] + func OverNamed[T any](e Expr[T], name string) Expr[T] + func Over[T any](e Expr[T], w Window) Expr[T] + func Param[T any](v T) Expr[T] + func Sub[T Number](l, r Expr[T]) Expr[T] + func Subquery[T any, D render.Dialect](s *Select[D]) Expr[*T] + func Sum[T Number](e Expr[T], opts ...AggOption) Expr[T] + func Upper(e Expr[string]) Expr[string] + type FilteredDelete = stmt.FilteredDelete[D] + func DeleteReturning[D ReturningDialect](s *FilteredDelete[D], bs ...Binding) *FilteredDelete[D] + type FilteredUpdate = stmt.FilteredUpdate[D] + func UpdateReturning[D ReturningDialect](s *FilteredUpdate[D], bs ...Binding) *FilteredUpdate[D] + type FrameBound = expr.FrameBound + func CurrentRow() FrameBound + func Following(n int) FrameBound + func FollowingExpr(sql string) FrameBound + func Preceding(n int) FrameBound + func PrecedingExpr(sql string) FrameBound + func UnboundedFollowing() FrameBound + func UnboundedPreceding() FrameBound + type FrameExclude = expr.FrameExclude + type FrameMode = expr.FrameMode + type Guard = stmt.Guard + func NewGuard() Guard + type Insert = stmt.Insert[D] + func NewInsert[D render.Dialect](d D) *Insert[D] + type InsertAliasing = render.InsertAliasing + type InsertKind = stmt.InsertKind + type InsertReady = stmt.InsertReady[D] + func InsertReturning[D ReturningDialect](s *InsertReady[D], bs ...Binding) *InsertReady[D] + type Join = stmt.Join + type JoinType = stmt.JoinType + type LikeEscaping = render.LikeEscaping + type LiteralQuoting = render.LiteralQuoting + type MySQLDialect = mysql.Dialect + type Named = render.Named + type NullsOrder = expr.NullsOrder + type Number = expr.Number + type NumericParameters = render.NumericParameters + type Option = stmt.Option + func WithColumns(bs ...Binding) Option + func WithJoin(js ...Join) Option + func WithOrder(ts ...OrderTerm) Option + func WithWhere(ps ...Predicate) Option + type OrderTerm = expr.OrderTerm + func OrderBy[T any](e Expr[T], dir SortDirection) OrderTerm + type PostgresDialect = postgres.Dialect + type Predicate = expr.Predicate + func And(preds ...Predicate) Predicate + func Between[T any](e Expr[T], lo, hi T) Predicate + func Compare(left render.SQLer, op string, right render.SQLer) Predicate + func Contains(e Expr[string], value string) Predicate + func ContainsFold(e Expr[string], value string) Predicate + func EndsWith(e Expr[string], value string) Predicate + func EndsWithFold(e Expr[string], value string) Predicate + func EngineBinPred(engine, construct, op string, l, r SQLer) Predicate + func EnginePred(engine, construct string, render func(a *Args) string) Predicate + func EqExpr[T any](left, right Expr[T]) Predicate + func EqFold(e Expr[string], value string) Predicate + func Eq[T any](e Expr[T], v T) Predicate + func Exists[D render.Dialect](s *Select[D]) Predicate + func False() Predicate + func GreaterEqExpr[T any](left, right Expr[T]) Predicate + func GreaterEq[T any](e Expr[T], v T) Predicate + func GreaterExpr[T any](left, right Expr[T]) Predicate + func Greater[T any](e Expr[T], v T) Predicate + func InExprs[T any](e Expr[T], items ...Expr[T]) Predicate + func InFold(e Expr[string], values ...string) Predicate + func InSubquery[T any, D render.Dialect](e Expr[T], s *Select[D]) Predicate + func In[T any](e Expr[T], values ...T) Predicate + func IsNotNull[T any](e Expr[T]) Predicate + func IsNull[T any](e Expr[T]) Predicate + func LessEqExpr[T any](left, right Expr[T]) Predicate + func LessEq[T any](e Expr[T], v T) Predicate + func LessExpr[T any](left, right Expr[T]) Predicate + func Less[T any](e Expr[T], v T) Predicate + func Like(e Expr[string], pattern string) Predicate + func Not(p Predicate) Predicate + func NotBetween[T any](e Expr[T], lo, hi T) Predicate + func NotContains(e Expr[string], value string) Predicate + func NotEqExpr[T any](left, right Expr[T]) Predicate + func NotEq[T any](e Expr[T], v T) Predicate + func NotExists[D render.Dialect](s *Select[D]) Predicate + func NotInFold(e Expr[string], values ...string) Predicate + func NotInSubquery[T any, D render.Dialect](e Expr[T], s *Select[D]) Predicate + func NotIn[T any](e Expr[T], values ...T) Predicate + func NotLike(e Expr[string], pattern string) Predicate + func Or(preds ...Predicate) Predicate + func PredicateOf(render func(a *render.Args) string) Predicate + func RowEq(l, r render.SQLer) Predicate + func RowGreater(l, r render.SQLer) Predicate + func RowIn(row render.SQLer, rows ...render.SQLer) Predicate + func RowLess(l, r render.SQLer) Predicate + func RowNotIn(row render.SQLer, rows ...render.SQLer) Predicate + func StartsWith(e Expr[string], value string) Predicate + func StartsWithFold(e Expr[string], value string) Predicate + func SubqueryCompare[D render.Dialect](e SQLer, op, quantifier string, s *Select[D]) Predicate + func True() Predicate + type Query = stmt.Query + func NewGuardedQuery(g Guard, sql string, args, targets []any) Query + func NewQuery(sql string, args, targets []any) Query + type Returning = render.Returning + type ReturningDialect = stmt.ReturningDialect + type SQLer = render.SQLer + func EngineQuoteLit(s string) SQLer + func EngineRaw(engine, construct string, render func(a *Args) string) SQLer + func Raw(f func(a *Args) string) SQLer + type SQLiteDialect = sqlite.Dialect + type Select = stmt.Select[D] + func NewSelect[D render.Dialect](d D) *Select[D] + type SelectKind = stmt.SelectKind + type Slot = stmt.Slot + type SortDirection = expr.SortDirection + type Source = expr.Source + func Derived(body Statement, alias string) Source + func EngineSource(engine, construct, alias string, render func(a *Args) string) Source + func SourceOf(alias string, render func(a *render.Args) string) Source + type Statement = expr.Statement + type Table = expr.Table + func Ref(src Source) Table + type UnrestrictedAddColumn = render.UnrestrictedAddColumn + type UntypedParameters = render.UntypedParameters + type Update = stmt.Update[D] + func NewUpdate[D render.Dialect](d D) *Update[D] + type UpdateKind = stmt.UpdateKind + type WinFn = expr.WinFn[T] + func DenseRank() WinFn[int64] + func FirstValue[T any](e Expr[T]) WinFn[*T] + func LastValue[T any](e Expr[T]) WinFn[*T] + func NewWinFn[T any](render func(a *render.Args) string) WinFn[T] + func NthValue[T any](e Expr[T], n int) WinFn[*T] + func Rank() WinFn[int64] + func RowNumber() WinFn[int64] + type Window = expr.Window + func NewWindow() Window