iclause

Jun 12, 2024

Changes in this version

type WindowDef

+ Frame litsql.Expression

+ func (wd *WindowDef) SetFrame(frame litsql.Expression)

Jun 11, 2024

Changes in this version

type InsertConflictUpdate

+ func (c *InsertConflictUpdate) SetSet(assignment litsql.Expression)

+ type InsertDuplicateKey struct

+ Set Set

+ func (c *InsertDuplicateKey) ClauseID() string

+ func (c *InsertDuplicateKey) ClauseMerge(other litsql.QueryClause) error

+ func (c *InsertDuplicateKey) ClauseOrder() int

+ func (c *InsertDuplicateKey) SetSet(assignment litsql.Expression)

+ func (c *InsertDuplicateKey) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

type Set

+ SkipClause bool

Jun 10, 2024

Changes in this version

+ type InsertConflictUpdate struct

+ Do string

+ Set Set

+ Target InsertConflictTarget

+ Where Where

+ func (c *InsertConflictUpdate) ClauseID() string

+ func (c *InsertConflictUpdate) ClauseOrder() int

+ func (c *InsertConflictUpdate) SetDoNothing()

+ func (c *InsertConflictUpdate) SetDoUpdate()

+ func (c *InsertConflictUpdate) SetWhere(condition litsql.Expression)

+ func (c *InsertConflictUpdate) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

Jun 7, 2024

Changes in this version

+ type RawQuery struct

+ Args []any

+ Query litsql.Expression

+ func (c *RawQuery) ClauseID() string

+ func (c *RawQuery) ClauseOrder() int

+ func (c *RawQuery) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

Jun 7, 2024

Changes in this version

type Join

+ func (c *Join) SetOnClause(query string, args ...any)

+ func (c *Join) SetOnExpr(on litsql.Expression)

Jun 2, 2024

Changes in this version

type From

+ AliasColumns []string

type WindowDef

+ OrderBy []litsql.Expression

+ PartitionBy []litsql.Expression

Jun 1, 2024

Changes in this version

type Columns

+ func (c *Columns) ClauseID() string

type Combine

+ func (c *Combine) ClauseID() string

type DeleteFrom

+ func (c *DeleteFrom) ClauseID() string

type DeleteOnly

+ func (c *DeleteOnly) ClauseID() string

type Distinct

+ func (c *Distinct) ClauseID() string

type From

+ func (c *From) ClauseID() string

type GroupBy

+ func (c *GroupBy) ClauseID() string

type Having

+ func (c *Having) ClauseID() string

type InsertConflict

+ func (c *InsertConflict) ClauseID() string

type InsertOverriding

+ func (c *InsertOverriding) ClauseID() string

type Join

+ func (c *Join) ClauseID() string

type Limit

+ func (c *Limit) ClauseID() string

type Offset

+ func (c *Offset) ClauseID() string

type OrderBy

+ func (c *OrderBy) ClauseID() string

type Returning

+ func (c *Returning) ClauseID() string

type Set

+ func (c *Set) ClauseID() string

type Table

+ func (c *Table) ClauseID() string

type UpdateOnly

+ func (c *UpdateOnly) ClauseID() string

type Values

+ func (c *Values) ClauseID() string

type Where

+ func (c *Where) ClauseID() string

type Windows

+ func (c *Windows) ClauseID() string

type With

+ func (c *With) ClauseID() string

Jun 1, 2024

Changes in this version

+ const Except

+ const Intersect

+ const SearchBreadth

+ const SearchDepth

+ const Union

+ var ErrNoCombinationStrategy = errors.New("Combination strategy must be set")

+ type CTE struct

+ Columns []litsql.Expression

+ Cycle CTECycle

+ Materialized *bool

+ Name string

+ Query litsql.Query

+ Search CTESearch

+ func (c *CTE) SetMaterialized()

+ func (c *CTE) SetNotMaterialized()

+ func (c *CTE) SetQuery(q litsql.Query)

+ func (c *CTE) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type CTECycle struct

+ Columns []string

+ DefaultVal litsql.Expression

+ Set string

+ SetVal litsql.Expression

+ Using string

+ func (c *CTECycle) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type CTESearch struct

+ Columns []string

+ Order string

+ Set string

+ func (c *CTESearch) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Columns struct

+ Columns []litsql.Expression

+ func (c *Columns) ClauseMerge(other litsql.QueryClause)

+ func (c *Columns) ClauseOrder() int

+ func (c *Columns) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Combine struct

+ All bool

+ Query litsql.Query

+ Strategy string

+ func (s *Combine) ClauseMultiple()

+ func (s *Combine) ClauseOrder() int

+ func (s *Combine) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type DeleteFrom struct

+ Table string

+ func (c *DeleteFrom) ClauseOrder() int

+ func (c *DeleteFrom) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type DeleteOnly struct

+ Only bool

+ func (c *DeleteOnly) ClauseOrder() int

+ func (c *DeleteOnly) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Distinct struct

+ On []litsql.Expression

+ func (c *Distinct) ClauseMerge(other litsql.QueryClause)

+ func (c *Distinct) ClauseOrder() int

+ func (c *Distinct) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Frame struct

+ Defined bool

+ End litsql.Expression

+ Exclusion string

+ Mode string

+ Start litsql.Expression

+ func (f *Frame) SetEnd(end litsql.Expression)

+ func (f *Frame) SetExclusion(excl string)

+ func (f *Frame) SetMode(mode string)

+ func (f *Frame) SetStart(start litsql.Expression)

+ func (f *Frame) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type From struct

+ Alias string

+ Clause string

+ Columns []string

+ Lateral bool

+ Only bool

+ Starter bool

+ Table litsql.Expression

+ WithOrdinality bool

+ func (c *From) ClauseOrder() int

+ func (c *From) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ func (f *From) SetAs(alias string, columns ...string)

+ func (f *From) SetLateral()

+ func (f *From) SetOnly()

+ func (f *From) SetWithOrdinality()

+ type GroupBy struct

+ Distinct bool

+ Groups []litsql.Expression

+ With string

+ func (c *GroupBy) ClauseMerge(other litsql.QueryClause)

+ func (c *GroupBy) ClauseOrder() int

+ func (g *GroupBy) SetGroupByDistinct(distinct bool)

+ func (g *GroupBy) SetGroupWith(with string)

+ func (g *GroupBy) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Having struct

+ Conditions []litsql.Expression

+ func (c *Having) ClauseMerge(other litsql.QueryClause)

+ func (c *Having) ClauseOrder() int

+ func (c *Having) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type InsertConflict struct

+ Do string

+ Set Set

+ Target InsertConflictTarget

+ Where Where

+ func (c *InsertConflict) ClauseOrder() int

+ func (c *InsertConflict) SetDoNothing()

+ func (c *InsertConflict) SetDoUpdate()

+ func (c *InsertConflict) SetWhere(condition litsql.Expression)

+ func (c InsertConflict) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type InsertConflictTarget struct

+ Columns []string

+ Constraint string

+ Where []litsql.Expression

+ func (c *InsertConflictTarget) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type InsertOverriding struct

+ Overriding string

+ func (c *InsertOverriding) ClauseOrder() int

+ func (c *InsertOverriding) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Join struct

+ Natural bool

+ On []litsql.Expression

+ To *From

+ Type string

+ Using []string

+ func (c *Join) ClauseMultiple()

+ func (c *Join) ClauseOrder() int

+ func (c *Join) SetNatural()

+ func (c *Join) SetOn(on string)

+ func (c *Join) SetOnC(query string, args ...any)

+ func (c *Join) SetOnE(on litsql.Expression)

+ func (c *Join) SetUsing(using ...string)

+ func (c *Join) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Limit struct

+ Count litsql.Expression

+ func (c *Limit) ClauseOrder() int

+ func (c *Limit) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type NamedWindow struct

+ Definition WindowDef

+ Name string

+ func (n NamedWindow) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Offset struct

+ Count litsql.Expression

+ func (c *Offset) ClauseOrder() int

+ func (c *Offset) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type OrderBy struct

+ Expressions []litsql.Expression

+ func (c *OrderBy) ClauseMerge(other litsql.QueryClause)

+ func (c *OrderBy) ClauseOrder() int

+ func (c *OrderBy) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Returning struct

+ Expressions []litsql.Expression

+ func (c *Returning) ClauseMerge(other litsql.QueryClause)

+ func (c *Returning) ClauseOrder() int

+ func (c *Returning) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Set struct

+ Set []litsql.Expression

+ Starter bool

+ func (c *Set) ClauseMerge(other litsql.QueryClause)

+ func (c *Set) ClauseOrder() int

+ func (c *Set) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Table struct

+ Alias string

+ Columns []string

+ Expression litsql.Expression

+ func (c *Table) ClauseOrder() int

+ func (t *Table) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type UpdateOnly struct

+ Only bool

+ func (c *UpdateOnly) ClauseOrder() int

+ func (c *UpdateOnly) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Value []litsql.Expression

+ func (v Value) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Values struct

+ Query litsql.Query

+ Vals []Value

+ func (c *Values) ClauseMerge(other litsql.QueryClause)

+ func (c *Values) ClauseOrder() int

+ func (c *Values) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Where struct

+ Conditions []litsql.Expression

+ func (c *Where) ClauseMerge(other litsql.QueryClause)

+ func (c *Where) ClauseOrder() int

+ func (c *Where) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type WindowDef struct

+ From string

+ func (wi *WindowDef) AddOrderBy(order ...litsql.Expression)

+ func (wi *WindowDef) AddPartitionBy(condition ...litsql.Expression)

+ func (wi *WindowDef) SetFrom(from string)

+ func (wi *WindowDef) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type Windows struct

+ Windows []NamedWindow

+ func (wi *Windows) ClauseMerge(other litsql.QueryClause)

+ func (wi *Windows) ClauseOrder() int

+ func (wi *Windows) WriteSQL(w litsql.Writer, d litsql.Dialect, start int) ([]any, error)

+ type With struct

+ CTEs []*CTE

+ Recursive bool

+ func (c *With) ClauseMerge(other litsql.QueryClause)

+ func (c *With) ClauseOrder() int

+ func (w *With) SetRecursive(r bool)

+ func (w *With) WriteSQL(wr litsql.Writer, d litsql.Dialect, start int) ([]any, error)