chain

Documentation

Index

• type From
• type GroupBy
• type InsertConflict
• type Join
• type Window
• type With

Types

type From

type From[T any] interface {
	sq.QueryMod[T]
	As(alias string, columns ...string) From[T]
	Only() From[T]
	Lateral() From[T]
	WithOrdinality() From[T]
}

type GroupBy

type GroupBy[T any] interface {
	sq.QueryMod[T]
	Distinct() GroupBy[T]
	With(with string) GroupBy[T]
}

type InsertConflict

type InsertConflict[T, UM any] interface {
	sq.QueryMod[T]
	Where(condition string) InsertConflict[T, UM]
	WhereE(condition litsql.Expression) InsertConflict[T, UM]
	WhereC(query string, args ...any) InsertConflict[T, UM]
	DoNothing() InsertConflict[T, UM]
	DoUpdate(mods ...mod.InsertConflictUpdateMod[T, UM]) InsertConflict[T, UM]
}

type Join

type Join[T any] interface {
	sq.QueryMod[T]
	As(alias string, columns ...string) Join[T]
	Only() Join[T]
	Lateral() Join[T]
	WithOrdinality() Join[T]
	Natural() sq.QueryMod[T]
	On(on string) Join[T]
	OnE(on litsql.Expression) Join[T]
	OnC(query string, args ...any) Join[T]
	Using(using ...string) Join[T]
}

type Window

type Window[T any] interface {
	sq.QueryMod[T]
	From(name string) Window[T]
	PartitionBy(condition ...string) Window[T]
	PartitionByE(condition ...litsql.Expression) Window[T]
	OrderBy(order ...string) Window[T]
	OrderByE(order ...litsql.Expression) Window[T]
	Range() Window[T]
	Rows() Window[T]
	Groups() Window[T]
	FromUnboundedPreceding() Window[T]
	FromPreceding(exp litsql.Expression) Window[T]
	FromCurrentRow() Window[T]
	FromFollowing(exp litsql.Expression) Window[T]
	ToPreceding(exp litsql.Expression) Window[T]
	ToCurrentRow(count int) Window[T]
	ToFollowing(exp litsql.Expression) Window[T]
	ToUnboundedFollowing() Window[T]
	ExcludeNoOthers() Window[T]
	ExcludeCurrentRow() Window[T]
	ExcludeGroup() Window[T]
	ExcludeTies() Window[T]
}

type With

type With[T any] interface {
	sq.QueryMod[T]
	Recursive() With[T]
	As(q litsql.Query) With[T]
	NotMaterialized() With[T]
	Materialized() With[T]
	SearchBreadth(setCol string, searchCols ...string) With[T]
	SearchDepth(setCol string, searchCols ...string) With[T]
	Cycle(set, using string, cols ...string) With[T]
	CycleValue(value, defaultVal any) With[T]
}