sm

Documentation

Index

• func Apply(f func(a sqlite.SelectModApply)) sqlite.SelectMod
• func Columns(names ...string) sqlite.SelectMod
• func ColumnsClause(query string, args ...any) sqlite.SelectMod
• func ColumnsExpr(names ...litsql.Expression) sqlite.SelectMod
• func Distinct(on ...string) sqlite.SelectMod
• func DistinctExpr(on ...litsql.Expression) sqlite.SelectMod
• func Except(q sqlite.SelectQuery) sqlite.SelectMod
• func ExceptAll(q sqlite.SelectQuery) sqlite.SelectMod
• func Having(condition string) sqlite.SelectMod
• func HavingClause(query string, args ...any) sqlite.SelectMod
• func HavingExpr(condition litsql.Expression) sqlite.SelectMod
• func Intersect(q sqlite.SelectQuery) sqlite.SelectMod
• func IntersectAll(q sqlite.SelectQuery) sqlite.SelectMod
• func Limit(count int) sqlite.SelectMod
• func LimitArg(arg any) sqlite.SelectMod
• func LimitArgNamed(argumentName string) sqlite.SelectMod
• func LimitExpr(count litsql.Expression) sqlite.SelectMod
• func Offset(count int) sqlite.SelectMod
• func OffsetArg(arg any) sqlite.SelectMod
• func OffsetArgNamed(argumentName string) sqlite.SelectMod
• func OffsetExpr(count litsql.Expression) sqlite.SelectMod
• func OrderBy(names ...string) sqlite.SelectMod
• func OrderByExpr(names ...litsql.Expression) sqlite.SelectMod
• func Union(q sqlite.SelectQuery) sqlite.SelectMod
• func UnionAll(q sqlite.SelectQuery) sqlite.SelectMod
• func Where(condition string) sqlite.SelectMod
• func WhereClause(query string, args ...any) sqlite.SelectMod
• func WhereExpr(condition litsql.Expression) sqlite.SelectMod
• type FromChain
  • func From(table string) FromChain
  • func FromExpr(table litsql.Expression) FromChain
  • func FromQuery(q sqlite.SelectQuery) FromChain
• type GroupByChain
  • func GroupBy(columns ...string) GroupByChain
  • func GroupByExpr(columns ...litsql.Expression) GroupByChain
• type JoinChain
  • func CrossJoin(table string) JoinChain
  • func CrossJoinExpr(table litsql.Expression) JoinChain
  • func FullJoin(table string) JoinChain
  • func FullJoinExpr(table litsql.Expression) JoinChain
  • func InnerJoin(table string) JoinChain
  • func InnerJoinExpr(table litsql.Expression) JoinChain
  • func LeftJoin(table string) JoinChain
  • func LeftJoinExpr(table litsql.Expression) JoinChain
  • func RightJoin(table string) JoinChain
  • func RightJoinExpr(table litsql.Expression) JoinChain
  • func StraightJoin(table string) JoinChain
  • func StraightJoinExpr(table litsql.Expression) JoinChain
• type WindowChain
  • func Window(name string) WindowChain
• type WithChain
  • func With(name string, columns ...string) WithChain
  • func WithExpr(name string, columns ...litsql.Expression) WithChain

Functions

func Apply

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

func Columns

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

func ColumnsClause

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

func ColumnsExpr

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

func Distinct

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

func DistinctExpr

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

func Except

func Except(q sqlite.SelectQuery) sqlite.SelectMod

func ExceptAll

func ExceptAll(q sqlite.SelectQuery) sqlite.SelectMod

func Having

func Having(condition string) sqlite.SelectMod

func HavingClause

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

func HavingExpr

func HavingExpr(condition litsql.Expression) sqlite.SelectMod

func Intersect

func Intersect(q sqlite.SelectQuery) sqlite.SelectMod

func IntersectAll

func IntersectAll(q sqlite.SelectQuery) sqlite.SelectMod

func Limit

func Limit(count int) sqlite.SelectMod

func LimitArg

func LimitArg(arg any) sqlite.SelectMod

func LimitArgNamed

func LimitArgNamed(argumentName string) sqlite.SelectMod

func LimitExpr

func LimitExpr(count litsql.Expression) sqlite.SelectMod

func Offset

func Offset(count int) sqlite.SelectMod

func OffsetArg

func OffsetArg(arg any) sqlite.SelectMod

func OffsetArgNamed

func OffsetArgNamed(argumentName string) sqlite.SelectMod

func OffsetExpr

func OffsetExpr(count litsql.Expression) sqlite.SelectMod

func OrderBy

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

func OrderByExpr

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

func Union

func Union(q sqlite.SelectQuery) sqlite.SelectMod

func UnionAll

func UnionAll(q sqlite.SelectQuery) sqlite.SelectMod

func Where

func Where(condition string) sqlite.SelectMod

func WhereClause

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

func WhereExpr

func WhereExpr(condition litsql.Expression) sqlite.SelectMod

Types

type FromChain

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

func From

func From(table string) FromChain

func FromExpr

func FromExpr(table litsql.Expression) FromChain

func FromQuery

func FromQuery(q sqlite.SelectQuery) FromChain

type GroupByChain

type GroupByChain = chain.GroupBy[tag.SelectTag]

func GroupBy

func GroupBy(columns ...string) GroupByChain

func GroupByExpr

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

type JoinChain

type JoinChain = chain.Join[tag.SelectTag]

func CrossJoin

func CrossJoin(table string) JoinChain

func CrossJoinExpr

func CrossJoinExpr(table litsql.Expression) JoinChain

func FullJoin

func FullJoin(table string) JoinChain

func FullJoinExpr

func FullJoinExpr(table litsql.Expression) JoinChain

func InnerJoin

func InnerJoin(table string) JoinChain

func InnerJoinExpr

func InnerJoinExpr(table litsql.Expression) JoinChain

func LeftJoin

func LeftJoin(table string) JoinChain

func LeftJoinExpr

func LeftJoinExpr(table litsql.Expression) JoinChain

func RightJoin

func RightJoin(table string) JoinChain

func RightJoinExpr

func RightJoinExpr(table litsql.Expression) JoinChain

func StraightJoin

func StraightJoin(table string) JoinChain

func StraightJoinExpr

func StraightJoinExpr(table litsql.Expression) JoinChain

type WindowChain

type WindowChain = chain.Window[tag.SelectTag]

func Window

func Window(name string) WindowChain

type WithChain

type WithChain = chain.With[tag.SelectTag]

func With

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

func WithExpr

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