sql

package

Go to main page

Versions in this module

v0

v0.18.59

Sep 7, 2026

v0.18.58

Sep 7, 2026

v0.18.57

Sep 7, 2026

Changes in this version

+ func BlockOutputColumns(info *SelectInfo) ([]string, bool)

+ func SelectItemName(c SelectColumn) string

type OuterRef

+ Bare bool

type TableColumns

+ func CTEColumns(ctes []CTEDef, base TableColumns) TableColumns

v0.18.56

Sep 7, 2026

v0.18.55

Sep 7, 2026

v0.18.54

Sep 7, 2026

v0.18.53

Sep 6, 2026

v0.18.52

Sep 6, 2026

v0.18.51

Sep 6, 2026

v0.18.50

Sep 6, 2026

v0.18.49

Sep 5, 2026

v0.18.48

Sep 5, 2026

v0.18.47

Sep 5, 2026

v0.18.46

Sep 5, 2026

v0.18.45

Sep 5, 2026

v0.18.44

Sep 5, 2026

v0.18.43

Sep 5, 2026

Changes in this version

+ const UnnamedOutputColumn

+ func OutputColumnName(col SelectColumn) string

type FuncCallNode

+ OutputLabel string

type SelectColumn

+ PublishedName string

v0.18.42

Sep 5, 2026

Changes in this version

+ func RefuseUnsupportedStatement(pq *ParsedQuery) error

type ExplainInfo

+ InnerType QueryType

type QueryType

+ func (t QueryType) StatementName() string

+ func (t QueryType) String() string

v0.18.41

Sep 5, 2026

v0.18.40

Sep 5, 2026

v0.18.39

Sep 5, 2026

v0.18.38

Sep 5, 2026

v0.18.37

Sep 5, 2026

v0.18.36

Sep 5, 2026

v0.18.35

Sep 4, 2026

Changes in this version

type CTEDef

+ func (c *CTEDef) BodySelect() (*SelectInfo, error)

type TableRef

+ func (t *TableRef) SubSelect() (*SelectInfo, error)

v0.18.34

Sep 4, 2026

v0.18.33

Sep 4, 2026

Changes in this version

+ func AppendRowLimit(sql string, info *SelectInfo, n int) string

+ func WithRowLimit(sql string, n int) string

type ColRef

+ func ColumnRefsOutsideSubqueries(n Node) ([]*ColRef, error)

v0.18.32

Sep 4, 2026

v0.18.31

Sep 4, 2026

v0.18.30

Sep 4, 2026

Changes in this version

+ func CoerceBooleanLiterals(info *SelectInfo) error

+ func FoldIdent(s string) string

+ func ParseBoolText(s string) (bool, bool)

type OrderByItem

+ Ordinal int

v0.18.29

Sep 4, 2026

v0.18.28

Sep 4, 2026

v0.18.27

Sep 4, 2026

v0.18.26

Sep 4, 2026

v0.18.25

Sep 4, 2026

v0.18.24

Sep 4, 2026

v0.18.23

Sep 3, 2026

Changes in this version

+ func CheckSingleStatement(sql string) error

+ func SplitStatements(sql string) []string

v0.18.22

Sep 3, 2026

v0.18.21

Sep 3, 2026

Changes in this version

+ func ExprIdentityUnqualified(n Node) string

type JoinInfo

+ Using []string

v0.18.20

Sep 3, 2026

Changes in this version

+ func LeadingKeyword(sql string) string

v0.18.19

Sep 3, 2026

v0.18.18

Sep 3, 2026

v0.18.17

Sep 3, 2026

v0.18.16

Sep 3, 2026

Changes in this version

+ func RevertGroupByAliasesShadowedByInput(info *SelectInfo, provides func(bare string) bool)

type SelectInfo

+ GroupByAliasOrigin []string

v0.18.15

Sep 3, 2026

Changes in this version

type SlotFamily

+ const SlotGrouping

v0.18.14

Sep 3, 2026

v0.18.13

Sep 3, 2026

v0.18.12

Sep 2, 2026

v0.18.11

Sep 2, 2026

v0.18.10

Sep 2, 2026

v0.18.9

Sep 1, 2026

v0.18.8

Sep 1, 2026

Changes in this version

type ColRef

+ Slot bool

v0.18.7

Sep 1, 2026

v0.18.6

Aug 31, 2026

Changes in this version

+ func ExprIdentity(n Node) string

+ func GroupKeyName(n Node) string

+ func RefuseReservedSlotName(name, where string) error

+ func RefuseReservedSlotNames(names []string, where string) error

+ func ReservedSlotFamily(name string) string

+ func SlotName(family SlotFamily, n int) string

+ func WindowOutputName(col SelectColumn) string

type Node

+ func ReplaceGroupKeyRefs(node Node, keys map[string]string) Node

+ func RewriteExpr(node Node, fn func(Node) (Node, bool)) Node

+ func Unparen(n Node) Node

+ type SlotAllocator struct

+ func NewSlotAllocator(inScope ...string) *SlotAllocator

+ func (a *SlotAllocator) Issued() []string

+ func (a *SlotAllocator) Next(family SlotFamily) (string, bool)

+ func (a *SlotAllocator) Seed(names ...string)

+ type SlotFamily string

+ const SlotAggInput

+ const SlotAvgCount

+ const SlotAvgSum

+ const SlotCovarState

+ const SlotDefaultPart

+ const SlotGroupKey

+ const SlotHaving

+ const SlotNestedAgg

+ const SlotPreComputedAgg

+ const SlotRowCountOnly

+ const SlotRowLocator

+ const SlotScalar

+ const SlotSetOpCount

+ const SlotSortKey

+ const SlotSubsumeFlag

+ const SlotTwoLevel

+ const SlotVarState

+ const SlotWindowKey

+ const SlotWindowOutput

v0.18.5

Aug 30, 2026

Changes in this version

+ func HasTopLevelReturning(sql string) bool

+ func HasTopLevelWhereToken(sql string) bool

type ColRef

+ func ColumnRefs(n Node) ([]*ColRef, error)

+ type DMLTarget struct

+ Alias string

+ Qualifier string

+ StmtSQL string

+ Table string

+ WhereSQL string

type MergeInfo

+ TargetQualifier string

type Node

+ func ParseExpressionComplete(sql string) (Node, error)

v0.18.4

Aug 29, 2026

Changes in this version

type Node

+ func ReplaceWindowFuncs(node Node, replacements map[*WindowFuncNode]string) Node

type WindowFuncNode

+ func FindAllWindowFuncs(node Node) []*WindowFuncNode

v0.18.3

Aug 28, 2026

Changes in this version

type JoinInfo

+ FromItem int

v0.18.2

Aug 25, 2026

v0.18.1

Aug 24, 2026

v0.18.0

Aug 23, 2026

Changes in this version

+ func IsAggregate(name string) bool

+ func NormalizeIdentRef(s string) string

+ func OuterColumnCandidates(subquerySQL string) []string

+ func QuoteIdent(name string) string

+ func RebuildSQL(info *SelectInfo, rewrittenWhere Node) string

+ func SetAlertIntervalFloorForTest(d time.Duration) func()

+ func SplitIdentRef(s string) (qualifier, name string, ok bool)

+ type AlterAlertInfo struct

+ Enable bool

+ Name string

+ type AlterTableInfo struct

+ Action string

+ ColumnName string

+ ColumnType string

+ NewColumnName string

+ Nullable bool

+ Table string

+ type AnalyzeTableInfo struct

+ Name string

+ type AndNode struct

+ Left Node

+ Right Node

+ func (a *AndNode) String() string

+ type AnyAllExpr struct

+ Left Node

+ Modifier string

+ Op string

+ Values []Node

+ func (a *AnyAllExpr) String() string

+ type ArrayLitNode struct

+ Elements []Node

+ func (a *ArrayLitNode) String() string

+ type BetweenExpr struct

+ High Node

+ Left Node

+ Low Node

+ Not bool

+ func (b *BetweenExpr) String() string

+ type BinaryOp struct

+ Left Node

+ Op string

+ Right Node

+ func (b *BinaryOp) String() string

+ type CTEDef struct

+ Columns []string

+ Name string

+ Recursive bool

+ SQL string

+ type CaseNode struct

+ Else Node

+ Subject Node

+ Whens []WhenClause

+ func (c *CaseNode) String() string

+ type CastNode struct

+ Inner Node

+ TypeName string

+ func (c *CastNode) String() string

+ type CmpExpr struct

+ Left Node

+ Op string

+ Right Node

+ func (c *CmpExpr) String() string

+ type ColRef struct

+ Column string

+ Table string

+ func (c *ColRef) String() string

+ type ColumnDef struct

+ Name string

+ Nullable bool

+ Type string

+ type CreateAlertInfo struct

+ Headers map[string]string

+ InsertInto string

+ Interval time.Duration

+ Name string

+ QueryText string

+ WebhookURL string

+ type CreateFunctionInfo struct

+ Body string

+ Locked bool

+ Name string

+ Params []string

+ Replace bool

+ type CreateSnapshotInfo struct

+ type CreateTableInfo struct

+ Columns []ColumnDef

+ Name string

+ PartitionKeys []string

+ type CreateViewInfo struct

+ Name string

+ Replace bool

+ SQL string

+ type DeleteInfo struct

+ Table string

+ WhereSQL string

+ type DescribeInfo struct

+ TableName string

+ type DropAlertInfo struct

+ IfExists bool

+ Name string

+ type DropFunctionInfo struct

+ IfExists bool

+ Name string

+ type DropTableInfo struct

+ IfExists bool

+ Name string

+ type DropViewInfo struct

+ IfExists bool

+ Name string

+ type ExistsNode struct

+ Not bool

+ SQL string

+ func (e *ExistsNode) String() string

+ type ExplainInfo struct

+ Analyze bool

+ InnerSQL string

+ Verbose bool

+ type FrameBound struct

+ Offset Node

+ Type FrameBoundType

+ type FrameBoundType int

+ const BoundCurrentRow

+ const BoundFollowing

+ const BoundPreceding

+ const BoundUnboundedFollowing

+ const BoundUnboundedPreceding

+ type FrameMode int

+ const FrameRange

+ const FrameRows

+ type FuncCallNode struct

+ Args []Node

+ Distinct bool

+ Name string

+ Star bool

+ func FindAllAggregates(node Node) []*FuncCallNode

+ func FindNestedAggregate(node Node) *FuncCallNode

+ func (f *FuncCallNode) String() string

+ type InExpr struct

+ Left Node

+ Not bool

+ Values []Node

+ func (e *InExpr) String() string

+ type InsertInfo struct

+ Columns []string

+ Table string

+ Values [][]string

+ type IntervalLit struct

+ Unit string

+ Value int

+ func (i *IntervalLit) String() string

+ type IsExpr struct

+ Check string

+ Left Node

+ Not bool

+ func (e *IsExpr) String() string

+ type JoinInfo struct

+ CondExpr Node

+ Condition string

+ Lateral bool

+ LeftTable string

+ RightAlias string

+ RightTable string

+ RightTableRef *TableRef

+ Type string

+ type LikeExpr struct

+ Left Node

+ Not bool

+ Pattern Node

+ func (l *LikeExpr) String() string

+ type Lit struct

+ Kind LiteralKind

+ Value string

+ func (l *Lit) String() string

+ type LiteralKind int

+ const LitBool

+ const LitNull

+ const LitNumber

+ const LitString

+ type LiteralPlaceholder struct

+ Name string

+ func (l *LiteralPlaceholder) String() string

+ type MergeInfo struct

+ OnCondition string

+ Source string

+ SourceAlias string

+ Target string

+ TargetAlias string

+ WhenClauses []MergeWhenClause

+ type MergeWhenClause struct

+ Action string

+ Condition string

+ Matched bool

+ SQL string

+ type Node interface

+ String func() string

+ func ParseExpression(sql string) (Node, error)

+ func ReplaceAggregate(node Node, aggName string) Node

+ func ReplaceAllAggregates(node Node, replacements map[string]string) Node

+ func RewriteOuterRefs(node Node, outerTables map[string]bool, vals map[string]any) Node

+ func RewriteUnqualifiedOuterRefs(node Node, unqualOuter map[string]string, vals map[string]any) Node

+ type NotNode struct

+ Inner Node

+ func (n *NotNode) String() string

+ type OrNode struct

+ Left Node

+ Right Node

+ func (o *OrNode) String() string

+ type OrderByItem struct

+ Column string

+ Desc bool

+ Expr Node

+ NullsFirst *bool

+ type OuterRef struct

+ Column string

+ Table string

+ func DanglingTableRefs(subquerySQL string) []OuterRef

+ func FindCorrelatedRefs(subquerySQL string, outerTables map[string]bool) ([]OuterRef, error)

+ func FindCorrelatedRefsWithColumns(subquerySQL string, outerTables map[string]bool, outerCols map[string]string) ([]OuterRef, error)

+ func FindCorrelatedRefsWithScope(subquerySQL string, outerTables map[string]bool, outerCols map[string]string, ...) ([]OuterRef, error)

+ type ParenNode struct

+ Inner Node

+ func (p *ParenNode) String() string

+ type ParsedQuery struct

+ AlterAlert *AlterAlertInfo

+ AlterTable *AlterTableInfo

+ AnalyzeTable *AnalyzeTableInfo

+ CTEs []CTEDef

+ CreateAlert *CreateAlertInfo

+ CreateFunction *CreateFunctionInfo

+ CreateSnapshot *CreateSnapshotInfo

+ CreateTable *CreateTableInfo

+ CreateView *CreateViewInfo

+ Delete *DeleteInfo

+ Describe *DescribeInfo

+ DropAlert *DropAlertInfo

+ DropFunction *DropFunctionInfo

+ DropTable *DropTableInfo

+ DropView *DropViewInfo

+ Explain *ExplainInfo

+ Insert *InsertInfo

+ Merge *MergeInfo

+ SQL string

+ SelectInfo *SelectInfo

+ TableName string

+ Type QueryType

+ Update *UpdateInfo

+ Windows []WindowSpec

+ func Parse(sql string) (*ParsedQuery, error)

+ type QueryType int

+ const QueryAlterAlert

+ const QueryAlterTable

+ const QueryAnalyzeTable

+ const QueryCreateAlert

+ const QueryCreateFunction

+ const QueryCreateSnapshot

+ const QueryCreateTable

+ const QueryCreateView

+ const QueryDelete

+ const QueryDescribe

+ const QueryDropAlert

+ const QueryDropFunction

+ const QueryDropTable

+ const QueryDropView

+ const QueryExplain

+ const QueryInsert

+ const QueryMerge

+ const QuerySelect

+ const QueryShowFunctions

+ const QueryShowTables

+ const QueryUnsupported

+ const QueryUpdate

+ type SelectColumn struct

+ ASTExpr Node

+ AggArg string

+ AggArgExpr Node

+ AggArgs []Node

+ AggDistinct bool

+ AggFunc string

+ Alias string

+ ColumnRef string

+ Expr string

+ IsAgg bool

+ IsWindow bool

+ Star bool

+ TableRef string

+ WindowSpec *WindowSpec

+ type SelectInfo struct

+ CTEs []CTEDef

+ Columns []SelectColumn

+ Distinct bool

+ GroupBy []string

+ GroupByExprs []Node

+ GroupingSets [][]string

+ Having string

+ HavingExpr Node

+ Joins []JoinInfo

+ Limit string

+ Offset string

+ OrderBy []OrderByItem

+ Qualify string

+ QualifyExpr Node

+ Tables []TableRef

+ Union *UnionInfo

+ Where string

+ WhereExpr Node

+ Windows []WindowSpec

+ func ExtractSelect(pq *ParsedQuery) (*SelectInfo, error)

+ type SetClause struct

+ Column string

+ Value string

+ type SetOp string

+ const SetOpExcept

+ const SetOpIntersect

+ const SetOpUnion

+ type StarNode struct

+ Table string

+ func (s *StarNode) String() string

+ type SubqueryNode struct

+ SQL string

+ func (s *SubqueryNode) String() string

+ type TableColumns func(table string) []string

+ type TableRef struct

+ Alias string

+ ColumnAliases []string

+ FuncArgs []string

+ FuncNamedArgs map[string]string

+ IsFunction bool

+ Name string

+ Qualifier string

+ SampleMethod string

+ SamplePercent string

+ WithOrdinality bool

+ type TokenType int

+ const TokenComma

+ const TokenConcat

+ const TokenDot

+ const TokenDoubleColon

+ const TokenEOF

+ const TokenEq

+ const TokenError

+ const TokenGT

+ const TokenGTEq

+ const TokenIdent

+ const TokenJSONArrow

+ const TokenJSONDoubleArrow

+ const TokenKWAdd

+ const TokenKWAlert

+ const TokenKWAll

+ const TokenKWAlter

+ const TokenKWAnalyze

+ const TokenKWAnd

+ const TokenKWAs

+ const TokenKWAsc

+ const TokenKWBetween

+ const TokenKWBy

+ const TokenKWCase

+ const TokenKWCast

+ const TokenKWColumn

+ const TokenKWColumns

+ const TokenKWCreate

+ const TokenKWCross

+ const TokenKWCube

+ const TokenKWCurrent

+ const TokenKWDelete

+ const TokenKWDesc

+ const TokenKWDescribe

+ const TokenKWDisable

+ const TokenKWDistinct

+ const TokenKWDrop

+ const TokenKWElse

+ const TokenKWEnable

+ const TokenKWEnd

+ const TokenKWEvery

+ const TokenKWExcept

+ const TokenKWExists

+ const TokenKWExplain

+ const TokenKWFalse

+ const TokenKWFetch

+ const TokenKWFirst

+ const TokenKWFollowing

+ const TokenKWFrom

+ const TokenKWFull

+ const TokenKWFunction

+ const TokenKWFunctions

+ const TokenKWGroup

+ const TokenKWGrouping

+ const TokenKWHaving

+ const TokenKWHeaders

+ const TokenKWHours

+ const TokenKWILike

+ const TokenKWIf

+ const TokenKWIn

+ const TokenKWInner

+ const TokenKWInsert

+ const TokenKWIntersect

+ const TokenKWInto

+ const TokenKWIs

+ const TokenKWJoin

+ const TokenKWLast

+ const TokenKWLeft

+ const TokenKWLike

+ const TokenKWLimit

+ const TokenKWLock

+ const TokenKWMatched

+ const TokenKWMerge

+ const TokenKWMinutes

+ const TokenKWNatural

+ const TokenKWNot

+ const TokenKWNull

+ const TokenKWNulls

+ const TokenKWOffset

+ const TokenKWOn

+ const TokenKWOr

+ const TokenKWOrder

+ const TokenKWOuter

+ const TokenKWOver

+ const TokenKWPartition

+ const TokenKWPreceding

+ const TokenKWRange

+ const TokenKWRename

+ const TokenKWReplace

+ const TokenKWRight

+ const TokenKWRollup

+ const TokenKWRow

+ const TokenKWRows

+ const TokenKWSeconds

+ const TokenKWSelect

+ const TokenKWSet

+ const TokenKWSets

+ const TokenKWShow

+ const TokenKWSnapshot

+ const TokenKWTable

+ const TokenKWTables

+ const TokenKWThen

+ const TokenKWTo

+ const TokenKWTrue

+ const TokenKWUnbounded

+ const TokenKWUnion

+ const TokenKWUpdate

+ const TokenKWUsing

+ const TokenKWValues

+ const TokenKWVerbose

+ const TokenKWView

+ const TokenKWWebhook

+ const TokenKWWhen

+ const TokenKWWhere

+ const TokenKWWith

+ const TokenLBrace

+ const TokenLBracket

+ const TokenLParen

+ const TokenLT

+ const TokenLTEq

+ const TokenMinus

+ const TokenNotEq

+ const TokenNumber

+ const TokenPercent

+ const TokenPlus

+ const TokenRBrace

+ const TokenRBracket

+ const TokenRParen

+ const TokenRawBody

+ const TokenSemicolon

+ const TokenSlash

+ const TokenStar

+ const TokenString

+ type TupleNode struct

+ Elements []Node

+ func (t *TupleNode) String() string

+ type UnaryOp struct

+ Inner Node

+ Op string

+ func (u *UnaryOp) String() string

+ type UnionInfo struct

+ All bool

+ Left *SelectInfo

+ Op SetOp

+ Right *SelectInfo

+ type UpdateInfo struct

+ SetClauses []SetClause

+ Table string

+ WhereSQL string

+ type WhenClause struct

+ Cond Node

+ Result Node

+ type WindowFrame struct

+ End *FrameBound

+ Mode FrameMode

+ Start FrameBound

+ type WindowFuncNode struct

+ Frame *WindowFrame

+ Func *FuncCallNode

+ OrderBy []WindowOrderBy

+ PartitionBy []Node

+ func (n *WindowFuncNode) String() string

+ type WindowOrderBy struct

+ Desc bool

+ Expr Node

+ NullsFirst *bool

+ type WindowOrderItem struct

+ Column string

+ Desc bool

+ NullsFirst *bool

+ type WindowSpec struct

+ Alias string

+ Args string

+ Frame *WindowFrame

+ FuncName string

+ OrderBy []WindowOrderItem

+ PartitionBy []string

v0.17.0-clawback

Aug 22, 2026

v0.16.0-correctness

Aug 21, 2026

v0.15.0-aggregation-engine

Aug 17, 2026

v0.14.0-scan-pushdown

Aug 17, 2026

v0.13.0-late-materialization

Aug 16, 2026

v0.12.0-clickbench

Aug 16, 2026

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL