sm

Documentation

Index

• func Columns(names ...string) sqlite.SelectMod
• func ColumnsE(names ...litsql.Expression) sqlite.SelectMod
• func Distinct(on ...string) sqlite.SelectMod
• func DistinctE(on ...litsql.Expression) sqlite.SelectMod
• func Except(q sqlite.SelectQuery) sqlite.SelectMod
• func ExceptAll(q sqlite.SelectQuery) sqlite.SelectMod
• func Func(f func(a sqlite.SelectModApply)) sqlite.SelectMod
• func Having(condition string) sqlite.SelectMod
• func HavingC(query string, args ...any) sqlite.SelectMod
• func HavingE(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 LimitA(arg any) sqlite.SelectMod
• func LimitE(count litsql.Expression) sqlite.SelectMod
• func Offset(count int) sqlite.SelectMod
• func OffsetA(arg any) sqlite.SelectMod
• func OffsetE(count litsql.Expression) sqlite.SelectMod
• func OrderBy(names ...string) sqlite.SelectMod
• func OrderByE(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 WhereC(query string, args ...any) sqlite.SelectMod
• func WhereE(condition litsql.Expression) sqlite.SelectMod
• type FromChain
  • func From(table string) FromChain
  • func FromE(table litsql.Expression) FromChain
  • func FromQ(q sqlite.SelectQuery) FromChain
• type GroupByChain
  • func GroupBy(columns ...string) GroupByChain
  • func GroupByE(columns ...litsql.Expression) GroupByChain
• type JoinChain
  • func CrossJoin(table string) JoinChain
  • func CrossJoinE(table litsql.Expression) JoinChain
  • func FullJoin(table string) JoinChain
  • func FullJoinE(table litsql.Expression) JoinChain
  • func InnerJoin(table string) JoinChain
  • func InnerJoinE(table litsql.Expression) JoinChain
  • func LeftJoin(table string) JoinChain
  • func LeftJoinE(table litsql.Expression) JoinChain
  • func RightJoin(table string) JoinChain
  • func RightJoinE(table litsql.Expression) JoinChain
  • func StraightJoin(table string) JoinChain
  • func StraightJoinE(table litsql.Expression) JoinChain
• type WindowChain
  • func Window(name string) WindowChain
• type WithChain
  • func With(name string, columns ...string) WithChain
  • func WithE(name string, columns ...litsql.Expression) WithChain

Functions

func Columns

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

func ColumnsE

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

func Distinct

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

func DistinctE

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

func Except

func Except(q sqlite.SelectQuery) sqlite.SelectMod

func ExceptAll

func ExceptAll(q sqlite.SelectQuery) sqlite.SelectMod

func Func

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

func Having

func Having(condition string) sqlite.SelectMod

func HavingC

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

func HavingE

func HavingE(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 LimitA

func LimitA(arg any) sqlite.SelectMod

func LimitE

func LimitE(count litsql.Expression) sqlite.SelectMod

func Offset

func Offset(count int) sqlite.SelectMod

func OffsetA

func OffsetA(arg any) sqlite.SelectMod

func OffsetE

func OffsetE(count litsql.Expression) sqlite.SelectMod

func OrderBy

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

func OrderByE

func OrderByE(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 WhereC

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

func WhereE

func WhereE(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 FromE

func FromE(table litsql.Expression) FromChain

func FromQ

func FromQ(q sqlite.SelectQuery) FromChain

type GroupByChain

type GroupByChain = chain.GroupBy[tag.SelectTag]

func GroupBy

func GroupBy(columns ...string) GroupByChain

func GroupByE

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

type JoinChain

type JoinChain = chain.Join[tag.SelectTag]

func CrossJoin

func CrossJoin(table string) JoinChain

func CrossJoinE

func CrossJoinE(table litsql.Expression) JoinChain

func FullJoin

func FullJoin(table string) JoinChain

func FullJoinE

func FullJoinE(table litsql.Expression) JoinChain

func InnerJoin

func InnerJoin(table string) JoinChain

func InnerJoinE

func InnerJoinE(table litsql.Expression) JoinChain

func LeftJoin

func LeftJoin(table string) JoinChain

func LeftJoinE

func LeftJoinE(table litsql.Expression) JoinChain

func RightJoin

func RightJoin(table string) JoinChain

func RightJoinE

func RightJoinE(table litsql.Expression) JoinChain

func StraightJoin

func StraightJoin(table string) JoinChain

func StraightJoinE

func StraightJoinE(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 WithE

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