Versions in this module Expand all Collapse all v0 v0.1.1 Oct 11, 2026 v0.1.0 Oct 11, 2026 Changes in this version + const ExcludeCurrentRow + const ExcludeGroup + const ExcludeNoOthers + const ExcludeTies + const FrameGroups + const JoinFull + var BoundsValues = []Bounds + var DateFieldValues = []DateField + var DeleteReturning = sqlb.DeleteReturning[Dialect] + var ErrBadCache = errors.New("sqlb/pg: a sequence cache must be at least 1") + var ErrCascadeNeedsDrop = errors.New("sqlb/pg: CASCADE follows DROP CONSTRAINT and no other domain action") + var ErrConflictTarget = errors.New("sqlb/pg: ON CONFLICT DO UPDATE needs conflict columns or a constraint") + var ErrConstraintAlterMix = errors.New("sqlb/pg: ALTER CONSTRAINT takes INHERIT or NO INHERIT alone") + var ErrEmptyBody = errors.New("sqlb/pg: a function needs a body") + var ErrEmptyName = errors.New("sqlb/pg: object has no name") + var ErrForeignDomain = errors.New("sqlb/pg: constraint belongs to another domain") + var ErrIncompleteMerge = errors.New("sqlb/pg: MERGE needs Into, Using, On and at least one WHEN branch") + var ErrIncompleteSpec = errors.New("sqlb/pg: a column, column list or JSON pair is missing a required part") + var ErrIndexSchema = errors.New("sqlb/pg: the index and its table are declared in different schemas") + var ErrMixedReferences = errors.New("sqlb/pg: a foreign key references one table") + var ErrNoBound = errors.New("sqlb/pg: a partition needs bounds or Default") + var ErrNoLockTables = errors.New("pg: LOCK TABLE names no table") + var ErrNoResult = errors.New("sqlb/pg: a function needs a result type or an output parameter") + var ErrNoTables = errors.New("pg: TRUNCATE names no table") + var ErrNotBits = errors.New("sqlb/pg: a bit literal holds only the digits 0 and 1") + var ErrRecursiveColumns = errors.New("sqlb/pg: a recursive view needs a column list") + var ErrRenameAcrossTables = errors.New("sqlb/pg: RenameConstraint names constraints of two tables") + var ErrRenameAlone = errors.New("sqlb/pg: a sequence rename takes no other option") + var ErrRenamePolicyAlone = errors.New("sqlb/pg: a policy rename takes no other change") + var ErrSingleExpression = errors.New(...) + var ErrTriggerSignature = errors.New("sqlb/pg: a trigger function declares no parameters") + var ErrUnknownKeyword = errors.New("sqlb/pg: value outside its named constants") + var ErrUnknownValue = errors.New("sqlb/pg: value is not one of this type's constants") + var ErrUnnamedConstraint = errors.New("sqlb/pg: a guarded constraint needs a name") + var InsertReturning = sqlb.InsertReturning[Dialect] + var JSONBOps = NewOpClass[json.RawMessage]("jsonb_ops") + var JSONBPathOps = NewOpClass[json.RawMessage]("jsonb_path_ops") + var JSONKindValues = []JSONKind + var NormalFormValues = []NormalForm + var SampleMethodValues = []SampleMethod + var TableLockModeValues = []TableLockMode + var TrimSideValues = []TrimSide + var UpdateReturning = sqlb.UpdateReturning[Dialect] + var WeightValues = []Weight + func Abs[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func AddInterval(e sqlb.Expr[time.Time], iv Interval) sqlb.Expr[time.Time] + func AddIntervalExpr(e sqlb.Expr[time.Time], iv sqlb.Expr[Interval]) sqlb.Expr[time.Time] + func Adjacent[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func AdvisoryXactLock(key sqlb.SQLer) sqlb.Expr[[]byte] + func AdvisoryXactLock2(namespace int32, key sqlb.SQLer) sqlb.Expr[[]byte] + func Age(l, r sqlb.Expr[time.Time]) sqlb.Expr[Interval] + func AllExpr[T any](left sqlb.Expr[T], op CompareOp, arr sqlb.Expr[[]T]) sqlb.Predicate + func AllOf[T any](e sqlb.Expr[T], op string, s *sqlb.Select[Dialect]) sqlb.Predicate + func AllOp[T any](col sqlb.Expr[[]T], op string, v T) sqlb.Predicate + func AnyExpr[T any](left sqlb.Expr[T], op CompareOp, arr sqlb.Expr[[]T]) sqlb.Predicate + func AnyOf[T any](e sqlb.Expr[T], op string, s *sqlb.Select[Dialect]) sqlb.Predicate + func AnyOp[T any](col sqlb.Expr[[]T], op string, v T) sqlb.Predicate + func Any[T any](col sqlb.Expr[[]T], v T) sqlb.Predicate + func ArrayAgg[T any](e sqlb.Expr[T], opts ...sqlb.AggOption) sqlb.Expr[[]T] + func ArrayAppend[T any](col sqlb.Expr[[]T], v T) sqlb.Expr[[]T] + func ArrayCat[T any](l, r sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArrayConcat[T any](l, r sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArrayContainedByExpr[T any](l, r sqlb.Expr[[]T]) sqlb.Predicate + func ArrayContainedBy[T any](col sqlb.Expr[[]T], v []T) sqlb.Predicate + func ArrayContainsExpr[T any](l, r sqlb.Expr[[]T]) sqlb.Predicate + func ArrayContains[T any](col sqlb.Expr[[]T], v []T) sqlb.Predicate + func ArrayDims[T any](col sqlb.Expr[[]T]) sqlb.Expr[*string] + func ArrayElements(col sqlb.Expr[json.RawMessage], alias string) (sqlb.Source, sqlb.Expr[json.RawMessage]) + func ArrayElementsScalar(doc sqlb.SQLer) sqlb.Expr[json.RawMessage] + func ArrayElementsText(col sqlb.Expr[json.RawMessage], alias string) (sqlb.Source, sqlb.Expr[string]) + func ArrayLength[T any](col sqlb.Expr[[]T], dim int) sqlb.Expr[*int32] + func ArrayLit[T any](text, sqlType string) sqlb.Expr[[]T] + func ArrayLower[T any](col sqlb.Expr[[]T], dim int) sqlb.Expr[*int32] + func ArrayNDims[T any](col sqlb.Expr[[]T]) sqlb.Expr[*int32] + func ArrayOf[T any](items ...sqlb.Expr[T]) sqlb.Expr[[]T] + func ArrayPosition[T any](col sqlb.Expr[[]T], v T) sqlb.Expr[*int32] + func ArrayPositions[T any](col sqlb.Expr[[]T], v T) sqlb.Expr[[]int32] + func ArrayPrepend[T any](v T, col sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArrayRemoveNull[T any](col sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArrayRemove[T any](col sqlb.Expr[[]T], v T) sqlb.Expr[[]T] + func ArrayReplace[T any](col sqlb.Expr[[]T], from, to T) sqlb.Expr[[]T] + func ArrayReverse[T any](col sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArraySample[T any](col sqlb.Expr[[]T], n int) sqlb.Expr[[]T] + func ArrayShuffle[T any](col sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArraySortDesc[T any](col sqlb.Expr[[]T], descending bool) sqlb.Expr[[]T] + func ArraySort[T any](col sqlb.Expr[[]T]) sqlb.Expr[[]T] + func ArraySubquery[T any](s *sqlb.Select[Dialect]) sqlb.Expr[[]T] + func ArrayToString[T any](col sqlb.Expr[[]T], sep string) sqlb.Expr[string] + func ArrayUpper[T any](col sqlb.Expr[[]T], dim int) sqlb.Expr[*int32] + func Array[T any](vals ...T) sqlb.Expr[[]T] + func Asin[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func AtTimeZone(e sqlb.Expr[time.Time], zone string) sqlb.Expr[time.Time] + func BackendPID() sqlb.Expr[int32] + func BinOp[R any](construct, op string, l, r sqlb.SQLer) sqlb.Expr[R] + func BinPred(construct, op string, l, r sqlb.SQLer) sqlb.Predicate + func BitAnd[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func BitCount(e sqlb.Expr[BitString]) sqlb.Expr[int64] + func BitLit(bits string) sqlb.Expr[BitString] + func BitNot[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func BitOr[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func BitStringOr(l, r sqlb.Expr[BitString]) sqlb.Expr[BitString] + func BitXor[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func BlockingPids(pid sqlb.SQLer) sqlb.Expr[[]int32] + func BoolAnd(e sqlb.Expr[bool], opts ...sqlb.AggOption) sqlb.Expr[bool] + func BoolOr(e sqlb.Expr[bool], opts ...sqlb.AggOption) sqlb.Expr[bool] + func Both(first, second sqlb.SQLer) sqlb.SQLer + func BuildArray(items ...sqlb.SQLer) sqlb.Expr[json.RawMessage] + func BuildObject(pairs ...sqlb.SQLer) sqlb.Expr[json.RawMessage] + func CancelBackend(pid sqlb.SQLer) sqlb.Expr[bool] + func Cardinality[T any](col sqlb.Expr[[]T]) sqlb.Expr[int32] + func Ceil[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func ClauseIn[K any](slot sqlb.Slot, construct string, render func(a *sqlb.Args) string) sqlb.Clause[Dialect, K] + func ClockTimestamp() sqlb.Expr[time.Time] + func Collate(e sqlb.Expr[string], collation string) sqlb.Expr[string] + func ColumnCollate[T collatable](col sqlb.Expr[T], collation string) ddl.ColumnClause[Dialect] + func ColumnCollation[T collatable](col sqlb.Expr[T], c Collation) ddl.ColumnClause[Dialect] + func ColumnCompression[T any](col sqlb.Expr[T], method string) ddl.ColumnClause[Dialect] + func ColumnSize(e sqlb.SQLer) sqlb.Expr[int32] + func ColumnStorage[T any](col sqlb.Expr[T], s TypeStorage) ddl.ColumnClause[Dialect] + func ConcatOp(l, r sqlb.Expr[string]) sqlb.Expr[string] + func ConcatWs(sep string, parts ...sqlb.SQLer) sqlb.Expr[string] + func ContainedBy(col sqlb.Expr[json.RawMessage], v json.RawMessage) sqlb.Predicate + func Contains(col sqlb.Expr[json.RawMessage], v json.RawMessage) sqlb.Predicate + func Cos[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func Cube(items ...sqlb.SQLer) sqlb.SQLer + func CumeDist() sqlb.WinFn[float64] + func CurrentDatabase() sqlb.Expr[string] + func CurrentDate() sqlb.Expr[time.Time] + func CurrentSetting(name string) sqlb.Expr[*string] + func CurrentUser() sqlb.Expr[string] + func CurrentWalLsn() sqlb.Expr[string] + func CurrentXactID() sqlb.Expr[int64] + func CurrentXactIDIfAssigned() sqlb.Expr[*int64] + func Cycle(flagCol, pathCol string, cols ...string) sqlb.SQLer + func DateBin(stride Interval, e sqlb.Expr[time.Time], origin time.Time) sqlb.Expr[time.Time] + func DateLit(s string) sqlb.Expr[time.Time] + func DateMinusDays(d sqlb.Expr[time.Time], days sqlb.SQLer) sqlb.Expr[time.Time] + func DatePlusDays(d sqlb.Expr[time.Time], days sqlb.SQLer) sqlb.Expr[time.Time] + func DateRange(lo, hi sqlb.SQLer, bounds Bounds) sqlb.Expr[Range[time.Time]] + func DateTrunc(field DateField, e sqlb.Expr[time.Time]) sqlb.Expr[time.Time] + func DateTruncZone(field DateField, e sqlb.Expr[time.Time], zone string) sqlb.Expr[time.Time] + func DaysBetween(l, r sqlb.Expr[time.Time]) sqlb.Expr[int32] + func DeleteKey(col sqlb.Expr[json.RawMessage], key string) sqlb.Expr[json.RawMessage] + func DeletePath(col sqlb.Expr[json.RawMessage], path []string) sqlb.Expr[json.RawMessage] + func Diff(l, r sqlb.Expr[time.Time]) sqlb.Expr[Interval] + func DivExact[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[float64] + func Div[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func DomainValue[T any]() sqlb.Expr[T] + func Each(col sqlb.Expr[json.RawMessage], alias string) (sqlb.Source, sqlb.Expr[string], sqlb.Expr[json.RawMessage]) + func EmptyArray[T any](sqlType string) sqlb.Expr[[]T] + func EmptyJSONArray() sqlb.Expr[json.RawMessage] + func EmptyJSONObject() sqlb.Expr[json.RawMessage] + func Encode(e sqlb.Expr[[]byte], format string) sqlb.Expr[string] + func EpochSeconds(e sqlb.Expr[float64]) sqlb.Expr[time.Time] + func ExceptAll(s, other *sqlb.Select[Dialect]) *sqlb.Select[Dialect] + func Excluded[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func Exp[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func ExportSnapshot() sqlb.Expr[string] + func Expr[T any](construct string, render func(a *sqlb.Args) string) sqlb.Expr[T] + func Extract(field DateField, e sqlb.Expr[time.Time]) sqlb.Expr[float64] + func ExtractFrom(field DateField, e sqlb.SQLer) sqlb.Expr[float64] + func Filter(p sqlb.Predicate) sqlb.AggOption + func Floor[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func Format(format string, args ...sqlb.SQLer) sqlb.Expr[string] + func FormatType(typid, typmod sqlb.SQLer) sqlb.Expr[string] + func FuncSource(call sqlb.SQLer, alias string, columns ...string) sqlb.Source + func Func[R any](construct, name string, args ...sqlb.SQLer) sqlb.Expr[R] + func GCD[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func GenRandomUUID() sqlb.Expr[string] + func GenerateSeries(from, to, step int64, alias string) (sqlb.Source, sqlb.Expr[int64]) + func GenerateSeriesExpr(from, to sqlb.SQLer, step sqlb.Expr[Interval], alias string) (sqlb.Source, sqlb.Expr[time.Time]) + func GenerateSeriesScalar(from, to sqlb.SQLer) sqlb.Expr[int64] + func GenerateSeriesTime(from, to time.Time, step string, alias string) (sqlb.Source, sqlb.Expr[time.Time]) + func GenerateSubscripts[T any](col sqlb.Expr[[]T], dim int, alias string) (sqlb.Source, sqlb.Expr[int32]) + func GeneratedStored[T any](col, e sqlb.Expr[T]) ddl.ColumnClause[Dialect] + func GeneratedVirtual[T any](col, e sqlb.Expr[T]) ddl.ColumnClause[Dialect] + func Get(col sqlb.Expr[json.RawMessage], key string) sqlb.Expr[json.RawMessage] + func GetBit(e sqlb.Expr[BitString], n int) sqlb.Expr[int32] + func GetIndex(col sqlb.Expr[json.RawMessage], n int) sqlb.Expr[json.RawMessage] + func GetSerialSequence(table, column string) sqlb.Expr[string] + func Greatest[T any](first sqlb.Expr[T], rest ...sqlb.Expr[T]) sqlb.Expr[T] + func Grouping(items ...sqlb.SQLer) sqlb.Expr[int32] + func GroupingSets(sets ...[]sqlb.SQLer) sqlb.SQLer + func Guard(a *sqlb.Args, construct string) bool + func HasAllKeys(col sqlb.Expr[json.RawMessage], keys []string) sqlb.Predicate + func HasAnyKey(col sqlb.Expr[json.RawMessage], keys []string) sqlb.Predicate + func HasKey(col sqlb.Expr[json.RawMessage], key string) sqlb.Predicate + func HasRole(user sqlb.SQLer, role, privilege string) sqlb.Expr[bool] + func Hashtext(e sqlb.Expr[string]) sqlb.Expr[int32] + func ILike(e sqlb.Expr[string], pattern string) sqlb.Predicate + func Identity[T identityInteger](col sqlb.Expr[T], k IdentityKind) ddl.ColumnClause[Dialect] + func InArray[T any](col sqlb.Expr[T], vals []T) sqlb.Predicate + func IndexesSize(oid sqlb.SQLer) sqlb.Expr[int64] + func Infinity() sqlb.Expr[time.Time] + func Initcap(e sqlb.Expr[string]) sqlb.Expr[string] + func InputIsValid(value, sqlType string) sqlb.Expr[bool] + func Int4Range(lo, hi int32, bounds Bounds) sqlb.Expr[Range[int32]] + func Int8Range(from, to int64, bounds Bounds) sqlb.Expr[Range[int64]] + func IntersectAll(s, other *sqlb.Select[Dialect]) *sqlb.Select[Dialect] + func IntervalLit(text string) sqlb.Expr[Interval] + func IntervalMul(iv sqlb.Expr[Interval], n sqlb.SQLer) sqlb.Expr[Interval] + func Is(d sqlb.Dialect) bool + func IsDistinctFrom[T any](l, r sqlb.Expr[T]) sqlb.Predicate + func IsEmpty[T any](r sqlb.Expr[Range[T]]) sqlb.Predicate + func IsFalse(e sqlb.Expr[bool]) sqlb.Predicate + func IsJSON(e sqlb.SQLer, kind JSONKind, uniqueKeys bool) sqlb.Predicate + func IsNotDistinctFrom[T any](l, r sqlb.Expr[T]) sqlb.Predicate + func IsTrue(e sqlb.Expr[bool]) sqlb.Predicate + func IsUnknown(e sqlb.Expr[bool]) sqlb.Predicate + func JSONAgg(e sqlb.SQLer, opts ...sqlb.AggOption) sqlb.Expr[json.RawMessage] + func JSONArrayAgg(e sqlb.SQLer, opts ...JSONOption) sqlb.Expr[json.RawMessage] + func JSONBAgg(e sqlb.SQLer, opts ...sqlb.AggOption) sqlb.Expr[json.RawMessage] + func JSONBArrayLength(e sqlb.Expr[json.RawMessage]) sqlb.Expr[int32] + func JSONBInsert(col sqlb.Expr[json.RawMessage], path []string, value json.RawMessage) sqlb.Expr[json.RawMessage] + func JSONBObjectAgg(key, value sqlb.SQLer, opts ...sqlb.AggOption) sqlb.Expr[json.RawMessage] + func JSONBSet(col sqlb.Expr[json.RawMessage], path []string, value json.RawMessage, ...) sqlb.Expr[json.RawMessage] + func JSONBSetExpr(col sqlb.SQLer, path []string, value sqlb.SQLer, createMissing bool) sqlb.Expr[json.RawMessage] + func JSONBSetLax(col sqlb.SQLer, path []string, value sqlb.SQLer, createMissing bool, ...) sqlb.Expr[json.RawMessage] + func JSONBTypeof(e sqlb.Expr[json.RawMessage]) sqlb.Expr[string] + func JSONConcat(l, r sqlb.Expr[json.RawMessage]) sqlb.Expr[json.RawMessage] + func JSONExists(doc sqlb.SQLer, path string) sqlb.Predicate + func JSONNull() sqlb.Expr[json.RawMessage] + func JSONObject(pairs []JSONPair, opts ...JSONOption) sqlb.Expr[json.RawMessage] + func JSONObjectAgg(key, value sqlb.SQLer, opts ...JSONOption) sqlb.Expr[json.RawMessage] + func JSONQuery(doc sqlb.SQLer, path string, opts ...JSONValueOption) sqlb.Expr[json.RawMessage] + func JSONSubscript(doc sqlb.Expr[json.RawMessage], keys ...string) sqlb.Expr[json.RawMessage] + func JSONTable(doc sqlb.SQLer, path string, alias string, cols ...JSONTableColumn) sqlb.Source + func JSONText(col sqlb.Expr[json.RawMessage], key string) sqlb.Expr[string] + func JSONValue[R any](doc sqlb.SQLer, path string, opts ...JSONValueOption) sqlb.Expr[R] + func JustifyInterval(iv sqlb.Expr[Interval]) sqlb.Expr[Interval] + func Key(k string) sqlb.SQLer + func LPad(e sqlb.Expr[string], n int, fill string) sqlb.Expr[string] + func LTrim(e sqlb.Expr[string]) sqlb.Expr[string] + func LagDefault[T any](e sqlb.Expr[T], offset int, def sqlb.Expr[T]) sqlb.WinFn[T] + func Lag[T any](e sqlb.Expr[T], offset int) sqlb.WinFn[*T] + func LastXactReplayTimestamp() sqlb.Expr[time.Time] + func Lateral(src sqlb.Source) sqlb.Source + func LeadDefault[T any](e sqlb.Expr[T], offset int, def sqlb.Expr[T]) sqlb.WinFn[T] + func Lead[T any](e sqlb.Expr[T], offset int) sqlb.WinFn[*T] + func Least[T any](first sqlb.Expr[T], rest ...sqlb.Expr[T]) sqlb.Expr[T] + func Left(e sqlb.Expr[string], n int) sqlb.Expr[string] + func Length(e sqlb.Expr[string]) sqlb.Expr[int32] + func LikeEscape(e sqlb.Expr[string], pattern, escape string) sqlb.Predicate + func List(a *sqlb.Args, items []sqlb.SQLer) string + func Ln[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func Log10[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func LowerBound[T any](r sqlb.Expr[Range[T]]) sqlb.Expr[*T] + func LowerInc[T any](r sqlb.Expr[Range[T]]) sqlb.Expr[bool] + func LowerInf[T any](r sqlb.Expr[Range[T]]) sqlb.Predicate + func MD5(e sqlb.Expr[string]) sqlb.Expr[string] + func MakeInterval(days, hours int) sqlb.Expr[Interval] + func Matches(v sqlb.Expr[TSVector], q sqlb.Expr[TSQuery]) sqlb.Predicate + func Materialized(on bool) sqlb.SQLer + func MergeAction() sqlb.Expr[string] + func ModFn[T sqlb.Number](l, r sqlb.Expr[T]) sqlb.Expr[T] + func Mode[T any](e sqlb.Expr[T]) sqlb.Expr[T] + func MultirangeDiff[T any](a, b sqlb.Expr[Multirange[T]]) sqlb.Expr[Multirange[T]] + func Named(name string, value sqlb.SQLer) sqlb.SQLer + func New[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func NextVal[T sequenceInteger](s Sequence[T]) sqlb.Expr[T] + func Nextval(sequence string) sqlb.Expr[int64] + func Normalize(e sqlb.Expr[string], form NormalForm) sqlb.Expr[string] + func NotILike(e sqlb.Expr[string], pattern string) sqlb.Predicate + func NotRegex(e sqlb.Expr[string], pattern string) sqlb.Predicate + func NotRegexI(e sqlb.Expr[string], pattern string) sqlb.Predicate + func Now() sqlb.Expr[time.Time] + func Ntile(n int) sqlb.WinFn[int32] + func NullBound() sqlb.SQLer + func NumNonnulls(items ...sqlb.SQLer) sqlb.Expr[int32] + func NumRange(lo, hi sqlb.SQLer, bounds Bounds) sqlb.Expr[Range[float64]] + func ObjectKeys(col sqlb.Expr[json.RawMessage], alias string) (sqlb.Source, sqlb.Expr[string]) + func OctetLength(e sqlb.Expr[string]) sqlb.Expr[int32] + func Old[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func OrderByNulls[T any](e sqlb.Expr[T], dir sqlb.SortDirection, first bool) sqlb.OrderTerm + func OrderUsing[T any](e sqlb.Expr[T], op string) sqlb.OrderTerm + func OrderWithin(ts ...sqlb.OrderTerm) sqlb.AggOption + func OverlapsExpr[T any](l, r sqlb.Expr[[]T]) sqlb.Predicate + func OverlapsInterval(s1 sqlb.Expr[time.Time], i1 sqlb.Expr[Interval], s2 sqlb.Expr[time.Time], ...) sqlb.Predicate + func OverlapsPeriod(s1, e1, s2, e2 sqlb.Expr[time.Time]) sqlb.Predicate + func Overlaps[T any](col sqlb.Expr[[]T], v []T) sqlb.Predicate + func PathExists(col sqlb.Expr[json.RawMessage], jsonpath string) sqlb.Predicate + func PathGet(col sqlb.Expr[json.RawMessage], path []string) sqlb.Expr[json.RawMessage] + func PathMatch(col sqlb.Expr[json.RawMessage], jsonpath string) sqlb.Predicate + func PathQuery(col sqlb.Expr[json.RawMessage], jsonpath string, alias string) (sqlb.Source, sqlb.Expr[json.RawMessage]) + func PathQueryArray(doc sqlb.SQLer, path string) sqlb.Expr[json.RawMessage] + func PathQueryFirst(col sqlb.Expr[json.RawMessage], jsonpath string) sqlb.Expr[json.RawMessage] + func PathQueryScalar(doc sqlb.SQLer, path string) sqlb.Expr[json.RawMessage] + func PathQueryVars(col sqlb.SQLer, jsonpath string, vars []byte, alias string) (sqlb.Source, sqlb.Expr[[]byte]) + func PathText(col sqlb.Expr[json.RawMessage], path []string) sqlb.Expr[string] + func PercentRank() sqlb.WinFn[float64] + func PercentileCont(fraction float64, order sqlb.OrderTerm) sqlb.Expr[float64] + func PercentileDisc[T any](fraction float64, e sqlb.Expr[T], dir sqlb.SortDirection) sqlb.Expr[T] + func PhraseToTSQuery(config, text string) sqlb.Expr[TSQuery] + func PlainToTSQuery(config, text string) sqlb.Expr[TSQuery] + func Position(e sqlb.Expr[string], needle string) sqlb.Expr[int32] + func PowerExpr[T sqlb.Number](base sqlb.Expr[T], exp sqlb.SQLer) sqlb.Expr[float64] + func PowerOp[T sqlb.Number](base sqlb.Expr[T], exp sqlb.SQLer) sqlb.Expr[float64] + func Power[T sqlb.Number](base sqlb.Expr[T], exp float64) sqlb.Expr[float64] + func Pred(construct string, render func(a *sqlb.Args) string) sqlb.Predicate + func Pretty(e sqlb.Expr[json.RawMessage]) sqlb.Expr[string] + func QuoteIdent(e sqlb.Expr[string]) sqlb.Expr[string] + func QuoteLit(s string) sqlb.SQLer + func QuoteLiteral(e sqlb.Expr[string]) sqlb.Expr[string] + func RPad(e sqlb.Expr[string], n int, fill string) sqlb.Expr[string] + func RTrim(e sqlb.Expr[string]) sqlb.Expr[string] + func Radians[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func Random() sqlb.Expr[float64] + func RandomNormal(mean, stddev float64) sqlb.Expr[float64] + func RangeAggTyped[T any](r sqlb.Expr[Range[T]], opts ...sqlb.AggOption) sqlb.Expr[Multirange[T]] + func RangeAgg[T any](r sqlb.Expr[Range[T]], opts ...sqlb.AggOption) sqlb.Expr[string] + func RangeContainedBy[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func RangeContainsRange[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func RangeContains[T any](r sqlb.Expr[Range[T]], v T) sqlb.Predicate + func RangeDiff[T any](l, r sqlb.Expr[Range[T]]) sqlb.Expr[Range[T]] + func RangeExpr[T any](constructor string, lo, hi sqlb.SQLer, bounds Bounds) sqlb.Expr[Range[T]] + func RangeIntersectAgg[T any](r sqlb.Expr[Range[T]], opts ...sqlb.AggOption) sqlb.Expr[Range[T]] + func RangeIntersect[T any](l, r sqlb.Expr[Range[T]]) sqlb.Expr[Range[T]] + func RangeMerge[T any](l, r sqlb.Expr[Range[T]]) sqlb.Expr[Range[T]] + func RangeOverlaps[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func RangeUnion[T any](l, r sqlb.Expr[Range[T]]) sqlb.Expr[Range[T]] + func RecordSet(call sqlb.SQLer, alias string, cols ...ColumnDef) sqlb.Source + func Regclass(name string) sqlb.Expr[int64] + func Regex(e sqlb.Expr[string], pattern string) sqlb.Predicate + func RegexI(e sqlb.Expr[string], pattern string) sqlb.Predicate + func RegexpCount(e sqlb.Expr[string], pattern string) sqlb.Expr[int32] + func RegexpInstr(e sqlb.Expr[string], pattern string) sqlb.Expr[int32] + func RegexpMatch(e sqlb.Expr[string], pattern string) sqlb.Expr[[]string] + func RegexpReplace(e sqlb.Expr[string], pattern, replacement, flags string) sqlb.Expr[string] + func RegexpSplitToArray(e sqlb.Expr[string], pattern string) sqlb.Expr[[]string] + func RegexpSplitToTable(e sqlb.Expr[string], pattern string, alias string) (sqlb.Source, sqlb.Expr[string]) + func RegexpSubstr(e sqlb.Expr[string], pattern string) sqlb.Expr[*string] + func RelationSize(oid sqlb.SQLer) sqlb.Expr[int64] + func Repeat(e sqlb.Expr[string], n int) sqlb.Expr[string] + func RepeatExpr(e sqlb.Expr[string], n sqlb.SQLer) sqlb.Expr[string] + func Replace(e sqlb.Expr[string], from, to string) sqlb.Expr[string] + func Reverse(e sqlb.Expr[string]) sqlb.Expr[string] + func Right(e sqlb.Expr[string], n int) sqlb.Expr[string] + func Rollup(items ...sqlb.SQLer) sqlb.SQLer + func RoundHalf[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func Round[T sqlb.Number](e sqlb.Expr[T], places int) sqlb.Expr[float64] + func RowRef(t sqlb.Table) sqlb.SQLer + func RowToJSON(t sqlb.Table) sqlb.Expr[json.RawMessage] + func RowsFrom(alias string, calls []sqlb.SQLer, ordinality bool, columns ...string) sqlb.Source + func SHA256Hex(e sqlb.Expr[string]) sqlb.Expr[string] + func SearchBreadthFirst(setCol string, by ...string) sqlb.SQLer + func SearchDepthFirst(setCol string, by ...string) sqlb.SQLer + func SetConfig(name, value string, local bool) sqlb.Expr[string] + func SetLocal(name, value string) sqlb.Expr[string] + func SetSubscript(col sqlb.Expr[json.RawMessage], keys []string, value sqlb.SQLer) sqlb.Assignment + func SetWeight(v sqlb.Expr[TSVector], w Weight) sqlb.Expr[TSVector] + func Setseed(seed float64) sqlb.Expr[[]byte] + func Setval(sequence sqlb.SQLer, value sqlb.SQLer) sqlb.Expr[int64] + func ShiftLeft[T sqlb.Number](e sqlb.Expr[T], n int) sqlb.Expr[T] + func ShiftRight[T sqlb.Number](e sqlb.Expr[T], n int) sqlb.Expr[T] + func Sign[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func SimilarTo(e sqlb.Expr[string], pattern string) sqlb.Predicate + func Sin[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func SizePretty(bytes sqlb.SQLer) sqlb.Expr[string] + func SliceExprs[T any](col sqlb.Expr[[]T], lo, hi sqlb.SQLer) sqlb.Expr[[]T] + func SliceFrom[T any](col sqlb.Expr[[]T], lo int) sqlb.Expr[[]T] + func SliceTo[T any](col sqlb.Expr[[]T], hi int) sqlb.Expr[[]T] + func Slice[T any](col sqlb.Expr[[]T], lo, hi int) sqlb.Expr[[]T] + func SplitPart(e sqlb.Expr[string], sep string, n int) sqlb.Expr[string] + func Sqrt[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[float64] + func StartsWith(e sqlb.Expr[string], prefix string) sqlb.Predicate + func StatementTimestamp() sqlb.Expr[time.Time] + func Stddev[T sqlb.Number](e sqlb.Expr[T], opts ...sqlb.AggOption) sqlb.Expr[float64] + func StrictlyLeft[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func StrictlyRight[T any](l, r sqlb.Expr[Range[T]]) sqlb.Predicate + func StringAgg(e sqlb.Expr[string], sep string, opts ...sqlb.AggOption) sqlb.Expr[string] + func StringToArray(e sqlb.Expr[string], sep string) sqlb.Expr[[]string] + func StringToArrayNull(e sqlb.Expr[string], sep, nullStr string) sqlb.Expr[[]*string] + func StringToTable(e sqlb.Expr[string], sep string, alias string) (sqlb.Source, sqlb.Expr[string]) + func Strip(v sqlb.Expr[TSVector]) sqlb.Expr[TSVector] + func StripNulls(e sqlb.Expr[json.RawMessage]) sqlb.Expr[json.RawMessage] + func SubInterval(e sqlb.Expr[time.Time], iv Interval) sqlb.Expr[time.Time] + func SubIntervalExpr(e sqlb.Expr[time.Time], iv sqlb.Expr[Interval]) sqlb.Expr[time.Time] + func SubscriptExpr[T any](col sqlb.Expr[[]T], index sqlb.SQLer) sqlb.Expr[*T] + func Subscript[T any](col sqlb.Expr[[]T], n int) sqlb.Expr[*T] + func SubstrExpr(e sqlb.Expr[string], from, count sqlb.SQLer) sqlb.Expr[string] + func Substring(e sqlb.Expr[string], from, count int) sqlb.Expr[string] + func SubstringRegex(e sqlb.Expr[string], pattern string) sqlb.Expr[*string] + func TSAnd(l, r sqlb.Expr[TSQuery]) sqlb.Expr[TSQuery] + func TSFollowedBy(l, r sqlb.Expr[TSQuery]) sqlb.Expr[TSQuery] + func TSHeadline(config string, text sqlb.Expr[string], q sqlb.Expr[TSQuery], options string) sqlb.Expr[string] + func TSNot(q sqlb.Expr[TSQuery]) sqlb.Expr[TSQuery] + func TSOr(l, r sqlb.Expr[TSQuery]) sqlb.Expr[TSQuery] + func TSRank(v sqlb.Expr[TSVector], q sqlb.Expr[TSQuery]) sqlb.Expr[float32] + func TSRankCD(v sqlb.Expr[TSVector], q sqlb.Expr[TSQuery]) sqlb.Expr[float32] + func TSRankCDNormalized(v sqlb.Expr[TSVector], q sqlb.Expr[TSQuery], normalization int) sqlb.Expr[float32] + func TSVectorConcat(l, r sqlb.Expr[TSVector]) sqlb.Expr[TSVector] + func TerminateBackend(pid sqlb.SQLer) sqlb.Expr[bool] + func TimestampLit(s string) sqlb.Expr[time.Time] + func TimestamptzLit(s string) sqlb.Expr[time.Time] + func ToChar(e sqlb.SQLer, format string) sqlb.Expr[string] + func ToDate(e sqlb.Expr[string], format string) sqlb.Expr[time.Time] + func ToJSONB(e sqlb.SQLer) sqlb.Expr[json.RawMessage] + func ToTSQuery(config, text string) sqlb.Expr[TSQuery] + func ToTSVector(config string, e sqlb.Expr[string]) sqlb.Expr[TSVector] + func ToTimestamp(e sqlb.Expr[string], format string) sqlb.Expr[time.Time] + func TotalRelationSize(oid sqlb.SQLer) sqlb.Expr[int64] + func Trim(e sqlb.Expr[string]) sqlb.Expr[string] + func TrimArray[T any](col sqlb.Expr[[]T], n int) sqlb.Expr[[]T] + func TrimChars(side TrimSide, chars string, e sqlb.Expr[string]) sqlb.Expr[string] + func TruncZero[T sqlb.Number](e sqlb.Expr[T]) sqlb.Expr[T] + func Trunc[T sqlb.Number](e sqlb.Expr[T], places int) sqlb.Expr[float64] + func TryAdvisoryXactLock(key sqlb.SQLer) sqlb.Expr[bool] + func TstzMultirange(r sqlb.Expr[Range[time.Time]]) sqlb.Expr[Multirange[time.Time]] + func TstzRange(from, to time.Time, bounds Bounds) sqlb.Expr[Range[time.Time]] + func TstzRangeExpr(lo, hi sqlb.SQLer, bounds Bounds) sqlb.Expr[Range[time.Time]] + func TxidCurrent() sqlb.Expr[int64] + func UUIDv7Timestamp(u sqlb.Expr[string]) sqlb.Expr[time.Time] + func UnnestMulti(alias string, arrays []sqlb.SQLer, ordinality bool, columns ...string) sqlb.Source + func UnnestMultirange[T any](m sqlb.Expr[Multirange[T]]) sqlb.Expr[Range[T]] + func UnnestOrdinal[T any](col sqlb.Expr[[]T], alias string) (sqlb.Source, sqlb.Expr[T], sqlb.Expr[int64]) + func UnnestScalar[T any](arr sqlb.Expr[[]T]) sqlb.Expr[T] + func Unnest[T any](col sqlb.Expr[[]T], alias string) (sqlb.Source, sqlb.Expr[T]) + func Upper(e sqlb.Expr[string]) sqlb.Expr[string] + func UpperBound[T any](r sqlb.Expr[Range[T]]) sqlb.Expr[*T] + func UpperInc[T any](r sqlb.Expr[Range[T]]) sqlb.Expr[bool] + func UpperInf[T any](r sqlb.Expr[Range[T]]) sqlb.Predicate + func Values(alias string, columns []string, rows ...[]sqlb.SQLer) sqlb.Source + func Variadic(arr sqlb.SQLer) sqlb.SQLer + func Variance[T sqlb.Number](e sqlb.Expr[T], opts ...sqlb.AggOption) sqlb.Expr[float64] + func Version() sqlb.Expr[string] + func WalLsnDiff(a, b sqlb.SQLer) sqlb.Expr[int64] + func WebsearchToTSQuery(config, text string) sqlb.Expr[TSQuery] + func WidthBucketThresholds[T sqlb.Number](e sqlb.Expr[T], thresholds []T) sqlb.Expr[int32] + func WidthBucket[T sqlb.Number](e sqlb.Expr[T], lo, hi T, count int) sqlb.Expr[int32] + func WithOrdinality(src sqlb.Source) sqlb.Source + func WithinGroup[R any](name string, args []sqlb.SQLer, order ...sqlb.OrderTerm) sqlb.Expr[R] + func XidAge(xid sqlb.SQLer) sqlb.Expr[int64] + type AccessMethod string + const Heap + type AddValueStatement struct + func (x *AddValueStatement[T]) After(v T) *AddValueStatement[T] + func (x *AddValueStatement[T]) Before(v T) *AddValueStatement[T] + func (x *AddValueStatement[T]) Build() (ddl.Script, error) + func (x *AddValueStatement[T]) IfNotExists() *AddValueStatement[T] + type AlterBaseTypeQuery struct + func AlterBaseType[T any](b BaseType[T]) *AlterBaseTypeQuery[T] + func (x *AlterBaseTypeQuery[T]) RenameTo(to BaseType[T]) *AlterTypeNameStatement + func (x *AlterBaseTypeQuery[T]) SetProperties() *AlterBaseTypeStatement[T] + type AlterBaseTypeStatement struct + func (x *AlterBaseTypeStatement[T]) Analyze(f Function) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) Build() (ddl.Script, error) + func (x *AlterBaseTypeStatement[T]) Receive(f Function) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) Send(f Function) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) Storage(s TypeStorage) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) Subscript(f Function) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) TypmodIn(f Function) *AlterBaseTypeStatement[T] + func (x *AlterBaseTypeStatement[T]) TypmodOut(f Function) *AlterBaseTypeStatement[T] + type AlterClause = ddl.AlterClause[Dialect] + func AddColumnIfNotExists(c ddl.ColumnSpec, with ...ddl.ColumnClause[Dialect]) AlterClause + func AddConstraint(c Constraint) AlterClause + func AddConstraintNotValid(c Validatable) AlterClause + func AddIdentity[T identityInteger](col sqlb.Expr[T], k IdentityKind) AlterClause + func AddPrimaryKeyUsingIndex(c TableConstraint, ix Index) AlterClause + func AddUniqueUsingIndex(c TableConstraint, ix Index) AlterClause + func AttachPartition(child sqlb.Table, b PartitionBound) AlterClause + func DisableRowLevelSecurity() AlterClause + func DisableRule(r Rule) AlterClause + func DropDefault[T any](col sqlb.Expr[T]) AlterClause + func DropNotNull[T any](col sqlb.Expr[T]) AlterClause + func EnableAlwaysRule(r Rule) AlterClause + func EnableReplicaRule(r Rule) AlterClause + func EnableRowLevelSecurity() AlterClause + func EnableRule(r Rule) AlterClause + func ForceRowLevelSecurity() AlterClause + func Inherit(parent sqlb.Table) AlterClause + func NoForceRowLevelSecurity() AlterClause + func NoInherit(parent sqlb.Table) AlterClause + func NotOfType() AlterClause + func OfType[T any](c Composite[T]) AlterClause + func RenameConstraint(from, to TableConstraint) AlterClause + func RenameTo(to sqlb.Table) AlterClause + func SetColumnCompression[T any](col sqlb.Expr[T], method string) AlterClause + func SetColumnStorage[T any](col sqlb.Expr[T], s TypeStorage) AlterClause + func SetDefaultExpr[T any](col, e sqlb.Expr[T]) AlterClause + func SetDefault[T any](col sqlb.Expr[T], v T) AlterClause + func SetExpression[T any](col, e sqlb.Expr[T]) AlterClause + func SetIdentityKind[T identityInteger](col sqlb.Expr[T], k IdentityKind) AlterClause + func SetNotNull[T any](col sqlb.Expr[T]) AlterClause + func SetSchema(schema string) AlterClause + func ValidateConstraint(c TableConstraint) AlterClause + type AlterCompositeQuery struct + func AlterComposite[T any](c Composite[T]) *AlterCompositeQuery[T] + func (x *AlterCompositeQuery[T]) AddAttribute(at Attribute) *AlterCompositeStatement[T] + func (x *AlterCompositeQuery[T]) AlterAttributeType(at Attribute) *AlterCompositeStatement[T] + func (x *AlterCompositeQuery[T]) DropAttribute(name string) *AlterCompositeStatement[T] + func (x *AlterCompositeQuery[T]) RenameAttribute(from, to string) *AlterCompositeStatement[T] + func (x *AlterCompositeQuery[T]) RenameTo(to Composite[T]) *AlterTypeNameStatement + type AlterCompositeStatement struct + func (x *AlterCompositeStatement[T]) Build() (ddl.Script, error) + func (x *AlterCompositeStatement[T]) Cascade() *AlterCompositeStatement[T] + type AlterConstraintClause struct + func AlterConstraint(c TableConstraint) AlterConstraintClause + func (AlterConstraintClause) AlterClauseOf(Dialect) + func (AlterConstraintClause) Standalone() bool + func (x AlterConstraintClause) ClauseTable() sqlb.Table + func (x AlterConstraintClause) Deferrable(d Deferral) AlterConstraintClause + func (x AlterConstraintClause) Enforced() AlterConstraintClause + func (x AlterConstraintClause) Inherit() AlterConstraintClause + func (x AlterConstraintClause) NoInherit() AlterConstraintClause + func (x AlterConstraintClause) NotDeferrable() AlterConstraintClause + func (x AlterConstraintClause) NotEnforced() AlterConstraintClause + func (x AlterConstraintClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type AlterDomainQuery struct + func AlterDomain[T any](d Domain[T]) *AlterDomainQuery[T] + func (x *AlterDomainQuery[T]) AddConstraint(c DomainConstraint[T], p sqlb.Predicate) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) DropConstraint(c DomainConstraint[T]) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) DropDefault() *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) DropNotNull() *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) RenameConstraint(from, to DomainConstraint[T]) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) RenameTo(to Domain[T]) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) SetDefault(v T) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) SetDefaultExpr(e sqlb.Expr[T]) *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) SetNotNull() *AlterDomainStatement[T] + func (x *AlterDomainQuery[T]) ValidateConstraint(c DomainConstraint[T]) *AlterDomainStatement[T] + type AlterDomainStatement struct + func (x *AlterDomainStatement[T]) Build() (ddl.Script, error) + func (x *AlterDomainStatement[T]) Cascade() *AlterDomainStatement[T] + func (x *AlterDomainStatement[T]) NotValid() *AlterDomainStatement[T] + type AlterEnumQuery struct + func AlterEnum[T ~string](e Enum[T]) *AlterEnumQuery[T] + func (x *AlterEnumQuery[T]) AddValue(v T) *AddValueStatement[T] + func (x *AlterEnumQuery[T]) RenameTo(to Enum[T]) *AlterEnumStatement[T] + func (x *AlterEnumQuery[T]) RenameValue(from, to T) *AlterEnumStatement[T] + type AlterEnumStatement struct + func (x *AlterEnumStatement[T]) Build() (ddl.Script, error) + type AlterExtensionStatement struct + func UpdateExtension(e Extension) *AlterExtensionStatement + func (x *AlterExtensionStatement) Build() (ddl.Script, error) + func (x *AlterExtensionStatement) To(version string) *AlterExtensionStatement + type AlterIndexQuery struct + func AlterIndex(ix Index) *AlterIndexQuery + func (x *AlterIndexQuery) AttachPartition(part Index) *AlterIndexStatement + func (x *AlterIndexQuery) ResetStorage(first string, more ...string) *AlterIndexStatement + func (x *AlterIndexQuery) SetStorage(first StorageParameter, more ...StorageParameter) *AlterIndexStatement + type AlterIndexStatement struct + func (x *AlterIndexStatement) Build() (ddl.Script, error) + type AlterMaterializedViewQuery struct + func AlterMaterializedView(v MaterializedView) *AlterMaterializedViewQuery + func (x *AlterMaterializedViewQuery) RenameColumn(from, to string) *AlterMaterializedViewStatement + func (x *AlterMaterializedViewQuery) ResetStorage(first string, more ...string) *AlterMaterializedViewStatement + func (x *AlterMaterializedViewQuery) SetAccessMethod(m AccessMethod) *AlterMaterializedViewStatement + func (x *AlterMaterializedViewQuery) SetStorage(first StorageParameter, more ...StorageParameter) *AlterMaterializedViewStatement + type AlterMaterializedViewStatement struct + func (x *AlterMaterializedViewStatement) Build() (ddl.Script, error) + type AlterPolicyQuery struct + func AlterPolicy(p Policy) *AlterPolicyQuery + func (x *AlterPolicyQuery) RenameTo(to Policy) *AlterPolicyStatement + func (x *AlterPolicyQuery) To(first RoleRef, more ...RoleRef) *AlterPolicyStatement + func (x *AlterPolicyQuery) Using(p sqlb.Predicate) *AlterPolicyStatement + func (x *AlterPolicyQuery) WithCheck(p sqlb.Predicate) *AlterPolicyStatement + type AlterPolicyStatement struct + func (x *AlterPolicyStatement) Build() (ddl.Script, error) + func (x *AlterPolicyStatement) To(first RoleRef, more ...RoleRef) *AlterPolicyStatement + func (x *AlterPolicyStatement) Using(p sqlb.Predicate) *AlterPolicyStatement + func (x *AlterPolicyStatement) WithCheck(p sqlb.Predicate) *AlterPolicyStatement + type AlterRangeTypeQuery struct + func AlterRangeType[T any](r RangeType[T]) *AlterRangeTypeQuery[T] + func (x *AlterRangeTypeQuery[T]) RenameTo(to RangeType[T]) *AlterTypeNameStatement + type AlterSequenceQuery struct + func AlterSequence[T sequenceInteger](s Sequence[T]) *AlterSequenceQuery[T] + func (x *AlterSequenceQuery[T]) Cache(n int64) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) Cycle() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) IncrementBy(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) MaxValue(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) MinValue(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) NoCycle() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) NoMaxValue() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) NoMinValue() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) OwnedBy(col sqlb.Expr[T]) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) OwnedByNone() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) RenameTo(to Sequence[T]) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) Restart(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) SetLogged() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) SetType() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) SetUnlogged() *AlterSequenceStatement[T] + func (x *AlterSequenceQuery[T]) StartWith(n T) *AlterSequenceStatement[T] + type AlterSequenceStatement struct + func (x *AlterSequenceStatement[T]) Build() (ddl.Script, error) + func (x *AlterSequenceStatement[T]) Cache(n int64) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) Cycle() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) IfExists() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) IncrementBy(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) MaxValue(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) MinValue(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) NoCycle() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) NoMaxValue() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) NoMinValue() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) OwnedBy(col sqlb.Expr[T]) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) OwnedByNone() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) Restart(n T) *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) SetLogged() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) SetType() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) SetUnlogged() *AlterSequenceStatement[T] + func (x *AlterSequenceStatement[T]) StartWith(n T) *AlterSequenceStatement[T] + type AlterTableQuery = ddl.AlterTable[Dialect] + func AlterTable(t sqlb.Table) *AlterTableQuery + type AlterTableReady = ddl.AlterTableReady[Dialect] + type AlterTypeClause struct + func AlterType[T any](col sqlb.Expr[T], t ddl.SQLType[T]) AlterTypeClause[T] + func (AlterTypeClause[T]) AlterClauseOf(Dialect) + func (AlterTypeClause[T]) Standalone() bool + func (x AlterTypeClause[T]) Collate(collation string) AlterTypeClause[T] + func (x AlterTypeClause[T]) NamedColumns() []ddl.ColumnRef + func (x AlterTypeClause[T]) Using(e sqlb.Expr[T]) AlterTypeClause[T] + func (x AlterTypeClause[T]) WriteSQL(b *strings.Builder, a *sqlb.Args) + type AlterTypeNameStatement struct + func (x *AlterTypeNameStatement) Build() (ddl.Script, error) + type AlterViewOptionsStatement struct + func AlterViewOptions(v View) *AlterViewOptionsStatement + func (x *AlterViewOptionsStatement) Build() (ddl.Script, error) + func (x *AlterViewOptionsStatement) CheckOption(o CheckOption) *AlterViewOptionsStatement + func (x *AlterViewOptionsStatement) Reset(o ViewOption, more ...ViewOption) *AlterViewOptionsStatement + func (x *AlterViewOptionsStatement) SecurityBarrier(on bool) *AlterViewOptionsStatement + func (x *AlterViewOptionsStatement) SecurityInvoker(on bool) *AlterViewOptionsStatement + type AlterViewStatement struct + func DropViewColumnDefault[T any](v View, col sqlb.Expr[T]) *AlterViewStatement + func SetViewColumnDefault[T any](v View, col sqlb.Expr[T], value T) *AlterViewStatement + func (x *AlterViewStatement) Build() (ddl.Script, error) + type Attribute struct + func Attr[T any](name string, t ddl.SQLType[T]) Attribute + type BaseType struct + Name string + Schema string + func (BaseType[T]) TypeOf(T) + func (b BaseType[T]) Spelling(d sqlb.Dialect) (string, error) + type BitString string + type Bounds string + const BoundsExcExc + const BoundsExcInc + const BoundsIncExc + const BoundsIncInc + type CheckClause struct + func Check(c TableConstraint, p sqlb.Predicate) CheckClause + func (CheckClause) Position() ddl.Position + func (CheckClause) TableClauseOf(Dialect) + func (c CheckClause) ClauseTable() sqlb.Table + func (c CheckClause) NoInherit() CheckClause + func (c CheckClause) NotEnforced() CheckClause + func (c CheckClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type CheckOption int + const Cascaded + const Local + type Collation struct + Name string + Schema string + type ColumnDef struct + Name string + Type string + type ColumnPair struct + func RefPair[T any](local, ref sqlb.Expr[T]) ColumnPair + type CommentQuery struct + func CommentOn(o Commentable) *CommentQuery + func CommentOnColumn[T any](c sqlb.Expr[T]) *CommentQuery + func CommentOnConstraint(c TableConstraint) *CommentQuery + func CommentOnDomainConstraint[T any](c DomainConstraint[T]) *CommentQuery + func CommentOnTable(t sqlb.Table) *CommentQuery + func (x *CommentQuery) Is(text string) *CommentStatement + func (x *CommentQuery) IsNull() *CommentStatement + type CommentStatement struct + func (x *CommentStatement) Build() (ddl.Script, error) + type Commentable interface + type CompareOp string + type Composite struct + Name string + Schema string + func (Composite[T]) TypeOf(T) + func (c Composite[T]) Spelling(d sqlb.Dialect) (string, error) + type Conflict struct + func OnConflict(cols ...sqlb.SQLer) *Conflict + func OnConstraint(c TableConstraint) *Conflict + func (c *Conflict) Clause() InsertClause + func (c *Conflict) DoNothing() InsertClause + func (c *Conflict) DoUpdate(as ...sqlb.Assignment) *Conflict + func (c *Conflict) TargetWhere(ps ...sqlb.Predicate) *Conflict + func (c *Conflict) UpdateWhere(ps ...sqlb.Predicate) *Conflict + type Constraint interface + type ConstraintStatement struct + func AddConstraintStatement(c Constraint) *ConstraintStatement + func (x *ConstraintStatement) Build() (ddl.Script, error) + type CreateBaseTypeStatement struct + func CreateBaseType[T any](b BaseType[T], input, output Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Alignment(al TypeAlignment) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Analyze(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Build() (ddl.Script, error) + func (x *CreateBaseTypeStatement[T]) Category(c TypeCategory) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Collatable(on bool) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Default(v T) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Delimiter(c string) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Element(r TypeRef) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) InternalLength(n int) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Like(r TypeRef) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) PassedByValue() *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Preferred(on bool) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Receive(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Send(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Storage(s TypeStorage) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) Subscript(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) TypmodIn(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) TypmodOut(f Function) *CreateBaseTypeStatement[T] + func (x *CreateBaseTypeStatement[T]) VariableLength() *CreateBaseTypeStatement[T] + type CreateCollationStatement struct + func CreateCollation(c Collation, locale string) *CreateCollationStatement + func CreateCollationFrom(c, existing Collation) *CreateCollationStatement + func (x *CreateCollationStatement) Build() (ddl.Script, error) + func (x *CreateCollationStatement) ICU() *CreateCollationStatement + func (x *CreateCollationStatement) IfNotExists() *CreateCollationStatement + func (x *CreateCollationStatement) LcCollate(s string) *CreateCollationStatement + func (x *CreateCollationStatement) LcCtype(s string) *CreateCollationStatement + func (x *CreateCollationStatement) Nondeterministic() *CreateCollationStatement + func (x *CreateCollationStatement) Rules(s string) *CreateCollationStatement + func (x *CreateCollationStatement) Version(s string) *CreateCollationStatement + type CreateCompositeStatement struct + func CreateComposite[T any](c Composite[T], first Attribute, more ...Attribute) *CreateCompositeStatement[T] + func (x *CreateCompositeStatement[T]) Build() (ddl.Script, error) + type CreateDomainStatement struct + func CreateDomain[T any](d Domain[T], base ddl.SQLType[T]) *CreateDomainStatement[T] + func (x *CreateDomainStatement[T]) Build() (ddl.Script, error) + func (x *CreateDomainStatement[T]) Check(con DomainConstraint[T], p sqlb.Predicate) *CreateDomainStatement[T] + func (x *CreateDomainStatement[T]) Collate(c Collation) *CreateDomainStatement[T] + func (x *CreateDomainStatement[T]) Default(v T) *CreateDomainStatement[T] + func (x *CreateDomainStatement[T]) DefaultExpr(e sqlb.Expr[T]) *CreateDomainStatement[T] + func (x *CreateDomainStatement[T]) NotNull() *CreateDomainStatement[T] + type CreateEnumStatement struct + func CreateEnum[T ~string](e Enum[T], first T, more ...T) *CreateEnumStatement[T] + func (x *CreateEnumStatement[T]) Build() (ddl.Script, error) + type CreateExtensionStatement struct + func CreateExtension(e Extension) *CreateExtensionStatement + func (x *CreateExtensionStatement) Build() (ddl.Script, error) + func (x *CreateExtensionStatement) Cascade() *CreateExtensionStatement + func (x *CreateExtensionStatement) IfNotExists() *CreateExtensionStatement + func (x *CreateExtensionStatement) Schema(s Schema) *CreateExtensionStatement + func (x *CreateExtensionStatement) Version(v string) *CreateExtensionStatement + type CreateFunctionStatement struct + func CreateTriggerFunction(f Function, body string) *CreateFunctionStatement + func (x *CreateFunctionStatement) Build() (ddl.Script, error) + func (x *CreateFunctionStatement) OrReplace() *CreateFunctionStatement + type CreateIndexQuery struct + func CreateIndex(ix Index, t sqlb.Table) *CreateIndexQuery + func (x *CreateIndexQuery) Concurrently() *CreateIndexQuery + func (x *CreateIndexQuery) IfNotExists() *CreateIndexQuery + func (x *CreateIndexQuery) On(first IndexElement, more ...IndexElement) *CreateIndexReady + func (x *CreateIndexQuery) Unique() *CreateIndexQuery + func (x *CreateIndexQuery) Using(m IndexMethod) *CreateIndexQuery + type CreateIndexReady struct + func (x *CreateIndexReady) Build() (ddl.Script, error) + func (x *CreateIndexReady) Concurrently() *CreateIndexReady + func (x *CreateIndexReady) IfNotExists() *CreateIndexReady + func (x *CreateIndexReady) Include(cols ...ddl.ColumnRef) *CreateIndexReady + func (x *CreateIndexReady) NullsNotDistinct() *CreateIndexReady + func (x *CreateIndexReady) OnOnly() *CreateIndexReady + func (x *CreateIndexReady) Unique() *CreateIndexReady + func (x *CreateIndexReady) Using(m IndexMethod) *CreateIndexReady + func (x *CreateIndexReady) Where(p sqlb.Predicate) *CreateIndexReady + func (x *CreateIndexReady) With(ps ...IndexParam) *CreateIndexReady + type CreateMaterializedViewQuery struct + func CreateMaterializedView(v MaterializedView) *CreateMaterializedViewQuery + func (x *CreateMaterializedViewQuery) As(body *SelectQuery) *CreateMaterializedViewStatement + func (x *CreateMaterializedViewQuery) IfNotExists() *CreateMaterializedViewQuery + type CreateMaterializedViewStatement struct + func (x *CreateMaterializedViewStatement) Build() (ddl.Script, error) + func (x *CreateMaterializedViewStatement) Columns(first string, more ...string) *CreateMaterializedViewStatement + func (x *CreateMaterializedViewStatement) IfNotExists() *CreateMaterializedViewStatement + func (x *CreateMaterializedViewStatement) Using(m AccessMethod) *CreateMaterializedViewStatement + func (x *CreateMaterializedViewStatement) WithNoData() *CreateMaterializedViewStatement + func (x *CreateMaterializedViewStatement) WithStorage(first StorageParameter, more ...StorageParameter) *CreateMaterializedViewStatement + type CreatePartitionQuery struct + func CreatePartition(child, parent sqlb.Table) *CreatePartitionQuery + func (x *CreatePartitionQuery) For(b PartitionBound) *CreatePartitionStatement + func (x *CreatePartitionQuery) IfNotExists() *CreatePartitionQuery + type CreatePartitionStatement struct + func (x *CreatePartitionStatement) Build() (ddl.Script, error) + func (x *CreatePartitionStatement) IfNotExists() *CreatePartitionStatement + type CreatePolicyStatement struct + func CreatePolicy(p Policy) *CreatePolicyStatement + func (x *CreatePolicyStatement) Build() (ddl.Script, error) + func (x *CreatePolicyStatement) For(cmd PolicyCommand) *CreatePolicyStatement + func (x *CreatePolicyStatement) Permissive() *CreatePolicyStatement + func (x *CreatePolicyStatement) Restrictive() *CreatePolicyStatement + func (x *CreatePolicyStatement) To(first RoleRef, more ...RoleRef) *CreatePolicyStatement + func (x *CreatePolicyStatement) Using(p sqlb.Predicate) *CreatePolicyStatement + func (x *CreatePolicyStatement) WithCheck(p sqlb.Predicate) *CreatePolicyStatement + type CreateRangeTypeStatement struct + func CreateRangeType[T any](r RangeType[T], subtype ddl.SQLType[T]) *CreateRangeTypeStatement[T] + func (x *CreateRangeTypeStatement[T]) Build() (ddl.Script, error) + func (x *CreateRangeTypeStatement[T]) Canonical(f Function) *CreateRangeTypeStatement[T] + func (x *CreateRangeTypeStatement[T]) Collation(c Collation) *CreateRangeTypeStatement[T] + func (x *CreateRangeTypeStatement[T]) MultirangeTypeName(name string) *CreateRangeTypeStatement[T] + func (x *CreateRangeTypeStatement[T]) SubtypeDiff(f Function) *CreateRangeTypeStatement[T] + func (x *CreateRangeTypeStatement[T]) SubtypeOpClass(o OpClass[T]) *CreateRangeTypeStatement[T] + type CreateRoutineStatement struct + func CreateCFunction(f Function, objFile, linkSymbol string) *CreateRoutineStatement + func CreateFunction(f Function, lang Language, body string) *CreateRoutineStatement + func (x *CreateRoutineStatement) Build() (ddl.Script, error) + func (x *CreateRoutineStatement) Cost(n float64) *CreateRoutineStatement + func (x *CreateRoutineStatement) Leakproof(on bool) *CreateRoutineStatement + func (x *CreateRoutineStatement) NullInput(n NullInput) *CreateRoutineStatement + func (x *CreateRoutineStatement) OrReplace() *CreateRoutineStatement + func (x *CreateRoutineStatement) Parallel(p Parallel) *CreateRoutineStatement + func (x *CreateRoutineStatement) Returns(r FunctionResult) *CreateRoutineStatement + func (x *CreateRoutineStatement) Rows(n float64) *CreateRoutineStatement + func (x *CreateRoutineStatement) Security(s Security) *CreateRoutineStatement + func (x *CreateRoutineStatement) Set(name, value string) *CreateRoutineStatement + func (x *CreateRoutineStatement) SetFromCurrent(name string) *CreateRoutineStatement + func (x *CreateRoutineStatement) Support(f Function) *CreateRoutineStatement + func (x *CreateRoutineStatement) Transform(first TypeRef, more ...TypeRef) *CreateRoutineStatement + func (x *CreateRoutineStatement) Volatility(v Volatility) *CreateRoutineStatement + func (x *CreateRoutineStatement) Window() *CreateRoutineStatement + type CreateSchemaStatement struct + func CreateSchema(s Schema) *CreateSchemaStatement + func (x *CreateSchemaStatement) Authorization(r RoleRef) *CreateSchemaStatement + func (x *CreateSchemaStatement) Build() (ddl.Script, error) + func (x *CreateSchemaStatement) IfNotExists() *CreateSchemaStatement + type CreateSequenceStatement struct + func CreateSequence[T sequenceInteger](s Sequence[T]) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) Build() (ddl.Script, error) + func (x *CreateSequenceStatement[T]) Cache(n int64) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) Cycle() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) IfNotExists() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) IncrementBy(n T) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) MaxValue(n T) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) MinValue(n T) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) NoCycle() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) NoMaxValue() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) NoMinValue() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) OwnedBy(col sqlb.Expr[T]) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) OwnedByNone() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) Start(n T) *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) Temporary() *CreateSequenceStatement[T] + func (x *CreateSequenceStatement[T]) Unlogged() *CreateSequenceStatement[T] + type CreateShellTypeStatement struct + func CreateShellType[T any](b BaseType[T]) *CreateShellTypeStatement[T] + func (x *CreateShellTypeStatement[T]) Build() (ddl.Script, error) + type CreateStatisticsStatement struct + func CreateStatistics(s Statistics, t sqlb.Table, a, b ddl.ColumnRef, more ...ddl.ColumnRef) *CreateStatisticsStatement + func CreateStatisticsExpr(s Statistics, t sqlb.Table, e sqlb.SQLer) *CreateStatisticsStatement + func (x *CreateStatisticsStatement) Build() (ddl.Script, error) + func (x *CreateStatisticsStatement) Expression(e sqlb.SQLer) *CreateStatisticsStatement + func (x *CreateStatisticsStatement) IfNotExists() *CreateStatisticsStatement + func (x *CreateStatisticsStatement) Kinds(first StatKind, more ...StatKind) *CreateStatisticsStatement + type CreateTableAsStatement struct + func CreateTableAs(t sqlb.Table, body *SelectQuery) *CreateTableAsStatement + func (x *CreateTableAsStatement) Build() (ddl.Script, error) + func (x *CreateTableAsStatement) Columns(first string, more ...string) *CreateTableAsStatement + func (x *CreateTableAsStatement) IfNotExists() *CreateTableAsStatement + func (x *CreateTableAsStatement) OnCommit(o OnCommitAction) *CreateTableAsStatement + func (x *CreateTableAsStatement) Temporary() *CreateTableAsStatement + func (x *CreateTableAsStatement) Unlogged() *CreateTableAsStatement + func (x *CreateTableAsStatement) Using(m AccessMethod) *CreateTableAsStatement + func (x *CreateTableAsStatement) WithNoData() *CreateTableAsStatement + func (x *CreateTableAsStatement) WithStorage(first StorageParameter, more ...StorageParameter) *CreateTableAsStatement + type CreateTableLikeStatement struct + func CreateTableLike(t, src sqlb.Table, opts ...LikeOption) *CreateTableLikeStatement + func (x *CreateTableLikeStatement) Build() (ddl.Script, error) + func (x *CreateTableLikeStatement) IfNotExists() *CreateTableLikeStatement + type CreateTableQuery = ddl.CreateTable[Dialect] + func CreateTable(t sqlb.Table) *CreateTableQuery + type CreateTableReady = ddl.CreateTableReady[Dialect] + type CreateTriggerQuery struct + func CreateTrigger(tr Trigger) *CreateTriggerQuery + func (x *CreateTriggerQuery) After(first TriggerEvent, more ...TriggerEvent) *TimedTriggerQuery + func (x *CreateTriggerQuery) Before(first TriggerEvent, more ...TriggerEvent) *TimedTriggerQuery + func (x *CreateTriggerQuery) Constraint() *CreateTriggerQuery + func (x *CreateTriggerQuery) InsteadOf(first TriggerEvent, more ...TriggerEvent) *TimedTriggerQuery + func (x *CreateTriggerQuery) OrReplace() *CreateTriggerQuery + type CreateTriggerStatement struct + func (x *CreateTriggerStatement) Build() (ddl.Script, error) + type CreateViewQuery struct + func CreateView(v View) *CreateViewQuery + func (x *CreateViewQuery) As(body *SelectQuery) *CreateViewStatement + func (x *CreateViewQuery) OrReplace() *CreateViewQuery + type CreateViewStatement struct + func (x *CreateViewStatement) Build() (ddl.Script, error) + func (x *CreateViewStatement) Columns(first string, more ...string) *CreateViewStatement + func (x *CreateViewStatement) OrReplace() *CreateViewStatement + func (x *CreateViewStatement) Recursive() *CreateViewStatement + func (x *CreateViewStatement) Temporary() *CreateViewStatement + func (x *CreateViewStatement) WithCheckOption(o CheckOption) *CreateViewStatement + func (x *CreateViewStatement) WithOptions(first ViewSetting, more ...ViewSetting) *CreateViewStatement + type DateField string + const FieldCentury + const FieldDay + const FieldDecade + const FieldDow + const FieldDoy + const FieldEpoch + const FieldHour + const FieldIsoDow + const FieldIsoYear + const FieldJulian + const FieldMicroseconds + const FieldMillennium + const FieldMilliseconds + const FieldMinute + const FieldMonth + const FieldQuarter + const FieldSecond + const FieldTimezone + const FieldTimezoneHour + const FieldTimezoneMinute + const FieldWeek + const FieldYear + type Deferral int + const InitiallyDeferred + const InitiallyImmediate + type DeleteClause = sqlb.Clause[Dialect, sqlb.DeleteKind] + func DeleteUsing(srcs ...sqlb.Source) DeleteClause + type DeleteQuery = sqlb.Delete[Dialect] + func Delete(t sqlb.Table) *DeleteQuery + type Dependable interface + type DependsOnExtensionStatement struct + func DependsOnExtension(o Dependable, e Extension) *DependsOnExtensionStatement + func NoDependsOnExtension(o Dependable, e Extension) *DependsOnExtensionStatement + func (x *DependsOnExtensionStatement) Build() (ddl.Script, error) + type DetachStatement struct + func DetachPartition(parent, child sqlb.Table) *DetachStatement + func (x *DetachStatement) Build() (ddl.Script, error) + func (x *DetachStatement) Concurrently() *DetachStatement + func (x *DetachStatement) Finalize() *DetachStatement + type Dialect = postgres.Dialect + type Domain struct + Name string + Schema string + func (Domain[T]) TypeOf(T) + func (d Domain[T]) Spelling(dl sqlb.Dialect) (string, error) + type DomainCheck struct + type DomainConstraint struct + Domain Domain[T] + Name string + type DropClause = ddl.DropClause[Dialect] + func Cascade() DropClause + type DropColumnClause struct + func DropColumnIfExists[T any](col sqlb.Expr[T]) DropColumnClause + func (DropColumnClause) AlterClauseOf(Dialect) + func (x DropColumnClause) Cascade() DropColumnClause + func (x DropColumnClause) ClauseTable() sqlb.Table + func (x DropColumnClause) NamedColumns() []ddl.ColumnRef + func (x DropColumnClause) Standalone() bool + func (x DropColumnClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type DropColumnPartClause struct + func DropExpression[T any](col sqlb.Expr[T]) DropColumnPartClause + func DropIdentity[T identityInteger](col sqlb.Expr[T]) DropColumnPartClause + func (DropColumnPartClause) AlterClauseOf(Dialect) + func (DropColumnPartClause) Standalone() bool + func (x DropColumnPartClause) ClauseTable() sqlb.Table + func (x DropColumnPartClause) IfExists() DropColumnPartClause + func (x DropColumnPartClause) NamedColumns() []ddl.ColumnRef + func (x DropColumnPartClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type DropConstraintClause struct + func DropConstraint(c TableConstraint) DropConstraintClause + func (DropConstraintClause) AlterClauseOf(Dialect) + func (DropConstraintClause) Standalone() bool + func (x DropConstraintClause) Cascade() DropConstraintClause + func (x DropConstraintClause) ClauseTable() sqlb.Table + func (x DropConstraintClause) IfExists() DropConstraintClause + func (x DropConstraintClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type DropExtensionStatement struct + func DropExtension(e Extension) *DropExtensionStatement + func (x *DropExtensionStatement) Build() (ddl.Script, error) + func (x *DropExtensionStatement) Cascade() *DropExtensionStatement + func (x *DropExtensionStatement) IfExists() *DropExtensionStatement + type DropIndexStatement struct + func DropIndex(first Index, more ...Index) *DropIndexStatement + func (x *DropIndexStatement) Build() (ddl.Script, error) + func (x *DropIndexStatement) Cascade() *DropIndexStatement + func (x *DropIndexStatement) Concurrently() *DropIndexStatement + func (x *DropIndexStatement) IfExists() *DropIndexStatement + type DropObjectStatement struct + func DropCollation(c Collation) *DropObjectStatement + func DropComposite[T any](c Composite[T]) *DropObjectStatement + func DropDomain[T any](d Domain[T]) *DropObjectStatement + func DropFunction(f Function) *DropObjectStatement + func DropMaterializedView(v MaterializedView) *DropObjectStatement + func DropSequence[T sequenceInteger](s Sequence[T]) *DropObjectStatement + func DropStatistics(s Statistics) *DropObjectStatement + func DropView(v View) *DropObjectStatement + func (x *DropObjectStatement) Build() (ddl.Script, error) + func (x *DropObjectStatement) Cascade() *DropObjectStatement + func (x *DropObjectStatement) IfExists() *DropObjectStatement + func (x *DropObjectStatement) Restrict() *DropObjectStatement + type DropPolicyStatement struct + func DropPolicy(p Policy) *DropPolicyStatement + func (x *DropPolicyStatement) Build() (ddl.Script, error) + func (x *DropPolicyStatement) Cascade() *DropPolicyStatement + func (x *DropPolicyStatement) IfExists() *DropPolicyStatement + func (x *DropPolicyStatement) Restrict() *DropPolicyStatement + type DropSchemaStatement struct + func DropSchema(s Schema) *DropSchemaStatement + func (x *DropSchemaStatement) Build() (ddl.Script, error) + func (x *DropSchemaStatement) Cascade() *DropSchemaStatement + func (x *DropSchemaStatement) IfExists() *DropSchemaStatement + type DropTableQuery = ddl.DropTable[Dialect] + func DropTable(first sqlb.Table, more ...sqlb.Table) *DropTableQuery + type DropTriggerStatement struct + func DropTrigger(tr Trigger) *DropTriggerStatement + func (x *DropTriggerStatement) Build() (ddl.Script, error) + func (x *DropTriggerStatement) Cascade() *DropTriggerStatement + func (x *DropTriggerStatement) IfExists() *DropTriggerStatement + func (x *DropTriggerStatement) Restrict() *DropTriggerStatement + type DropTypeStatement struct + func DropType[T ~string](e Enum[T]) *DropTypeStatement + func (x *DropTypeStatement) Build() (ddl.Script, error) + func (x *DropTypeStatement) Cascade() *DropTypeStatement + func (x *DropTypeStatement) IfExists() *DropTypeStatement + type Enum struct + Name string + Schema string + func (Enum[T]) TypeOf(T) + func (e Enum[T]) Spelling(d sqlb.Dialect) (string, error) + type ExcludeClause struct + func Exclude(c TableConstraint, m IndexMethod, first ExcludeElement, more ...ExcludeElement) ExcludeClause + func (ExcludeClause) Position() ddl.Position + func (ExcludeClause) TableClauseOf(Dialect) + func (x ExcludeClause) ClauseTable() sqlb.Table + func (x ExcludeClause) Include(first ddl.ColumnRef, more ...ddl.ColumnRef) ExcludeClause + func (x ExcludeClause) NamedColumns() []ddl.ColumnRef + func (x ExcludeClause) Where(p sqlb.Predicate) ExcludeClause + func (x ExcludeClause) With(first StorageParameter, more ...StorageParameter) ExcludeClause + func (x ExcludeClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type ExcludeElement struct + func ExcludeOn[T any](col sqlb.Expr[T], op ExcludeOp) ExcludeElement + type ExcludeOp string + const OpAdjacent + const OpEquals + const OpOverlaps + type Extension struct + Name string + type ExtensionMember interface + func MemberTable(t sqlb.Table) ExtensionMember + type ExtensionMemberStatement struct + func AddExtensionMember(e Extension, o ExtensionMember) *ExtensionMemberStatement + func DropExtensionMember(e Extension, o ExtensionMember) *ExtensionMemberStatement + func (x *ExtensionMemberStatement) Build() (ddl.Script, error) + type FilteredDelete = sqlb.FilteredDelete[Dialect] + type FilteredUpdate = sqlb.FilteredUpdate[Dialect] + type ForeignKeyClause struct + func ForeignKey(c TableConstraint, first ColumnPair, more ...ColumnPair) ForeignKeyClause + func References[T any](local, ref sqlb.Expr[T]) ForeignKeyClause + func (ForeignKeyClause) Position() ddl.Position + func (ForeignKeyClause) TableClauseOf(Dialect) + func (f ForeignKeyClause) ClauseTable() sqlb.Table + func (f ForeignKeyClause) Deferrable(d Deferral) ForeignKeyClause + func (f ForeignKeyClause) DescribeInto(t *schema.Table) + func (f ForeignKeyClause) Match(m MatchType) ForeignKeyClause + func (f ForeignKeyClause) NamedColumns() []ddl.ColumnRef + func (f ForeignKeyClause) NotEnforced() ForeignKeyClause + func (f ForeignKeyClause) OnDelete(r RefAction) ForeignKeyClause + func (f ForeignKeyClause) OnUpdate(r RefAction) ForeignKeyClause + func (f ForeignKeyClause) Period(local, ref PeriodColumn) ForeignKeyClause + func (f ForeignKeyClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Function struct + Name string + Params []FunctionArg + Schema string + type FunctionArg struct + func Arg[T any](name string, t ddl.SQLType[T]) FunctionArg + func InOutArg[T any](name string, t ddl.SQLType[T]) FunctionArg + func OutArg[T any](name string, t ddl.SQLType[T]) FunctionArg + func VariadicArg[T any](name string, t ddl.SQLType[T]) FunctionArg + type FunctionResult struct + func ReturnsSetOf[T any](t ddl.SQLType[T]) FunctionResult + func ReturnsTable(first Attribute, more ...Attribute) FunctionResult + func Returns[T any](t ddl.SQLType[T]) FunctionResult + type Guardable interface + Build func() (ddl.Script, error) + type GuardedStatement struct + func Guarded(s Guardable) *GuardedStatement + func (x *GuardedStatement) Build() (ddl.Script, error) + type IdentityKind int + const Always + const ByDefault + type IdentitySequenceClause struct + func AlterIdentitySequence[T identityInteger](col sqlb.Expr[T]) IdentitySequenceClause[T] + func (IdentitySequenceClause[T]) AlterClauseOf(Dialect) + func (IdentitySequenceClause[T]) Standalone() bool + func (x IdentitySequenceClause[T]) Cache(n int64) IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) Cycle() IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) IncrementBy(n T) IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) MaxValue(n T) IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) MinValue(n T) IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) NamedColumns() []ddl.ColumnRef + func (x IdentitySequenceClause[T]) NoCycle() IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) StartWith(n T) IdentitySequenceClause[T] + func (x IdentitySequenceClause[T]) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Index struct + Name string + Schema string + type IndexElement interface + IndexColumns func() []ddl.ColumnRef + WriteIndexElement func(b *strings.Builder, a *sqlb.Args) + type IndexKeyElem struct + func IndexExpr[T any](e sqlb.Expr[T]) IndexKeyElem[T] + func IndexKey[T any](col sqlb.Expr[T]) IndexKeyElem[T] + func (k IndexKeyElem[T]) Asc() IndexKeyElem[T] + func (k IndexKeyElem[T]) Desc() IndexKeyElem[T] + func (k IndexKeyElem[T]) IndexColumns() []ddl.ColumnRef + func (k IndexKeyElem[T]) NullsFirst() IndexKeyElem[T] + func (k IndexKeyElem[T]) NullsLast() IndexKeyElem[T] + func (k IndexKeyElem[T]) Opclass(o OpClass[T]) IndexKeyElem[T] + func (k IndexKeyElem[T]) OpclassWith(o OpClass[T], first StorageParameter, more ...StorageParameter) IndexKeyElem[T] + func (k IndexKeyElem[T]) WriteIndexElement(b *strings.Builder, a *sqlb.Args) + type IndexMethod string + const BRIN + const BTree + const GIN + const GiST + const Hash + const SPGiST + type IndexParam struct + func NewIndexParam(name string, value int64) IndexParam + type InsertClause = sqlb.Clause[Dialect, sqlb.InsertKind] + func DefaultValues() InsertClause + func OverridingSystemValue() InsertClause + func OverridingUserValue() InsertClause + type InsertQuery = sqlb.Insert[Dialect] + func Insert(t sqlb.Table) *InsertQuery + type InsertReady = sqlb.InsertReady[Dialect] + type Interval string + type JSON struct + V T + func (j *JSON[T]) Scan(src any) error + func (j JSON[T]) Value() (driver.Value, error) + type JSONKind string + const JSONAny + const JSONAnyValue + const JSONArr + const JSONObj + const JSONScalar + type JSONOption func(*jsonSpec) + func AbsentOnNull() JSONOption + func JSONOrderBy(ts ...sqlb.OrderTerm) JSONOption + func NullOnNull() JSONOption + func ReturningJSONB() JSONOption + func WithUniqueKeys() JSONOption + type JSONPair struct + Key string + Value sqlb.SQLer + func Pair(key string, value sqlb.SQLer) JSONPair + type JSONTableColumn struct + DefaultOnEmpty string + DefaultOnError string + Exists bool + Name string + Nested *JSONTableNested + Ordinality bool + Path string + Type string + type JSONTableNested struct + Columns []JSONTableColumn + Path string + type JSONValueOption func(*jsonValueSpec) + func DefaultOnEmpty(sql string) JSONValueOption + func DefaultOnError(sql string) JSONValueOption + func Returning(sqlType string) JSONValueOption + func WithConditionalWrapper() JSONValueOption + func WithWrapper() JSONValueOption + func WithoutWrapper() JSONValueOption + type Language string + const LangC + const LangInternal + const LangPLpgSQL + const LangSQL + type LikeOption int + const IncludingComments + const IncludingCompression + const IncludingConstraints + const IncludingDefaults + const IncludingGenerated + const IncludingIdentity + const IncludingIndexes + const IncludingStatistics + const IncludingStorage + type LockOption func(*lockSpec) + func NoWait() LockOption + func Of(tables ...sqlb.Table) LockOption + func SkipLocked() LockOption + type LockTable struct + func NewLockTable(d Dialect, tables ...sqlb.Table) *LockTable + func (l *LockTable) Build() (sqlb.Query, error) + func (l *LockTable) In(mode TableLockMode) *LockTable + func (l *LockTable) NoWait() *LockTable + func (l *LockTable) Table(tables ...sqlb.Table) *LockTable + func (l *LockTable) WriteSQL(b *strings.Builder, a *sqlb.Args) + type MatchType int + const MatchFull + const MatchSimple + type MaterializedView struct + Name string + Schema string + type Merge struct + func NewMerge(d Dialect) *Merge + func (m *Merge) Build() (sqlb.Query, error) + func (m *Merge) Into(t sqlb.Table) *Merge + func (m *Merge) Returning(bs ...sqlb.Binding) *Merge + func (m *Merge) Using(src sqlb.Source, on ...sqlb.Predicate) *Merge + func (m *Merge) WhenMatched(cond ...sqlb.Predicate) WhenBuilder + func (m *Merge) WhenNotMatched(cond ...sqlb.Predicate) WhenBuilder + func (m *Merge) WhenNotMatchedBySource(cond ...sqlb.Predicate) WhenBuilder + func (m *Merge) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Movable interface + type Multirange string + type NormalForm string + const NFC + const NFD + const NFKC + const NFKD + type NullInput int + const CalledOnNullInput + const Strict + type OnCommitAction int + const DeleteRows + const DropAtCommit + const PreserveRows + type OpClass struct + func NewOpClass[T any](name string) OpClass[T] + func NullableOps[T any](o OpClass[T]) OpClass[*T] + type Ownable interface + type Parallel int + const ParallelRestricted + const ParallelSafe + const ParallelUnsafe + type PartitionBound interface + func DefaultPartition() PartitionBound + func FromTo[T any](_ sqlb.Expr[T], from, to T) PartitionBound + func HashOf(modulus, remainder int) PartitionBound + func ListValues[T any](_ sqlb.Expr[T], first T, more ...T) PartitionBound + type PeriodColumn struct + func Period[T any](col sqlb.Expr[Range[T]]) PeriodColumn + type Policy struct + Name string + Table sqlb.Table + type PolicyCommand int + const AllCommands + const DeleteCommand + const InsertCommand + const SelectCommand + const UpdateCommand + type PolicyRole int + const RoleCurrentUser + const RolePublic + const RoleSessionUser + type PrimaryKeyClause struct + func PrimaryKey(first ddl.ColumnRef, more ...ddl.ColumnRef) PrimaryKeyClause + func (PrimaryKeyClause) Position() ddl.Position + func (PrimaryKeyClause) TableClauseOf(Dialect) + func (k PrimaryKeyClause) ClauseTable() sqlb.Table + func (k PrimaryKeyClause) DescribeInto(t *schema.Table) + func (k PrimaryKeyClause) Include(first ddl.ColumnRef, more ...ddl.ColumnRef) PrimaryKeyClause + func (k PrimaryKeyClause) Named(c TableConstraint) PrimaryKeyClause + func (k PrimaryKeyClause) NamedColumns() []ddl.ColumnRef + func (k PrimaryKeyClause) With(first StorageParameter, more ...StorageParameter) PrimaryKeyClause + func (k PrimaryKeyClause) WithoutOverlaps(p PeriodColumn) PrimaryKeyClause + func (k PrimaryKeyClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Range string + type RangeType struct + Name string + Schema string + func (RangeType[T]) TypeOf(Range[T]) + func (r RangeType[T]) Spelling(d sqlb.Dialect) (string, error) + type RefAction int + const RefCascade + const RefNoAction + const RefRestrict + const RefSetDefault + const RefSetNull + type RefreshStatement struct + func RefreshMaterializedView(v MaterializedView) *RefreshStatement + func (x *RefreshStatement) Build() (ddl.Script, error) + func (x *RefreshStatement) Concurrently() *RefreshStatement + type RenameIndexStatement struct + func RenameIndex(from, to Index) *RenameIndexStatement + func (x *RenameIndexStatement) Build() (ddl.Script, error) + func (x *RenameIndexStatement) IfExists() *RenameIndexStatement + type RenameMaterializedViewStatement struct + func RenameMaterializedView(from, to MaterializedView) *RenameMaterializedViewStatement + func (x *RenameMaterializedViewStatement) Build() (ddl.Script, error) + func (x *RenameMaterializedViewStatement) IfExists() *RenameMaterializedViewStatement + type RenameSchemaStatement struct + func RenameSchema(from, to Schema) *RenameSchemaStatement + func (x *RenameSchemaStatement) Build() (ddl.Script, error) + type RenameTriggerStatement struct + func RenameTrigger(from, to Trigger) *RenameTriggerStatement + func (x *RenameTriggerStatement) Build() (ddl.Script, error) + type RenameViewColumnStatement struct + func RenameViewColumn(v View, from, to string) *RenameViewColumnStatement + func (x *RenameViewColumnStatement) Build() (ddl.Script, error) + func (x *RenameViewColumnStatement) IfExists() *RenameViewColumnStatement + type RenameViewStatement struct + func RenameView(from, to View) *RenameViewStatement + func (x *RenameViewStatement) Build() (ddl.Script, error) + func (x *RenameViewStatement) IfExists() *RenameViewStatement + type RestartIdentityClause struct + func RestartIdentity[T identityInteger](col sqlb.Expr[T]) RestartIdentityClause[T] + func (RestartIdentityClause[T]) AlterClauseOf(Dialect) + func (RestartIdentityClause[T]) Standalone() bool + func (x RestartIdentityClause[T]) NamedColumns() []ddl.ColumnRef + func (x RestartIdentityClause[T]) With(n T) RestartIdentityClause[T] + func (x RestartIdentityClause[T]) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Role struct + Name string + type RoleRef interface + type Rule struct + Name string + Table sqlb.Table + type SampleMethod string + const SampleBernoulli + const SampleSystem + type Schema struct + Name string + type Security int + const Definer + const Invoker + type SelectClause = sqlb.Clause[Dialect, sqlb.SelectKind] + func DistinctOn(exprs ...sqlb.SQLer) SelectClause + func FetchFirst(n int, withTies bool) SelectClause + func ForKeyShare(opts ...LockOption) SelectClause + func ForNoKeyUpdate(opts ...LockOption) SelectClause + func ForShare(opts ...LockOption) SelectClause + func ForUpdate(opts ...LockOption) SelectClause + func ForUpdateSkipLocked() SelectClause + func LimitAll() SelectClause + func TableSample(method SampleMethod, percent float64, seed int) SelectClause + type SelectQuery = sqlb.Select[Dialect] + func Select(items ...sqlb.SQLer) *SelectQuery + type Sequence struct + Name string + Schema string + type SetExtensionSchemaStatement struct + func SetExtensionSchema(e Extension, to Schema) *SetExtensionSchemaStatement + func (x *SetExtensionSchemaStatement) Build() (ddl.Script, error) + type SetOwnerStatement struct + func SetOwner(o Ownable, to RoleRef) *SetOwnerStatement + func (x *SetOwnerStatement) Build() (ddl.Script, error) + type SetSchemaStatement struct + func SetObjectSchema(o Movable, to Schema) *SetSchemaStatement + func (x *SetSchemaStatement) Build() (ddl.Script, error) + type StatKind int + const Dependencies + const MCV + const NDistinct + type Statistics struct + Name string + Schema string + type StorageParameter struct + func BoolParameter(name string, v bool) StorageParameter + func FloatParameter(name string, v float64) StorageParameter + func IntParameter(name string, v int64) StorageParameter + func TextParameter(name string, v string) StorageParameter + type TSQuery string + type TSVector string + type TableClause = ddl.TableClause[Dialect] + func Inherits(first sqlb.Table, more ...sqlb.Table) TableClause + func OnCommit(o OnCommitAction) TableClause + func PartitionByHash(first ddl.ColumnRef, more ...ddl.ColumnRef) TableClause + func PartitionByList(col ddl.ColumnRef) TableClause + func PartitionByRange(first ddl.ColumnRef, more ...ddl.ColumnRef) TableClause + func TableAccessMethod(m AccessMethod) TableClause + func TableStorage(first StorageParameter, more ...StorageParameter) TableClause + func Temporary() TableClause + func Unlogged() TableClause + type TableConstraint = ddl.TableConstraint + type TableLockMode string + const LockAccessExclusive + const LockAccessShare + const LockExclusive + const LockRowExclusive + const LockRowShare + const LockShare + const LockShareRowExclusive + const LockShareUpdateExclusive + type TimedTriggerQuery struct + func (x *TimedTriggerQuery) Deferrable(d Deferral) *TimedTriggerQuery + func (x *TimedTriggerQuery) Execute(f Function) *CreateTriggerStatement + func (x *TimedTriggerQuery) ExecuteWith(f Function, args ...string) *CreateTriggerStatement + func (x *TimedTriggerQuery) ForEachRow() *TimedTriggerQuery + func (x *TimedTriggerQuery) From(t sqlb.Table) *TimedTriggerQuery + func (x *TimedTriggerQuery) Referencing(oldTable, newTable string) *TimedTriggerQuery + func (x *TimedTriggerQuery) When(p sqlb.Predicate) *TimedTriggerQuery + type Trigger struct + Name string + Table sqlb.Table + type TriggerEvent struct + func OnDelete() TriggerEvent + func OnInsert() TriggerEvent + func OnTruncate() TriggerEvent + func OnUpdate() TriggerEvent + func OnUpdateOf(first ddl.ColumnRef, more ...ddl.ColumnRef) TriggerEvent + type TrimSide string + const TrimBoth + const TrimLeading + const TrimTrailing + type Truncate struct + func NewTruncate(d Dialect, tables ...sqlb.Table) *Truncate + func (t *Truncate) Build() (sqlb.Query, error) + func (t *Truncate) Cascade() *Truncate + func (t *Truncate) ContinueIdentity() *Truncate + func (t *Truncate) Only() *Truncate + func (t *Truncate) RestartIdentity() *Truncate + func (t *Truncate) Restrict() *Truncate + func (t *Truncate) Table(tables ...sqlb.Table) *Truncate + func (t *Truncate) WriteSQL(b *strings.Builder, a *sqlb.Args) + type TypeAlignment int + const AlignChar + const AlignDouble + const AlignInt2 + const AlignInt4 + type TypeCategory string + const CategoryBoolean + const CategoryDateTime + const CategoryGeometric + const CategoryNetwork + const CategoryNumeric + const CategoryRange + const CategoryString + const CategoryTimespan + const CategoryUser + type TypeRef struct + func NamedType[T any](t ddl.SQLType[T]) TypeRef + type TypeStorage int + const StorageExtended + const StorageExternal + const StorageMain + const StoragePlain + type UniqueClause struct + func Unique(c TableConstraint, first ddl.ColumnRef, more ...ddl.ColumnRef) UniqueClause + func (UniqueClause) Position() ddl.Position + func (UniqueClause) TableClauseOf(Dialect) + func (u UniqueClause) ClauseTable() sqlb.Table + func (u UniqueClause) DescribeInto(t *schema.Table) + func (u UniqueClause) Include(first ddl.ColumnRef, more ...ddl.ColumnRef) UniqueClause + func (u UniqueClause) NamedColumns() []ddl.ColumnRef + func (u UniqueClause) NullsNotDistinct() UniqueClause + func (u UniqueClause) With(first StorageParameter, more ...StorageParameter) UniqueClause + func (u UniqueClause) WithoutOverlaps(p PeriodColumn) UniqueClause + func (u UniqueClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type UpdateClause = sqlb.Clause[Dialect, sqlb.UpdateKind] + func UpdateFrom(srcs ...sqlb.Source) UpdateClause + type UpdateQuery = sqlb.Update[Dialect] + func Update(t sqlb.Table) *UpdateQuery + type Validatable interface + type View struct + Name string + Schema string + type ViewOption int + const ViewCheckOption + const ViewSecurityBarrier + const ViewSecurityInvoker + type ViewSetting struct + func CheckOptionSetting(o CheckOption) ViewSetting + func SecurityBarrierSetting(on bool) ViewSetting + func SecurityInvokerSetting(on bool) ViewSetting + type Volatility int + const Immutable + const Stable + const Volatile + type Weight string + const WeightA + const WeightB + const WeightC + const WeightD + type WhenBuilder struct + func (w WhenBuilder) ThenDelete() *Merge + func (w WhenBuilder) ThenDoNothing() *Merge + func (w WhenBuilder) ThenInsert(as ...sqlb.Assignment) *Merge + func (w WhenBuilder) ThenUpdate(as ...sqlb.Assignment) *Merge