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 AllPartitions + const UserSQLState + var ErrAutoIncrementZero = fmt.Errorf("%w: AUTO_INCREMENT must be at least 1", ErrUnknownKeyword) + var ErrBadSQLState = errors.New("sqlb/mysql: a SIGNAL takes a five-character SQLSTATE outside class 00") + var ErrBadSchedule = errors.New(...) + var ErrCharacteristicNotAlterable = errors.New("sqlb/mysql: this routine characteristic cannot be altered") + var ErrConflictingCharacteristics = errors.New("sqlb/mysql: two routine characteristics of one kind") + var ErrEmptyBody = errors.New("sqlb/mysql: the routine has no body") + var ErrEmptyName = errors.New("sqlb/mysql: object has no name") + var ErrFunctionParamMode = errors.New("sqlb/mysql: a stored function's parameter takes no IN, OUT or INOUT") + var ErrMixedReferences = errors.New("sqlb/mysql: a foreign key references one table") + var ErrPartitionBounds = errors.New(...) + var ErrPartitionDefinition = errors.New(...) + var ErrPartitionForeignKey = errors.New("sqlb/mysql: a partitioned table cannot have a foreign key") + var ErrPartitionKeyNotInKey = errors.New("sqlb/mysql: every primary and unique key must include every partition column") + var ErrRenameAcrossTables = errors.New("sqlb/mysql: RenameKey names constraints of two tables") + var ErrUnknownKeyword = errors.New("sqlb/mysql: value outside its named constants") + func AutoIncrement[T integer](col sqlb.Expr[T]) ddl.ColumnClause[Dialect] + func CharLength(e sqlb.Expr[string]) sqlb.Expr[int64] + func ClauseIn[K any](slot sqlb.Slot, construct string, render func(a *sqlb.Args) string) sqlb.Clause[Dialect, K] + func ColumnCollate[T collatable](col sqlb.Expr[T], collation string) ddl.ColumnClause[Dialect] + func ColumnComment[T any](col sqlb.Expr[T], text string) ddl.ColumnClause[Dialect] + func ColumnInvisible[T any](col sqlb.Expr[T]) ddl.ColumnClause[Dialect] + func ColumnVisible[T any](col sqlb.Expr[T]) ddl.ColumnClause[Dialect] + func Expr[T any](construct string, render func(a *sqlb.Args) string) sqlb.Expr[T] + func Func[R any](construct, name string, args ...sqlb.SQLer) sqlb.Expr[R] + 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 GroupConcat(e sqlb.Expr[string], sep string) sqlb.Expr[string] + func Guard(a *sqlb.Args, construct string) bool + func IfNull[T any](e sqlb.Expr[*T], fallback sqlb.Expr[T]) sqlb.Expr[T] + func IntDiv[T integerKind](l, r sqlb.Expr[T]) sqlb.Expr[T] + func Is(d sqlb.Dialect) bool + func JSONContains(col sqlb.Expr[json.RawMessage], candidate json.RawMessage) sqlb.Predicate + func JSONExtract(col sqlb.Expr[json.RawMessage], path string) sqlb.Expr[json.RawMessage] + func JSONValue(col sqlb.Expr[json.RawMessage], path string) sqlb.Expr[*string] + func Match(query string, mode MatchMode, first sqlb.Expr[string], ...) sqlb.Expr[float64] + func NewRow[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func New[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func NullSafeEq[T any](l, r sqlb.Expr[T]) sqlb.Predicate + func OldRow[T any](col sqlb.Expr[T]) sqlb.Expr[T] + func RegexpLike(e sqlb.Expr[string], pattern string) sqlb.Predicate + func UTCNow() sqlb.Expr[time.Time] + func UUID() sqlb.Expr[string] + type AlterAlgorithm string + const AlgorithmCopy + const AlgorithmDefault + const AlgorithmInplace + const AlgorithmInstant + type AlterClause = ddl.AlterClause[Dialect] + func AddConstraint(c Constraint) AlterClause + func AddHashPartitions(n int) AlterClause + func AddPartitions(first PartitionDef, more ...PartitionDef) AlterClause + func Algorithm(x AlterAlgorithm) AlterClause + func AnalyzePartitions(names ...string) AlterClause + func CheckPartitions(names ...string) AlterClause + func CoalescePartitions(n int) AlterClause + func ConvertToCharset(charset string) AlterClause + func DisableKeys() AlterClause + func DiscardTablespace() AlterClause + func DropCheck(c TableConstraint) AlterClause + func DropConstraint(c TableConstraint) AlterClause + func DropDefault[T any](col sqlb.Expr[T]) AlterClause + func DropForeignKey(c TableConstraint) AlterClause + func DropKey(c TableConstraint) AlterClause + func DropPartitions(names ...string) AlterClause + func DropPrimaryKey() AlterClause + func EnableKeys() AlterClause + func ForceRebuild() AlterClause + func ImportTablespace() AlterClause + func Lock(x AlterLock) AlterClause + func ModifyColumn(c ddl.ColumnSpec, with ...ddl.ColumnClause[Dialect]) AlterClause + func OptimizePartitions(names ...string) AlterClause + func RawAlter(sql string) AlterClause + func RebuildPartitions(names ...string) AlterClause + func RemovePartitioning() AlterClause + func RenameIndex(from, to Index) AlterClause + func RenameKey(from, to TableConstraint) AlterClause + func RenameTo(to sqlb.Table) AlterClause + func ReorganizePartitions(from []string, first PartitionDef, more ...PartitionDef) AlterClause + func RepairPartitions(names ...string) AlterClause + func SetAutoIncrement(n uint64) AlterClause + func SetCheckEnforced(c TableConstraint) AlterClause + func SetCheckNotEnforced(c TableConstraint) AlterClause + func SetColumnInvisible[T any](col sqlb.Expr[T]) AlterClause + func SetColumnVisible[T any](col sqlb.Expr[T]) AlterClause + func SetDefaultCharset(charset string) AlterClause + func SetDefault[T any](col sqlb.Expr[T], v T) AlterClause + func SetEngine(e Engine) AlterClause + func SetIndexInvisible(ix Index) AlterClause + func SetIndexVisible(ix Index) AlterClause + func SetRowFormat(f RowFormatKind) AlterClause + func SetTableCollate(collation string) AlterClause + func SetTableComment(text string) AlterClause + func TruncatePartitions(names ...string) AlterClause + func WithValidation() AlterClause + func WithoutValidation() AlterClause + type AlterEventQuery struct + func AlterEvent(e Event) *AlterEventQuery + func (x *AlterEventQuery) Comment(text string) *AlterEventStatement + func (x *AlterEventQuery) Do(first TriggerStep, more ...TriggerStep) *AlterEventStatement + func (x *AlterEventQuery) On(s Schedule) *AlterEventStatement + func (x *AlterEventQuery) OnCompletion(v Completion) *AlterEventStatement + func (x *AlterEventQuery) Rename(to Event) *AlterEventStatement + func (x *AlterEventQuery) Status(s EventStatus) *AlterEventStatement + type AlterEventStatement struct + func (x *AlterEventStatement) Build() (ddl.Script, error) + func (x *AlterEventStatement) Comment(text string) *AlterEventStatement + func (x *AlterEventStatement) Do(first TriggerStep, more ...TriggerStep) *AlterEventStatement + func (x *AlterEventStatement) On(s Schedule) *AlterEventStatement + func (x *AlterEventStatement) OnCompletion(v Completion) *AlterEventStatement + func (x *AlterEventStatement) Rename(to Event) *AlterEventStatement + func (x *AlterEventStatement) Status(s EventStatus) *AlterEventStatement + type AlterLock string + const LockDefault + const LockExclusive + const LockNone + const LockShared + type AlterRoutineQuery struct + func AlterFunction(f Function) *AlterRoutineQuery + func AlterProcedure(p Procedure) *AlterRoutineQuery + func (x *AlterRoutineQuery) Characteristic(first RoutineCharacteristic, more ...RoutineCharacteristic) *AlterRoutineStatement + func (x *AlterRoutineQuery) Comment(text string) *AlterRoutineStatement + type AlterRoutineStatement struct + func (x *AlterRoutineStatement) Build() (ddl.Script, error) + func (x *AlterRoutineStatement) Characteristic(first RoutineCharacteristic, more ...RoutineCharacteristic) *AlterRoutineStatement + func (x *AlterRoutineStatement) Comment(text string) *AlterRoutineStatement + type AlterTableQuery = ddl.AlterTable[Dialect] + func AlterTable(t sqlb.Table) *AlterTableQuery + type AlterTableReady = ddl.AlterTableReady[Dialect] + type AlterViewQuery struct + func AlterView(v View) *AlterViewQuery + func (x *AlterViewQuery) Algorithm(v ViewAlgorithmKind) *AlterViewQuery + func (x *AlterViewQuery) As(body *SelectQuery) *AlterViewStatement + func (x *AlterViewQuery) Columns(first string, more ...string) *AlterViewQuery + func (x *AlterViewQuery) Security(v ViewSecurity) *AlterViewQuery + type AlterViewStatement struct + func (x *AlterViewStatement) Build() (ddl.Script, error) + func (x *AlterViewStatement) WithCheckOption(o CheckOption) *AlterViewStatement + 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) NotEnforced() CheckClause + func (c CheckClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type CheckOption int + const Cascaded + const Local + type ColumnAction struct + func AddColumn(c ddl.ColumnSpec, with ...ddl.ColumnClause[Dialect]) ColumnAction + func ChangeColumn[T any](from sqlb.Expr[T], c ddl.ColumnSpec, with ...ddl.ColumnClause[Dialect]) ColumnAction + func ModifyColumnAt(c ddl.ColumnSpec, p Placement, with ...ddl.ColumnClause[Dialect]) ColumnAction + func (ColumnAction) AlterClauseOf(Dialect) + func (ColumnAction) ClauseTable() sqlb.Table + func (ColumnAction) Standalone() bool + func (x ColumnAction) At(p Placement) ColumnAction + func (x ColumnAction) NamedColumns() []ddl.ColumnRef + func (x ColumnAction) WriteSQL(b *strings.Builder, a *sqlb.Args) + type ColumnPair struct + func RefPair[T any](local, ref sqlb.Expr[T]) ColumnPair + type Completion int + const NotPreserve + const Preserve + type Constraint interface + type CreateEventQuery struct + func CreateEvent(e Event) *CreateEventQuery + func (x *CreateEventQuery) IfNotExists() *CreateEventQuery + func (x *CreateEventQuery) On(s Schedule) *ScheduledEventQuery + type CreateEventStatement struct + func (x *CreateEventStatement) Build() (ddl.Script, error) + type CreateIndexQuery struct + func CreateIndex(ix Index, t sqlb.Table) *CreateIndexQuery + func (x *CreateIndexQuery) Fulltext() *CreateIndexQuery + func (x *CreateIndexQuery) On(first IndexElement, more ...IndexElement) *CreateIndexReady + func (x *CreateIndexQuery) Spatial() *CreateIndexQuery + func (x *CreateIndexQuery) Unique() *CreateIndexQuery + func (x *CreateIndexQuery) Using(m IndexMethod) *CreateIndexQuery + type CreateIndexReady struct + func (x *CreateIndexReady) Algorithm(v AlterAlgorithm) *CreateIndexReady + func (x *CreateIndexReady) Build() (ddl.Script, error) + func (x *CreateIndexReady) IfNotExists() *CreateIndexReady + func (x *CreateIndexReady) Lock(v AlterLock) *CreateIndexReady + func (x *CreateIndexReady) With(first IndexOption, more ...IndexOption) *CreateIndexReady + type CreateRoutineQuery struct + func CreateFunction[T any](f Function, returns ddl.SQLType[T]) *CreateRoutineQuery + func CreateProcedure(p Procedure) *CreateRoutineQuery + func (x *CreateRoutineQuery) Body(body string) *CreateRoutineStatement + func (x *CreateRoutineQuery) Characteristic(first RoutineCharacteristic, more ...RoutineCharacteristic) *CreateRoutineQuery + func (x *CreateRoutineQuery) Comment(text string) *CreateRoutineQuery + func (x *CreateRoutineQuery) IfNotExists() *CreateRoutineQuery + func (x *CreateRoutineQuery) Param(first Param, more ...Param) *CreateRoutineQuery + type CreateRoutineStatement struct + func (x *CreateRoutineStatement) Build() (ddl.Script, error) + type CreateTableAsStatement struct + func CreateTableAs(t sqlb.Table, body *SelectQuery) *CreateTableAsStatement + func (x *CreateTableAsStatement) Build() (ddl.Script, error) + func (x *CreateTableAsStatement) IfNotExists() *CreateTableAsStatement + func (x *CreateTableAsStatement) OnConflict(c RowConflict) *CreateTableAsStatement + func (x *CreateTableAsStatement) Temporary() *CreateTableAsStatement + type CreateTableLikeStatement struct + func CreateTableLike(t, src sqlb.Table) *CreateTableLikeStatement + func (x *CreateTableLikeStatement) Build() (ddl.Script, error) + func (x *CreateTableLikeStatement) IfNotExists() *CreateTableLikeStatement + func (x *CreateTableLikeStatement) Temporary() *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(e TriggerEvent, t sqlb.Table) *TimedTriggerQuery + func (x *CreateTriggerQuery) Before(e TriggerEvent, t sqlb.Table) *TimedTriggerQuery + func (x *CreateTriggerQuery) IfNotExists() *CreateTriggerQuery + type CreateTriggerStatement struct + func (x *CreateTriggerStatement) Build() (ddl.Script, error) + type CreateViewQuery struct + func CreateView(v View) *CreateViewQuery + func (x *CreateViewQuery) Algorithm(v ViewAlgorithmKind) *CreateViewQuery + func (x *CreateViewQuery) As(body *SelectQuery) *CreateViewStatement + func (x *CreateViewQuery) Columns(first string, more ...string) *CreateViewQuery + func (x *CreateViewQuery) OrReplace() *CreateViewQuery + func (x *CreateViewQuery) Security(v ViewSecurity) *CreateViewQuery + type CreateViewStatement struct + func (x *CreateViewStatement) Build() (ddl.Script, error) + func (x *CreateViewStatement) OrReplace() *CreateViewStatement + func (x *CreateViewStatement) WithCheckOption(o CheckOption) *CreateViewStatement + type DeleteClause = sqlb.Clause[Dialect, sqlb.DeleteKind] + func DeleteLimit(n int64, order ...sqlb.OrderTerm) DeleteClause + type DeleteQuery = sqlb.Delete[Dialect] + func Delete(t sqlb.Table) *DeleteQuery + type Dialect = mysql.Dialect + type DropIndexStatement struct + func DropIndex(ix Index, t sqlb.Table) *DropIndexStatement + func (x *DropIndexStatement) Algorithm(v AlterAlgorithm) *DropIndexStatement + func (x *DropIndexStatement) Build() (ddl.Script, error) + func (x *DropIndexStatement) IfExists() *DropIndexStatement + func (x *DropIndexStatement) Lock(v AlterLock) *DropIndexStatement + type DropStatement struct + func DropEvent(e Event) *DropStatement + func DropFunction(f Function) *DropStatement + func DropProcedure(p Procedure) *DropStatement + func DropTrigger(tr Trigger) *DropStatement + func DropView(v View) *DropStatement + func (x *DropStatement) Build() (ddl.Script, error) + func (x *DropStatement) IfExists() *DropStatement + type DropTableQuery = ddl.DropTable[Dialect] + func DropTable(first sqlb.Table, more ...sqlb.Table) *DropTableQuery + type DropTemporaryTableStatement struct + func DropTemporaryTable(first sqlb.Table, more ...sqlb.Table) *DropTemporaryTableStatement + func (x *DropTemporaryTableStatement) Build() (ddl.Script, error) + func (x *DropTemporaryTableStatement) IfExists() *DropTemporaryTableStatement + type Engine string + const EngineInnoDB + const EngineMemory + const EngineMyISAM + type Event struct + Name string + type EventStatus int + const EventDisable + const EventDisableOnReplica + const EventEnable + type ExchangePartitionClause struct + func ExchangePartition(name string, with sqlb.Table) ExchangePartitionClause + func (ExchangePartitionClause) AlterClauseOf(Dialect) + func (ExchangePartitionClause) NamedColumns() []ddl.ColumnRef + func (ExchangePartitionClause) Standalone() bool + func (x ExchangePartitionClause) WithoutValidation() ExchangePartitionClause + func (x ExchangePartitionClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + 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) DescribeInto(t *schema.Table) + func (f ForeignKeyClause) NamedColumns() []ddl.ColumnRef + func (f ForeignKeyClause) OnDelete(r RefAction) ForeignKeyClause + func (f ForeignKeyClause) OnUpdate(r RefAction) ForeignKeyClause + func (f ForeignKeyClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Function struct + Name string + type Index struct + Name 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 IndexPrefix[T ~string | *string](col sqlb.Expr[T], n int) IndexKeyElem[T] + func (k IndexKeyElem[T]) Desc() IndexKeyElem[T] + func (k IndexKeyElem[T]) IndexColumns() []ddl.ColumnRef + func (k IndexKeyElem[T]) WriteIndexElement(b *strings.Builder, a *sqlb.Args) + type IndexMethod string + const BTree + const Hash + type IndexOption struct + func IndexComment(text string) IndexOption + func IndexInvisible() IndexOption + func IndexKeyBlockSize(kb int) IndexOption + func IndexVisible() IndexOption + func IndexWithParser(name string) IndexOption + type InsertClause = sqlb.Clause[Dialect, sqlb.InsertKind] + func InsertIgnore() InsertClause + func OnDuplicateKeyUpdate(first sqlb.Assignment, more ...sqlb.Assignment) InsertClause + type InsertQuery = sqlb.Insert[Dialect] + func Insert(t sqlb.Table) *InsertQuery + type InsertReady = sqlb.InsertReady[Dialect] + type IntervalUnit string + const UnitDay + const UnitHour + const UnitMinute + const UnitMonth + const UnitQuarter + const UnitSecond + const UnitWeek + const UnitYear + type KeyClause struct + func PrimaryKey(first ddl.ColumnRef, more ...ddl.ColumnRef) KeyClause + func TableFulltext(ix Index, first ddl.ColumnRef, more ...ddl.ColumnRef) KeyClause + func TableIndex(ix Index, first ddl.ColumnRef, more ...ddl.ColumnRef) KeyClause + func TableSpatial(ix Index, first ddl.ColumnRef, more ...ddl.ColumnRef) KeyClause + func Unique(c TableConstraint, first ddl.ColumnRef, more ...ddl.ColumnRef) KeyClause + func (KeyClause) Position() ddl.Position + func (KeyClause) TableClauseOf(Dialect) + func (k KeyClause) ClauseTable() sqlb.Table + func (k KeyClause) DescribeInto(t *schema.Table) + func (k KeyClause) NamedColumns() []ddl.ColumnRef + func (k KeyClause) Using(m IndexMethod) KeyClause + func (k KeyClause) With(first IndexOption, more ...IndexOption) KeyClause + func (k KeyClause) WriteSQL(b *strings.Builder, a *sqlb.Args) + type LockOption int + const NoWait + const SkipLocked + type MatchMode int + const Boolean + const NaturalLanguage + type Param struct + func RoutineParam[T any](name string, t ddl.SQLType[T]) Param + func (p Param) Mode(m ParamMode) Param + type ParamMode int + const ModeIn + const ModeInOut + const ModeOut + type PartitionDef struct + func In(name string, values ...any) PartitionDef + func LessThan(name string, values ...any) PartitionDef + func LessThanMax(name string) PartitionDef + type PartitionKey struct + func PartitionOn[T integer](col sqlb.Expr[T]) PartitionKey + func PartitionToDays(col sqlb.Expr[time.Time]) PartitionKey + func PartitionToSeconds(col sqlb.Expr[time.Time]) PartitionKey + func PartitionYear(col sqlb.Expr[time.Time]) PartitionKey + type Partitioning struct + func PartitionByHash(key PartitionKey, n int) Partitioning + func PartitionByKey(n int, first ddl.ColumnRef, more ...ddl.ColumnRef) Partitioning + func PartitionByList(key PartitionKey) Partitioning + func PartitionByListColumns(first ddl.ColumnRef, more ...ddl.ColumnRef) Partitioning + func PartitionByRange(key PartitionKey) Partitioning + func PartitionByRangeColumns(first ddl.ColumnRef, more ...ddl.ColumnRef) Partitioning + func (Partitioning) OptionRank() ddl.OptionRank + func (Partitioning) Position() ddl.Position + func (Partitioning) TableClauseOf(Dialect) + func (p Partitioning) CheckTable(t schema.Table) error + func (p Partitioning) NamedColumns() []ddl.ColumnRef + func (p Partitioning) With(defs ...PartitionDef) Partitioning + func (p Partitioning) WriteSQL(b *strings.Builder, a *sqlb.Args) + type Placement struct + func After[T any](col sqlb.Expr[T]) Placement + func First() Placement + type Procedure struct + Name string + type RefAction int + const RefCascade + const RefNoAction + const RefRestrict + const RefSetNull + type RenameTableStatement struct + func RenameTable(from, to sqlb.Table) *RenameTableStatement + func (x *RenameTableStatement) And(from, to sqlb.Table) *RenameTableStatement + func (x *RenameTableStatement) Build() (ddl.Script, error) + type RoutineCharacteristic int + const ContainsSQL + const Deterministic + const LanguageSQL + const ModifiesSQLData + const NoSQL + const NotDeterministic + const ReadsSQLData + const SecurityDefiner + const SecurityInvoker + type RowConflict int + const ConflictIgnore + const ConflictReplace + type RowFormatKind string + const RowFormatCompact + const RowFormatCompressed + const RowFormatDefault + const RowFormatDynamic + const RowFormatRedundant + type Schedule struct + func EventAfter(n int64, u IntervalUnit) Schedule + func EventAt(t time.Time) Schedule + func EventEvery(n int64, u IntervalUnit) Schedule + func (s Schedule) Ends(t time.Time) Schedule + func (s Schedule) Starts(t time.Time) Schedule + type ScheduledEventQuery struct + func (x *ScheduledEventQuery) Comment(text string) *ScheduledEventQuery + func (x *ScheduledEventQuery) Do(first TriggerStep, more ...TriggerStep) *CreateEventStatement + func (x *ScheduledEventQuery) OnCompletion(c Completion) *ScheduledEventQuery + func (x *ScheduledEventQuery) Status(s EventStatus) *ScheduledEventQuery + type SelectClause = sqlb.Clause[Dialect, sqlb.SelectKind] + func ForShare(opts ...LockOption) SelectClause + func ForUpdate(opts ...LockOption) SelectClause + func ForUpdateOf(t sqlb.Table, opts ...LockOption) SelectClause + func WithRollup() SelectClause + type SelectQuery = sqlb.Select[Dialect] + func Select(items ...sqlb.SQLer) *SelectQuery + type TableClause = ddl.TableClause[Dialect] + func DefaultCharset(charset string) TableClause + func InnoDB() TableClause + func RawTableOption(sql string) TableClause + func RowFormat(f RowFormatKind) TableClause + func TableCollate(collation string) TableClause + func TableComment(text string) TableClause + func TableEngine(e Engine) TableClause + func Temporary() TableClause + type TableConstraint = ddl.TableConstraint + type TimedTriggerQuery struct + func (x *TimedTriggerQuery) Do(first TriggerStep, more ...TriggerStep) *CreateTriggerStatement + func (x *TimedTriggerQuery) Follows(other Trigger) *TimedTriggerQuery + func (x *TimedTriggerQuery) Precedes(other Trigger) *TimedTriggerQuery + type Trigger struct + Name string + type TriggerEvent string + const OnDelete + const OnInsert + const OnUpdate + type TriggerStep struct + func StepBlock(opener, closer string, inner ...TriggerStep) TriggerStep + func StepDelete(s *FilteredDelete) TriggerStep + func StepInsert(s *InsertReady) TriggerStep + func StepRaw(sql string) TriggerStep + func StepSetNew[T any](col sqlb.Expr[T], v sqlb.Expr[T]) TriggerStep + func StepSignal(sqlState, message string) TriggerStep + func StepUpdate(s *FilteredUpdate) TriggerStep + type TruncateStatement struct + func Truncate(t sqlb.Table) *TruncateStatement + func (x *TruncateStatement) Build() (ddl.Script, error) + type UpdateClause = sqlb.Clause[Dialect, sqlb.UpdateKind] + func UpdateLimit(n int64, order ...sqlb.OrderTerm) UpdateClause + type UpdateQuery = sqlb.Update[Dialect] + func Update(t sqlb.Table) *UpdateQuery + type View struct + Name string + type ViewAlgorithmKind string + const ViewMerge + const ViewTemptable + const ViewUndefined + type ViewSecurity int + const ViewDefiner + const ViewInvoker