sm

Documentation

Index

• func Columns(clauses ...any) bob.Mod[*dialect.SelectQuery]
• func CrossJoin(e any) bob.Mod[*dialect.SelectQuery]
• func Distinct(on ...any) bob.Mod[*dialect.SelectQuery]
• func Except(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func ExceptAll(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func Fetch(count int64, withTies bool) bob.Mod[*dialect.SelectQuery]
• func ForKeyShare(tables ...string) dialect.LockChain[*dialect.SelectQuery]
• func ForNoKeyUpdate(tables ...string) dialect.LockChain[*dialect.SelectQuery]
• func ForShare(tables ...string) dialect.LockChain[*dialect.SelectQuery]
• func ForUpdate(tables ...string) dialect.LockChain[*dialect.SelectQuery]
• func From(table any) dialect.FromChain[*dialect.SelectQuery]
• func FromFunction(funcs ...*dialect.Function) dialect.FromChain[*dialect.SelectQuery]
• func FullJoin(e any) dialect.JoinChain[*dialect.SelectQuery]
• func GroupBy(e any) bob.Mod[*dialect.SelectQuery]
• func GroupByDistinct(distinct bool) bob.Mod[*dialect.SelectQuery]
• func Having(e any) bob.Mod[*dialect.SelectQuery]
• func InnerJoin(e any) dialect.JoinChain[*dialect.SelectQuery]
• func Intersect(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func IntersectAll(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func LeftJoin(e any) dialect.JoinChain[*dialect.SelectQuery]
• func Limit(count int64) bob.Mod[*dialect.SelectQuery]
• func Offset(count int64) bob.Mod[*dialect.SelectQuery]
• func OrderBy(e any) dialect.OrderBy[*dialect.SelectQuery]
• func Recursive(r bool) bob.Mod[*dialect.SelectQuery]
• func RightJoin(e any) dialect.JoinChain[*dialect.SelectQuery]
• func Union(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func UnionAll(q bob.Query) bob.Mod[*dialect.SelectQuery]
• func Where(e any) bob.Mod[*dialect.SelectQuery]
• func Window(name string) dialect.WindowMod[*dialect.SelectQuery]
• func With(name string, columns ...string) dialect.CTEChain[*dialect.SelectQuery]

Functions

func Columns

func Columns(clauses ...any) bob.Mod[*dialect.SelectQuery]

func CrossJoin

func CrossJoin(e any) bob.Mod[*dialect.SelectQuery]

func Distinct

func Distinct(on ...any) bob.Mod[*dialect.SelectQuery]

func Except

func Except(q bob.Query) bob.Mod[*dialect.SelectQuery]

func ExceptAll

func ExceptAll(q bob.Query) bob.Mod[*dialect.SelectQuery]

func Fetch

func Fetch(count int64, withTies bool) bob.Mod[*dialect.SelectQuery]

func ForKeyShare

func ForKeyShare(tables ...string) dialect.LockChain[*dialect.SelectQuery]

func ForNoKeyUpdate

func ForNoKeyUpdate(tables ...string) dialect.LockChain[*dialect.SelectQuery]

func ForShare

func ForShare(tables ...string) dialect.LockChain[*dialect.SelectQuery]

func ForUpdate

func ForUpdate(tables ...string) dialect.LockChain[*dialect.SelectQuery]

func From

func From(table any) dialect.FromChain[*dialect.SelectQuery]

func FromFunction

func FromFunction(funcs ...*dialect.Function) dialect.FromChain[*dialect.SelectQuery]

func FullJoin

func FullJoin(e any) dialect.JoinChain[*dialect.SelectQuery]

func GroupBy

func GroupBy(e any) bob.Mod[*dialect.SelectQuery]

func GroupByDistinct

func GroupByDistinct(distinct bool) bob.Mod[*dialect.SelectQuery]

func Having

func Having(e any) bob.Mod[*dialect.SelectQuery]

func InnerJoin

func InnerJoin(e any) dialect.JoinChain[*dialect.SelectQuery]

func Intersect

func Intersect(q bob.Query) bob.Mod[*dialect.SelectQuery]

func IntersectAll

func IntersectAll(q bob.Query) bob.Mod[*dialect.SelectQuery]

func LeftJoin

func LeftJoin(e any) dialect.JoinChain[*dialect.SelectQuery]

func Limit

func Limit(count int64) bob.Mod[*dialect.SelectQuery]

func Offset

func Offset(count int64) bob.Mod[*dialect.SelectQuery]

func OrderBy

func OrderBy(e any) dialect.OrderBy[*dialect.SelectQuery]

func Recursive

func Recursive(r bool) bob.Mod[*dialect.SelectQuery]

func RightJoin

func RightJoin(e any) dialect.JoinChain[*dialect.SelectQuery]

func Union

func Union(q bob.Query) bob.Mod[*dialect.SelectQuery]

func UnionAll

func UnionAll(q bob.Query) bob.Mod[*dialect.SelectQuery]

func Where

func Where(e any) bob.Mod[*dialect.SelectQuery]

func Window

func Window(name string) dialect.WindowMod[*dialect.SelectQuery]

func With

func With(name string, columns ...string) dialect.CTEChain[*dialect.SelectQuery]