builder

Mar 16, 2026

Changes in this version

+ type CreateFunctionBuilder struct

+ func CreateFunction(functionName Identer) CreateFunctionBuilder

+ func (b CreateFunctionBuilder) Body(body string) CreateFunctionBuilder

+ func (b CreateFunctionBuilder) DollarTag(tag string) CreateFunctionBuilder

+ func (b CreateFunctionBuilder) Language(lang string) CreateFunctionBuilder

+ func (b CreateFunctionBuilder) OrReplace() CreateFunctionBuilder

+ func (b CreateFunctionBuilder) Returns(typeName string) CreateFunctionBuilder

+ func (b CreateFunctionBuilder) WriteSQL(sb *SQLBuilder)

type CreateTableBuilder

+ func (b CreateTableBuilder) Like(source Identer) LikeCreateTableBuilder

+ type LikeCreateTableBuilder struct

+ func (b LikeCreateTableBuilder) ExcludingComments() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingCompression() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingConstraints() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingDefaults() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingGenerated() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingIdentity() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingIndexes() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingStatistics() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) ExcludingStorage() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingAll() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingComments() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingCompression() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingConstraints() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingDefaults() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingGenerated() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingIdentity() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingIndexes() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingStatistics() LikeCreateTableBuilder

+ func (b LikeCreateTableBuilder) IncludingStorage() LikeCreateTableBuilder

Mar 13, 2026

Changes in this version

+ type AddColumnAlterTableBuilder struct

+ func (b AddColumnAlterTableBuilder) Check(exp Exp) AddColumnAlterTableBuilder

+ func (b AddColumnAlterTableBuilder) Default(exp Exp) AddColumnAlterTableBuilder

+ func (b AddColumnAlterTableBuilder) NotNull() AddColumnAlterTableBuilder

+ func (b AddColumnAlterTableBuilder) PrimaryKey() AddColumnAlterTableBuilder

+ func (b AddColumnAlterTableBuilder) References(table Identer, columns ...string) ReferencesAlterTableBuilder

+ func (b AddColumnAlterTableBuilder) Unique() AddColumnAlterTableBuilder

+ type AddConstraintAlterTableBuilder struct

+ func (b AddConstraintAlterTableBuilder) Check(exp Exp) AlterTableBuilder

+ func (b AddConstraintAlterTableBuilder) ForeignKey(columns ...string) AddForeignKeyAlterTableBuilder

+ func (b AddConstraintAlterTableBuilder) PrimaryKey(columns ...string) AlterTableBuilder

+ func (b AddConstraintAlterTableBuilder) Unique(columns ...string) AlterTableBuilder

+ type AddForeignKeyAlterTableBuilder struct

+ func (b AddForeignKeyAlterTableBuilder) References(table Identer, columns ...string) ReferencesConstraintAlterTableBuilder

+ type AlterColumnBuilder struct

+ func (b AlterColumnBuilder) DropDefault() AlterTableBuilder

+ func (b AlterColumnBuilder) DropNotNull() AlterTableBuilder

+ func (b AlterColumnBuilder) SetDefault(exp Exp) AlterTableBuilder

+ func (b AlterColumnBuilder) SetNotNull() AlterTableBuilder

+ func (b AlterColumnBuilder) Type(typeName string) AlterTableBuilder

+ type AlterTableBuilder struct

+ func AlterTable(tableName Identer) AlterTableBuilder

+ func (b AlterTableBuilder) AddColumn(name string, typeName string) AddColumnAlterTableBuilder

+ func (b AlterTableBuilder) AddColumnIfNotExists(name string, typeName string) AddColumnAlterTableBuilder

+ func (b AlterTableBuilder) AddConstraint(name string) AddConstraintAlterTableBuilder

+ func (b AlterTableBuilder) AlterColumn(name string) AlterColumnBuilder

+ func (b AlterTableBuilder) DropColumn(name string) AlterTableBuilder

+ func (b AlterTableBuilder) DropColumnIfExists(name string) AlterTableBuilder

+ func (b AlterTableBuilder) DropConstraint(name string) AlterTableBuilder

+ func (b AlterTableBuilder) DropConstraintIfExists(name string) AlterTableBuilder

+ func (b AlterTableBuilder) IfExists() AlterTableBuilder

+ func (b AlterTableBuilder) RenameColumn(oldName, newName string) AlterTableBuilder

+ func (b AlterTableBuilder) RenameTo(newName string) AlterTableBuilder

+ func (b AlterTableBuilder) WriteSQL(sb *SQLBuilder)

+ type ColumnCreateTableBuilder struct

+ func (b ColumnCreateTableBuilder) Check(exp Exp) ColumnCreateTableBuilder

+ func (b ColumnCreateTableBuilder) Default(exp Exp) ColumnCreateTableBuilder

+ func (b ColumnCreateTableBuilder) NotNull() ColumnCreateTableBuilder

+ func (b ColumnCreateTableBuilder) PrimaryKey() ColumnCreateTableBuilder

+ func (b ColumnCreateTableBuilder) References(table Identer, columns ...string) ReferencesCreateTableBuilder

+ func (b ColumnCreateTableBuilder) Unique() ColumnCreateTableBuilder

+ type ConstraintCreateTableBuilder struct

+ func (b ConstraintCreateTableBuilder) Check(exp Exp) CreateTableBuilder

+ func (b ConstraintCreateTableBuilder) ForeignKey(columns ...string) ForeignKeyCreateTableBuilder

+ func (b ConstraintCreateTableBuilder) PrimaryKey(columns ...string) CreateTableBuilder

+ func (b ConstraintCreateTableBuilder) Unique(columns ...string) CreateTableBuilder

+ type CreateIndexBuilder struct

+ func CreateIndex(indexName string) CreateIndexBuilder

+ func (b CreateIndexBuilder) Columns(columns ...Exp) CreateIndexBuilder

+ func (b CreateIndexBuilder) Concurrently() CreateIndexBuilder

+ func (b CreateIndexBuilder) IfNotExists() CreateIndexBuilder

+ func (b CreateIndexBuilder) Include(columns ...string) CreateIndexBuilder

+ func (b CreateIndexBuilder) On(tableName Identer) CreateIndexBuilder

+ func (b CreateIndexBuilder) Unique() CreateIndexBuilder

+ func (b CreateIndexBuilder) Using(method string) CreateIndexBuilder

+ func (b CreateIndexBuilder) Where(cond Exp) CreateIndexBuilder

+ func (b CreateIndexBuilder) WriteSQL(sb *SQLBuilder)

+ type CreateSchemaBuilder struct

+ func CreateSchema(schemaName Identer) CreateSchemaBuilder

+ func (b CreateSchemaBuilder) Authorization(role string) CreateSchemaBuilder

+ func (b CreateSchemaBuilder) IfNotExists() CreateSchemaBuilder

+ func (b CreateSchemaBuilder) WriteSQL(sb *SQLBuilder)

+ type CreateTableBuilder struct

+ func CreateTable(tableName Identer) CreateTableBuilder

+ func (b CreateTableBuilder) Check(exp Exp) CreateTableBuilder

+ func (b CreateTableBuilder) Column(name string, typeName string) ColumnCreateTableBuilder

+ func (b CreateTableBuilder) Constraint(name string) ConstraintCreateTableBuilder

+ func (b CreateTableBuilder) ForeignKey(columns ...string) ForeignKeyCreateTableBuilder

+ func (b CreateTableBuilder) IfNotExists() CreateTableBuilder

+ func (b CreateTableBuilder) PrimaryKey(columns ...string) CreateTableBuilder

+ func (b CreateTableBuilder) Unique(columns ...string) CreateTableBuilder

+ func (b CreateTableBuilder) Unlogged() CreateTableBuilder

+ func (b CreateTableBuilder) WriteSQL(sb *SQLBuilder)

+ type DropSchemaBuilder struct

+ func DropSchema(schemaName Identer, rest ...Identer) DropSchemaBuilder

+ func (b DropSchemaBuilder) Cascade() DropSchemaBuilder

+ func (b DropSchemaBuilder) IfExists() DropSchemaBuilder

+ func (b DropSchemaBuilder) Restrict() DropSchemaBuilder

+ func (b DropSchemaBuilder) WriteSQL(sb *SQLBuilder)

+ type DropTableBuilder struct

+ func DropTable(tableName Identer, rest ...Identer) DropTableBuilder

+ func (b DropTableBuilder) Cascade() DropTableBuilder

+ func (b DropTableBuilder) IfExists() DropTableBuilder

+ func (b DropTableBuilder) Restrict() DropTableBuilder

+ func (b DropTableBuilder) WriteSQL(sb *SQLBuilder)

+ type ForeignKeyCreateTableBuilder struct

+ func (b ForeignKeyCreateTableBuilder) References(table Identer, columns ...string) ReferencesConstraintCreateTableBuilder

+ type ReferencesAlterTableBuilder struct

+ func (b ReferencesAlterTableBuilder) OnDelete(action string) ReferencesAlterTableBuilder

+ func (b ReferencesAlterTableBuilder) OnUpdate(action string) ReferencesAlterTableBuilder

+ type ReferencesConstraintAlterTableBuilder struct

+ func (b ReferencesConstraintAlterTableBuilder) OnDelete(action string) ReferencesConstraintAlterTableBuilder

+ func (b ReferencesConstraintAlterTableBuilder) OnUpdate(action string) ReferencesConstraintAlterTableBuilder

+ type ReferencesConstraintCreateTableBuilder struct

+ func (b ReferencesConstraintCreateTableBuilder) OnDelete(action string) ReferencesConstraintCreateTableBuilder

+ func (b ReferencesConstraintCreateTableBuilder) OnUpdate(action string) ReferencesConstraintCreateTableBuilder

+ type ReferencesCreateTableBuilder struct

+ func (b ReferencesCreateTableBuilder) OnDelete(action string) ReferencesCreateTableBuilder

+ func (b ReferencesCreateTableBuilder) OnUpdate(action string) ReferencesCreateTableBuilder

Jul 8, 2025

Changes in this version

type CombinationBuilder

+ func (b CombinationBuilder) Query(query SelectExp) CombinationBuilder

type ExpBase

+ func (b ExpBase) IsDistinctFrom(rgt Exp) Exp

+ func (b ExpBase) IsNotDistinctFrom(rgt Exp) Exp

Jul 8, 2025

Changes in this version

type ExpBase

+ func (b ExpBase) Subscript(index Exp, upperBound ...Exp) ExpBase

type Expressions

+ func ToExpressions(exps ...Exp) Expressions

Apr 15, 2025

Changes in this version

+ type AggBuilder struct

+ func (b AggBuilder) Distinct() AggBuilder

+ func (b AggBuilder) Filter(cond Exp) AggBuilder

+ func (b AggBuilder) IsExp()

+ func (b AggBuilder) OrderBy(exp Exp) OrderByAggBuilder

+ func (b AggBuilder) Over(windowName ...string) WindowFuncCallBuilder

+ func (b AggBuilder) WithinGroup() AggBuilder

+ func (b AggBuilder) WriteSQL(sb *SQLBuilder)

+ type OrderByAggBuilder struct

+ func (b OrderByAggBuilder) Asc() OrderByAggBuilder

+ func (b OrderByAggBuilder) Desc() OrderByAggBuilder

+ func (b OrderByAggBuilder) NullsFirst() OrderByAggBuilder

+ func (b OrderByAggBuilder) NullsLast() OrderByAggBuilder

Apr 11, 2025

Changes in this version

+ type WindowFuncBuilder struct

+ FuncCall Exp

+ func (b WindowFuncBuilder) Over(existingWindowName ...string) WindowFuncCallBuilder

Apr 11, 2025

Changes in this version

type AggExpBuilder

+ func (b AggExpBuilder) Over(windowName ...string) WindowFuncCallBuilder

+ type OrderByWindowFuncCallBuilder struct

+ func (b OrderByWindowFuncCallBuilder) Asc() OrderByWindowFuncCallBuilder

+ func (b OrderByWindowFuncCallBuilder) Desc() OrderByWindowFuncCallBuilder

+ func (b OrderByWindowFuncCallBuilder) NullsFirst() OrderByWindowFuncCallBuilder

+ func (b OrderByWindowFuncCallBuilder) NullsLast() OrderByWindowFuncCallBuilder

+ type OrderByWindowSelectBuilder struct

+ func (b OrderByWindowSelectBuilder) Asc() OrderByWindowSelectBuilder

+ func (b OrderByWindowSelectBuilder) Desc() OrderByWindowSelectBuilder

+ func (b OrderByWindowSelectBuilder) NullsFirst() OrderByWindowSelectBuilder

+ func (b OrderByWindowSelectBuilder) NullsLast() OrderByWindowSelectBuilder

type SelectBuilder

+ func (b SelectBuilder) Window(name string) WindowSelectBuilder

+ type WindowFuncCallBuilder struct

+ FuncCall Exp

+ func (b WindowFuncCallBuilder) IsExp()

+ func (b WindowFuncCallBuilder) OrderBy(exp Exp) OrderByWindowFuncCallBuilder

+ func (b WindowFuncCallBuilder) PartitionBy(exp Exp, exps ...Exp) WindowFuncCallBuilder

+ func (b WindowFuncCallBuilder) WriteSQL(sb *SQLBuilder)

+ type WindowSelectBuilder struct

+ func (b WindowSelectBuilder) As(existingWindowName ...string) WindowSelectBuilder

+ func (b WindowSelectBuilder) OrderBy(exp Exp) OrderByWindowSelectBuilder

+ func (b WindowSelectBuilder) PartitionBy(exp Exp, exps ...Exp) WindowSelectBuilder

Jan 6, 2025

Changes in this version

type QueryBuilder

+ func (b *QueryBuilder) PrettyPrint() *QueryBuilder

type SelectBuilder

+ func (b SelectBuilder) IsEmpty() bool

Oct 11, 2024

Changes in this version

type JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) ApplyIf(condition bool, apply func(b JsonBuildObjectBuilder) JsonBuildObjectBuilder) JsonBuildObjectBuilder

Jun 26, 2024

Changes in this version

+ var ErrInvalidType = errors.New("type: invalid")

type Exp

+ func All(exp Exp) Exp

+ func Any(exp Exp) Exp

type UpdateBuilder

+ func (b UpdateBuilder) ApplyIf(cond bool, apply func(q UpdateBuilder) UpdateBuilder) UpdateBuilder

Sep 20, 2023

Changes in this version

+ type Precedencer interface

+ Precedence func() int

Jun 23, 2023

Changes in this version

+ type ForSelectBuilder struct

+ func (fb ForSelectBuilder) Nowait() ForSelectBuilder

+ func (fb ForSelectBuilder) Of(tableName string, tableNames ...string) ForSelectBuilder

+ func (fb ForSelectBuilder) SkipLocked() ForSelectBuilder

type SelectBuilder

+ func (b SelectBuilder) ForKeyShare() ForSelectBuilder

+ func (b SelectBuilder) ForNoKeyUpdate() ForSelectBuilder

+ func (b SelectBuilder) ForShare() ForSelectBuilder

+ func (b SelectBuilder) ForUpdate() ForSelectBuilder

May 2, 2023

Changes in this version

+ type Expressions []Exp

+ func (e Expressions) IsExp()

+ func (e Expressions) WriteSQL(sb *SQLBuilder)

Apr 26, 2023

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) CrossJoin(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) CrossJoinLateral(from FromExp) JoinSelectBuilder

Apr 11, 2023

Changes in this version

+ type Identer interface

+ Ident func() string

Apr 11, 2023

Changes in this version

type IdentExp

+ func (i IdentExp) Ident() string

Apr 7, 2023

Changes in this version

type ExpBase

+ func (b ExpBase) RegexpIMatch(pattern Exp) Exp

+ func (b ExpBase) RegexpINotMatch(pattern Exp) Exp

+ func (b ExpBase) RegexpMatch(pattern Exp) Exp

+ func (b ExpBase) RegexpNotMatch(pattern Exp) Exp

type FuncBuilder

+ func (b FuncBuilder) NoParensExp()

type IdentExp

+ func (i IdentExp) NoParensExp()

type JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) NoParensExp()

type SelectBuilder

+ func (b SelectBuilder) NoParensExp()

Apr 7, 2023

Changes in this version

type ExpBase

+ func (b ExpBase) ContainedBy(rgt Exp) ExpBase

+ func (b ExpBase) Contains(rgt Exp) ExpBase

Apr 6, 2023

Changes in this version

type ExpBase

+ func Extract(field string, from Exp) ExpBase

+ func Neg(exp Exp) ExpBase

+ func (b ExpBase) Divide(rgt Exp) ExpBase

+ func (b ExpBase) Minus(rgt Exp) ExpBase

+ func (b ExpBase) Mod(rgt Exp) ExpBase

+ func (b ExpBase) Mult(rgt Exp) ExpBase

+ func (b ExpBase) Plus(rgt Exp) ExpBase

+ func (b ExpBase) Pow(rgt Exp) ExpBase

Apr 6, 2023

Changes in this version

+ var ErrInsertConflictConstraintAndTarget = errors.New("insert: cannot set both conflict constraint name and targets")

+ var ErrInsertValuesAndQuery = errors.New("insert: cannot set both values and query")

type DeleteBuilder

+ func (b DeleteBuilder) Returning(outputExpression Exp) ReturningDeleteBuilder

+ func (b DeleteBuilder) Using(from FromExp) FromDeleteBuilder

type Exp

+ func Args(argument any, rest ...any) []Exp

+ func Exists(subquery SelectExp) Exp

type ExpBase

+ func (b ExpBase) In(selectOrExpressions SelectOrExpressions) Exp

+ func (b ExpBase) NotIn(selectOrExpressions SelectOrExpressions) Exp

+ type FromDeleteBuilder struct

+ func (b FromDeleteBuilder) As(alias string) FromDeleteBuilder

+ func (b FromDeleteBuilder) ColumnAliases(aliases ...string) FromDeleteBuilder

+ type FromUpdateBuilder struct

+ func (b FromUpdateBuilder) As(alias string) FromUpdateBuilder

+ func (b FromUpdateBuilder) ColumnAliases(aliases ...string) FromUpdateBuilder

type InsertBuilder

+ func (b InsertBuilder) DefaultValues() InsertBuilder

+ func (b InsertBuilder) OnConflict(conflictTargets ...Exp) OnConflictInsertBuilder

+ func (b InsertBuilder) Query(query SelectExp) InsertBuilder

+ func (b InsertBuilder) Returning(outputExpression Exp) ReturningInsertBuilder

+ type OnConflictDoUpdateInsertBuilder struct

+ func (b OnConflictDoUpdateInsertBuilder) Set(columnName string, value Exp) OnConflictDoUpdateInsertBuilder

+ func (b OnConflictDoUpdateInsertBuilder) Where(cond Exp) OnConflictDoUpdateInsertBuilder

+ type OnConflictInsertBuilder struct

+ func (b OnConflictInsertBuilder) DoNothing() InsertBuilder

+ func (b OnConflictInsertBuilder) DoUpdate() OnConflictDoUpdateInsertBuilder

+ func (b OnConflictInsertBuilder) OnConstraint(constraintName string) OnConflictInsertBuilder

+ func (b OnConflictInsertBuilder) Where(cond Exp) OnConflictInsertBuilder

type Operator

+ const OpConcat

+ type ReturningDeleteBuilder struct

+ func (b ReturningDeleteBuilder) As(outputName string) DeleteBuilder

+ type ReturningInsertBuilder struct

+ func (b ReturningInsertBuilder) As(outputName string) InsertBuilder

+ type ReturningUpdateBuilder struct

+ func (b ReturningUpdateBuilder) As(outputName string) UpdateBuilder

type SelectBuilder

+ func (b SelectBuilder) AppendWith(w WithBuilder) SelectBuilder

+ func (b SelectBuilder) ApplySelectJson(apply func(obj JsonBuildObjectBuilder) JsonBuildObjectBuilder) SelectJsonSelectBuilder

+ type SelectExp interface

+ type SelectOrExpressions interface

type UpdateBuilder

+ func (b UpdateBuilder) From(from FromExp) FromUpdateBuilder

+ func (b UpdateBuilder) Returning(outputExpression Exp) ReturningUpdateBuilder

type WithBuilder

+ func (b WithBuilder) DeleteFrom(tableName string) DeleteBuilder

+ func (b WithBuilder) InsertInto(tableName string) InsertBuilder

+ func (b WithBuilder) SearchBreadthFirst() WithSearchBuilder

+ func (b WithBuilder) SearchDepthFirst() WithSearchBuilder

+ func (b WithBuilder) Select(exps ...Exp) SelectSelectBuilder

+ func (b WithBuilder) Update(tableName string) UpdateBuilder

+ func (b WithBuilder) With(queryName string) WithWithBuilder

+ func (b WithBuilder) WithRecursive(queryName string) WithWithBuilder

+ type WithWithBuilder struct

+ func With(queryName string) WithWithBuilder

+ func WithRecursive(queryName string) WithWithBuilder

+ func (b WithWithBuilder) As(query WithQuery) WithBuilder

+ func (b WithWithBuilder) AsMaterialized(builder WithQuery) WithBuilder

+ func (b WithWithBuilder) AsNotMaterialized(builder WithQuery) WithBuilder

+ func (b WithWithBuilder) ColumnNames(names ...string) WithWithBuilder

Apr 5, 2023

Changes in this version

+ var ErrFromItemLateralAndOnly = errors.New("cannot specify both LATERAL and ONLY")

+ var ErrInvalidIdentifier = errors.New("invalid identifier")

+ var ErrNoConditionsGiven = errors.New("no conditions given")

+ type AggExpBuilder struct

+ func Agg(name string, exps []Exp) AggExpBuilder

+ func (b AggExpBuilder) Distinct() AggExpBuilder

+ func (b AggExpBuilder) Filter(cond Exp) AggExpBuilder

+ func (b AggExpBuilder) IsExp()

+ func (b AggExpBuilder) OrderBy(exp Exp) OrderByAggExpBuilder

+ func (b AggExpBuilder) WithinGroup() AggExpBuilder

+ func (b AggExpBuilder) WriteSQL(sb *SQLBuilder)

+ type CaseBuilder struct

+ func Case(exp ...Exp) CaseBuilder

+ func (b CaseBuilder) Else(result Exp) CaseBuilder

+ func (b CaseBuilder) End() CaseExp

+ func (b CaseBuilder) When(condition Exp) CaseWhenBuilder

+ type CaseExp struct

+ func (c CaseExp) WriteSQL(sb *SQLBuilder)

+ type CaseWhenBuilder struct

+ func (c CaseWhenBuilder) Then(result Exp) CaseBuilder

+ type CombinationBuilder struct

+ func (b CombinationBuilder) All() CombinationBuilder

+ type DeleteBuilder struct

+ func DeleteFrom(tableName string) DeleteBuilder

+ func (b DeleteBuilder) As(alias string) DeleteBuilder

+ func (b DeleteBuilder) Where(cond Exp) DeleteBuilder

+ func (b DeleteBuilder) WriteSQL(sb *SQLBuilder)

+ type Exp interface

+ IsExp func()

+ func And(exps ...Exp) Exp

+ func Arg(argument any) Exp

+ func Array(elems ...Exp) Exp

+ func Bind(argName string) Exp

+ func Bool(b bool) Exp

+ func Default() Exp

+ func Float(f float64) Exp

+ func Int(s int) Exp

+ func Interval(spec string) Exp

+ func Not(e Exp) Exp

+ func Null() Exp

+ func Or(exps ...Exp) Exp

+ func String(s string) Exp

+ type ExpBase struct

+ func (ExpBase) IsExp()

+ func (b ExpBase) Cast(typ string) Exp

+ func (b ExpBase) Concat(rgt Exp) Exp

+ func (b ExpBase) Eq(rgt Exp) Exp

+ func (b ExpBase) Gt(rgt Exp) Exp

+ func (b ExpBase) Gte(rgt Exp) Exp

+ func (b ExpBase) ILike(rgt Exp) MatchingBuilder

+ func (b ExpBase) IsNotNull() Exp

+ func (b ExpBase) IsNull() Exp

+ func (b ExpBase) JsonContainedBy(rgt Exp) Exp

+ func (b ExpBase) JsonContains(rgt Exp) Exp

+ func (b ExpBase) JsonExtract(rgt Exp) Exp

+ func (b ExpBase) JsonExtractPath(rgt Exp) Exp

+ func (b ExpBase) JsonExtractPathText(rgt Exp) Exp

+ func (b ExpBase) JsonExtractText(rgt Exp) Exp

+ func (b ExpBase) Like(rgt Exp) MatchingBuilder

+ func (b ExpBase) Lt(rgt Exp) Exp

+ func (b ExpBase) Lte(rgt Exp) Exp

+ func (b ExpBase) Neq(rgt Exp) Exp

+ func (b ExpBase) NotILike(rgt Exp) MatchingBuilder

+ func (b ExpBase) NotLike(rgt Exp) MatchingBuilder

+ func (b ExpBase) NotSimilarTo(rgt Exp) MatchingBuilder

+ func (b ExpBase) Op(op Operator, rgt Exp) Exp

+ func (b ExpBase) SimilarTo(rgt Exp) MatchingBuilder

+ type FromExp interface

+ type FromLateralExp interface

+ type FromSelectBuilder struct

+ func (b FromSelectBuilder) As(alias string) FromSelectBuilder

+ func (b FromSelectBuilder) ColumnAliases(aliases ...string) FromSelectBuilder

+ type FuncBuilder struct

+ func Func(name string, args ...Exp) FuncBuilder

+ func (f FuncBuilder) As(alias string) FuncBuilder

+ func (f FuncBuilder) ColumnDefinition(name, typ string) FuncBuilder

+ func (f FuncBuilder) IsExp()

+ func (f FuncBuilder) WithOrdinality() FuncBuilder

+ func (f FuncBuilder) WriteSQL(sb *SQLBuilder)

+ type FuncExp struct

+ func Coalesce(exp Exp, rest ...Exp) FuncExp

+ func Greatest(exp Exp, rest ...Exp) FuncExp

+ func Least(exp Exp, rest ...Exp) FuncExp

+ func NullIf(value1, value2 Exp) FuncExp

+ func (c FuncExp) IsExp()

+ func (c FuncExp) WriteSQL(sb *SQLBuilder)

+ type GroupyBySelectBuilder struct

+ func (b GroupyBySelectBuilder) Cube(sets ...[]Exp) GroupyBySelectBuilder

+ func (b GroupyBySelectBuilder) Distinct() GroupyBySelectBuilder

+ func (b GroupyBySelectBuilder) Empty() GroupyBySelectBuilder

+ func (b GroupyBySelectBuilder) GroupingSets(sets ...[]Exp) GroupyBySelectBuilder

+ func (b GroupyBySelectBuilder) Rollup(sets ...[]Exp) GroupyBySelectBuilder

+ type IdentExp struct

+ func N(s string) IdentExp

+ func (i IdentExp) IsExp()

+ func (i IdentExp) WriteSQL(sb *SQLBuilder)

+ type InsertBuilder struct

+ func InsertInto(tableName string) InsertBuilder

+ func (b InsertBuilder) As(alias string) InsertBuilder

+ func (b InsertBuilder) ColumnNames(columnName string, rest ...string) InsertBuilder

+ func (b InsertBuilder) SetMap(m map[string]any) InsertBuilder

+ func (b InsertBuilder) Values(values ...Exp) InsertBuilder

+ func (b InsertBuilder) WriteSQL(sb *SQLBuilder)

+ type JoinSelectBuilder struct

+ func (b JoinSelectBuilder) As(alias string) JoinSelectBuilder

+ func (b JoinSelectBuilder) On(cond Exp, rest ...Exp) SelectBuilder

+ func (b JoinSelectBuilder) Using(columns ...string) SelectBuilder

+ type JsonBuildObjectBuilder struct

+ func JsonBuildObject() JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) IsExp()

+ func (b JsonBuildObjectBuilder) Prop(key string, value Exp) JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) PropIf(condition bool, key string, value Exp) JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) Start() *JsonBuildObjectBuilderBuilder

+ func (b JsonBuildObjectBuilder) Unset(key string) JsonBuildObjectBuilder

+ func (b JsonBuildObjectBuilder) WriteSQL(sb *SQLBuilder)

+ type JsonBuildObjectBuilderBuilder struct

+ func (bb *JsonBuildObjectBuilderBuilder) End() JsonBuildObjectBuilder

+ func (bb *JsonBuildObjectBuilderBuilder) Prop(key string, value Exp) *JsonBuildObjectBuilderBuilder

+ func (bb *JsonBuildObjectBuilderBuilder) PropIf(condition bool, key string, value Exp) *JsonBuildObjectBuilderBuilder

+ type MatchingBuilder interface

+ Escape func(escapeCharacter rune) MatchingBuilder

+ type Operator string

+ const OpAdd

+ const OpDiv

+ const OpMul

+ const OpRegexpIMatch

+ const OpRegexpINotMatch

+ const OpRegexpMatch

+ const OpRegexpNotMatch

+ const OpSub

+ type OrderByAggExpBuilder struct

+ func (b OrderByAggExpBuilder) Asc() OrderByAggExpBuilder

+ func (b OrderByAggExpBuilder) Desc() OrderByAggExpBuilder

+ func (b OrderByAggExpBuilder) NullsFirst() OrderByAggExpBuilder

+ func (b OrderByAggExpBuilder) NullsLast() OrderByAggExpBuilder

+ type OrderBySelectBuilder struct

+ func (b OrderBySelectBuilder) Asc() OrderBySelectBuilder

+ func (b OrderBySelectBuilder) Desc() OrderBySelectBuilder

+ func (b OrderBySelectBuilder) NullsFirst() OrderBySelectBuilder

+ func (b OrderBySelectBuilder) NullsLast() OrderBySelectBuilder

+ type QueryBuilder struct

+ func Build(builder SQLWriter) *QueryBuilder

+ func (b *QueryBuilder) ToSQL() (sql string, args []any, err error)

+ func (b *QueryBuilder) WithNamedArgs(args map[string]any) *QueryBuilder

+ func (b *QueryBuilder) WithoutValidation() *QueryBuilder

+ type RowsFromBuilder struct

+ func NewRowsFromBuilder(fns ...FuncBuilder) RowsFromBuilder

+ func (r RowsFromBuilder) WithOrdinality() RowsFromBuilder

+ func (r RowsFromBuilder) WriteSQL(sb *SQLBuilder)

+ type SQLBuilder struct

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

+ func (b *SQLBuilder) BindPlaceholder(name string) string

+ func (b *SQLBuilder) CreatePlaceholder(argument any) string

+ func (b *SQLBuilder) Validating() bool

+ func (b *SQLBuilder) WriteRune(r rune)

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

+ type SQLWriter interface

+ WriteSQL func(sb *SQLBuilder)

+ type SelectBuilder struct

+ func (b SelectBuilder) ApplyIf(cond bool, f func(q SelectBuilder) SelectBuilder) SelectBuilder

+ func (b SelectBuilder) Except() CombinationBuilder

+ func (b SelectBuilder) From(from FromExp) FromSelectBuilder

+ func (b SelectBuilder) FromLateral(from FromLateralExp) FromSelectBuilder

+ func (b SelectBuilder) FromOnly(from FromExp) FromSelectBuilder

+ func (b SelectBuilder) FullJoin(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) GroupBy(exps ...Exp) GroupyBySelectBuilder

+ func (b SelectBuilder) Having(cond Exp) SelectBuilder

+ func (b SelectBuilder) Intersect() CombinationBuilder

+ func (b SelectBuilder) IsExp()

+ func (b SelectBuilder) Join(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) JoinLateral(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) LeftJoin(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) LeftJoinLateral(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) Limit(exp Exp) SelectBuilder

+ func (b SelectBuilder) Offset(exp Exp) SelectBuilder

+ func (b SelectBuilder) OrderBy(exp Exp) OrderBySelectBuilder

+ func (b SelectBuilder) RightJoin(from FromExp) JoinSelectBuilder

+ func (b SelectBuilder) Select(exps ...Exp) SelectSelectBuilder

+ func (b SelectBuilder) SelectJson(apply func(obj JsonBuildObjectBuilder) JsonBuildObjectBuilder) SelectJsonSelectBuilder

+ func (b SelectBuilder) Union() CombinationBuilder

+ func (b SelectBuilder) Where(cond Exp) SelectBuilder

+ func (b SelectBuilder) With(queryName string) WithBuilder

+ func (b SelectBuilder) WithRecursive(queryName string) WithBuilder

+ func (b SelectBuilder) WriteSQL(sb *SQLBuilder)

+ type SelectDistinctBuilder struct

+ func (b SelectDistinctBuilder) On(exp Exp, exps ...Exp) SelectBuilder

+ type SelectJsonSelectBuilder struct

+ func (b SelectJsonSelectBuilder) As(alias string) SelectJsonSelectBuilder

+ type SelectSelectBuilder struct

+ func (b SelectSelectBuilder) As(alias string) SelectSelectBuilder

+ func (b SelectSelectBuilder) Distinct() SelectDistinctBuilder

+ type UpdateBuilder struct

+ func Update(tableName string) UpdateBuilder

+ func (b UpdateBuilder) As(alias string) UpdateBuilder

+ func (b UpdateBuilder) Set(columnName string, value Exp) UpdateBuilder

+ func (b UpdateBuilder) SetMap(m map[string]any) UpdateBuilder

+ func (b UpdateBuilder) Where(cond Exp) UpdateBuilder

+ func (b UpdateBuilder) WriteSQL(sb *SQLBuilder)

+ type WithBuilder struct

+ func (b WithBuilder) As(builder WithQuery) WithSelectBuilder

+ func (b WithBuilder) AsMaterialized(builder WithQuery) WithSelectBuilder

+ func (b WithBuilder) AsNotMaterialized(builder WithQuery) WithSelectBuilder

+ func (b WithBuilder) ColumnNames(names ...string) WithBuilder

+ type WithQuery interface

+ type WithSearchBuilder struct

+ func (b WithSearchBuilder) By(columnName Exp, columnNames ...Exp) WithSearchByBuilder

+ type WithSearchByBuilder struct

+ func (b WithSearchByBuilder) Set(searchColumnName string) WithSelectBuilder

+ type WithSelectBuilder struct

+ func (b WithSelectBuilder) SearchBreadthFirst() WithSearchBuilder

+ func (b WithSelectBuilder) SearchDepthFirst() WithSearchBuilder