sm

package
v0.11.6 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 12, 2024 License: MIT Imports: 6 Imported by: 2

Documentation

Overview

Code generated by "litsql-dialectgen"; DO NOT EDIT.

Code generated by "litsql-dialectgen"; DO NOT EDIT.

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Apply added in v0.4.2 

func Apply(f func(a psql.SelectModApply)) psql.SelectMod

func Columns 

func Columns(names ...string) psql.SelectMod

Columns adds column names to SELECT queries.

func ColumnsClause added in v0.8.0 

func ColumnsClause(query string, args ...any) psql.SelectMod

ColumnsClause adds column names to SELECT queries.

func ColumnsExpr added in v0.8.0 

func ColumnsExpr(names ...litsql.Expression) psql.SelectMod

ColumnsExpr adds column names to SELECT queries.

func Distinct 

func Distinct(on ...string) psql.SelectMod

func DistinctExpr added in v0.8.0 

func DistinctExpr(on ...litsql.Expression) psql.SelectMod

func Except 

func Except(q psql.SelectQuery) psql.SelectMod

func ExceptAll 

func ExceptAll(q psql.SelectQuery) psql.SelectMod

func Having 

func Having(condition string) psql.SelectMod

func HavingClause added in v0.8.0 

func HavingClause(query string, args ...any) psql.SelectMod

func HavingExpr added in v0.8.0 

func HavingExpr(condition litsql.Expression) psql.SelectMod

func Intersect 

func Intersect(q psql.SelectQuery) psql.SelectMod

func IntersectAll 

func IntersectAll(q psql.SelectQuery) psql.SelectMod

func Limit 

func Limit(count int) psql.SelectMod

func LimitArg added in v0.8.0 

func LimitArg(arg any) psql.SelectMod

func LimitArgNamed added in v0.8.0 

func LimitArgNamed(argumentName string) psql.SelectMod

func LimitExpr added in v0.8.0 

func LimitExpr(count litsql.Expression) psql.SelectMod

func Offset 

func Offset(count int) psql.SelectMod

func OffsetArg added in v0.8.0 

func OffsetArg(arg any) psql.SelectMod

func OffsetArgNamed added in v0.8.0 

func OffsetArgNamed(argumentName string) psql.SelectMod

func OffsetExpr added in v0.8.0 

func OffsetExpr(count litsql.Expression) psql.SelectMod

func OrderBy 

func OrderBy(names ...string) psql.SelectMod

func OrderByExpr added in v0.8.0 

func OrderByExpr(names ...litsql.Expression) psql.SelectMod

func Union 

func Union(q psql.SelectQuery) psql.SelectMod

func UnionAll 

func UnionAll(q psql.SelectQuery) psql.SelectMod

func Where 

func Where(condition string) psql.SelectMod

func WhereClause added in v0.8.0 

func WhereClause(query string, args ...any) psql.SelectMod

func WhereExpr added in v0.8.0 

func WhereExpr(condition litsql.Expression) psql.SelectMod

Types

type FromChain 

type FromChain interface {
	sq.QueryMod[tag.SelectTag]
	As(alias string, columns ...string) FromChain
	Only() FromChain
	Lateral() FromChain
	WithOrdinality() FromChain
}

func From 

func From(table string) FromChain

func FromExpr added in v0.8.0 

func FromExpr(table litsql.Expression) FromChain

func FromQuery added in v0.8.0 

func FromQuery(q psql.SelectQuery) FromChain

type GroupByChain 

type GroupByChain interface {
	sq.QueryMod[tag.SelectTag]
	Distinct() GroupByChain
}

func GroupBy 

func GroupBy(columns ...string) GroupByChain

func GroupByExpr added in v0.8.0 

func GroupByExpr(columns ...litsql.Expression) GroupByChain

type JoinChain 

type JoinChain interface {
	sq.QueryMod[tag.SelectTag]
	As(alias string, columns ...string) JoinChain
	Only() JoinChain
	Lateral() JoinChain
	WithOrdinality() JoinChain
	Natural() JoinChain
	On(on string) JoinChain
	OnExpr(on litsql.Expression) JoinChain
	OnClause(query string, args ...any) JoinChain
	Using(using ...string) JoinChain
}

func CrossJoin 

func CrossJoin(table string) JoinChain

func CrossJoinExpr added in v0.8.0 

func CrossJoinExpr(table litsql.Expression) JoinChain

func FullJoin 

func FullJoin(table string) JoinChain

func FullJoinExpr added in v0.8.0 

func FullJoinExpr(table litsql.Expression) JoinChain

func InnerJoin 

func InnerJoin(table string) JoinChain

func InnerJoinExpr added in v0.8.0 

func InnerJoinExpr(table litsql.Expression) JoinChain

func LeftJoin 

func LeftJoin(table string) JoinChain

func LeftJoinExpr added in v0.8.0 

func LeftJoinExpr(table litsql.Expression) JoinChain

func RightJoin 

func RightJoin(table string) JoinChain

func RightJoinExpr added in v0.8.0 

func RightJoinExpr(table litsql.Expression) JoinChain

func StraightJoin 

func StraightJoin(table string) JoinChain

func StraightJoinExpr added in v0.8.0 

func StraightJoinExpr(table litsql.Expression) JoinChain

type WindowChain 

type WindowChain interface {
	sq.QueryMod[tag.SelectTag]
	From(name string) WindowChain
	PartitionBy(condition ...string) WindowChain
	PartitionByExpr(condition ...litsql.Expression) WindowChain
	OrderBy(order ...string) WindowChain
	OrderByExpr(order ...litsql.Expression) WindowChain
	Range() WindowChain
	Rows() WindowChain
	Groups() WindowChain
	FromUnboundedPreceding() WindowChain
	FromPreceding(exp litsql.Expression) WindowChain
	FromCurrentRow() WindowChain
	FromFollowing(exp litsql.Expression) WindowChain
	ToPreceding(exp litsql.Expression) WindowChain
	ToCurrentRow(count int) WindowChain
	ToFollowing(exp litsql.Expression) WindowChain
	ToUnboundedFollowing() WindowChain
	ExcludeNoOthers() WindowChain
	ExcludeCurrentRow() WindowChain
	ExcludeGroup() WindowChain
	ExcludeTies() WindowChain
}

func Window 

func Window(name string) WindowChain

type WithChain 

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

func With 

func With(name string, columns ...string) WithChain

func WithExpr added in v0.8.0 

func WithExpr(name string, columns ...litsql.Expression) WithChain

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.