spansql

Nov 8, 2024

Changes in this version

+ type AlterProtoBundle struct

+ AddTypes []string

+ DeleteTypes []string

+ Position Position

+ UpdateTypes []string

+ func (ap *AlterProtoBundle) Pos() Position

+ func (ap *AlterProtoBundle) String() string

+ func (ap AlterProtoBundle) SQL() string

+ type CreateProtoBundle struct

+ Position Position

+ Types []string

+ func (cp *CreateProtoBundle) Pos() Position

+ func (cp *CreateProtoBundle) String() string

+ func (cp CreateProtoBundle) SQL() string

+ type DropProtoBundle struct

+ Position Position

+ func (do DropProtoBundle) SQL() string

+ func (dp *DropProtoBundle) Pos() Position

+ func (dp *DropProtoBundle) String() string

type Type

+ ProtoRef string

type TypeBase

+ const Enum

+ const Proto

Mar 13, 2024

Changes in this version

+ type AddSynonym struct

+ Name ID

+ func (as AddSynonym) SQL() string

type CreateTable

+ Synonym ID

+ type DropSynonym struct

+ Name ID

+ func (ds DropSynonym) SQL() string

+ type RenameTable struct

+ Position Position

+ TableRenameOps []TableRenameOp

+ func (rt *RenameTable) Pos() Position

+ func (rt *RenameTable) String() string

+ func (rt RenameTable) SQL() string

+ type RenameTo struct

+ Synonym ID

+ ToName ID

+ func (rt RenameTo) SQL() string

+ type TableRenameOp struct

+ FromName ID

+ ToName ID

Jan 30, 2024

Changes in this version

type CreateView

+ SecurityType SecurityType

+ type SecurityType int

+ const Definer

+ const Invoker

+ func (st SecurityType) SQL() string

Oct 4, 2023

Changes in this version

+ type AggregateHaving struct

+ Condition AggregateHavingCondition

+ Expr Expr

+ type AggregateHavingCondition int

+ const HavingMax

+ const HavingMin

+ type AlterSequence struct

+ Alteration SequenceAlteration

+ Name ID

+ Position Position

+ func (as *AlterSequence) Pos() Position

+ func (as *AlterSequence) String() string

+ func (as AlterSequence) SQL() string

+ type CreateSequence struct

+ IfNotExists bool

+ Name ID

+ Options SequenceOptions

+ Position Position

+ func (cs *CreateSequence) Pos() Position

+ func (cs *CreateSequence) String() string

+ func (cs CreateSequence) SQL() string

+ type DropSequence struct

+ IfExists bool

+ Name ID

+ Position Position

+ func (do DropSequence) SQL() string

+ func (ds *DropSequence) Pos() Position

+ func (ds *DropSequence) String() string

type Func

+ Distinct bool

+ Having *AggregateHaving

+ NullsHandling NullsHandling

+ type NullsHandling int

+ const IgnoreNulls

+ const NullsHandlingUnspecified

+ const RespectNulls

+ type SequenceAlteration interface

+ SQL func() string

+ type SequenceExpr struct

+ Name ID

+ func (se SequenceExpr) SQL() string

+ type SequenceOptions struct

+ SequenceKind *string

+ SkipRangeMax *int

+ SkipRangeMin *int

+ StartWithCounter *int

+ func (so SequenceOptions) SQL() string

+ type SetSequenceOptions struct

+ Options SequenceOptions

+ func (sa SetSequenceOptions) SQL() string

Aug 18, 2023

Changes in this version

type AddColumn

+ IfNotExists bool

type CreateIndex

+ IfNotExists bool

type CreateTable

+ IfNotExists bool

type DropIndex

+ IfExists bool

type DropTable

+ IfExists bool

type ForeignKey

+ OnDelete OnDelete

Apr 10, 2023

Changes in this version

type AlterWatch

+ WatchAllTables bool

+ func (scsw AlterWatch) SQL() string

+ type CreateRole struct

+ Name ID

+ Position Position

+ func (cr *CreateRole) Pos() Position

+ func (cr *CreateRole) String() string

+ func (cr CreateRole) SQL() string

+ type DropChangeStreamWatch struct

+ func (dcsw DropChangeStreamWatch) SQL() string

+ type DropRole struct

+ Name ID

+ Position Position

+ func (dr *DropRole) Pos() Position

+ func (dr *DropRole) String() string

+ func (dr DropRole) SQL() string

+ type GrantRole struct

+ ChangeStreamNames []ID

+ GrantRoleNames []ID

+ Position Position

+ Privileges []Privilege

+ TableNames []ID

+ ToRoleNames []ID

+ TvfNames []ID

+ ViewNames []ID

+ func (gr *GrantRole) Pos() Position

+ func (gr *GrantRole) String() string

+ func (gr GrantRole) SQL() string

+ type Privilege struct

+ Columns []ID

+ Type PrivilegeType

+ type PrivilegeType int

+ const PrivilegeTypeDelete

+ const PrivilegeTypeInsert

+ const PrivilegeTypeSelect

+ const PrivilegeTypeUpdate

+ func (pt PrivilegeType) SQL() string

+ type RevokeRole struct

+ ChangeStreamNames []ID

+ FromRoleNames []ID

+ Position Position

+ Privileges []Privilege

+ RevokeRoleNames []ID

+ TableNames []ID

+ TvfNames []ID

+ ViewNames []ID

+ func (rr *RevokeRole) Pos() Position

+ func (rr *RevokeRole) String() string

+ func (rr RevokeRole) SQL() string

type WatchDef

+ func (w WatchDef) SQL() string

Feb 2, 2023

Changes in this version

+ type AddStoredColumn struct

+ Name ID

+ func (asc AddStoredColumn) SQL() string

+ type AlterIndex struct

+ Alteration IndexAlteration

+ Name ID

+ Position Position

+ func (ai AlterIndex) SQL() string

+ func (as *AlterIndex) Pos() Position

+ func (as *AlterIndex) String() string

+ type AlterStatistics struct

+ Alteration StatisticsAlteration

+ Name ID

+ Position Position

+ func (as *AlterStatistics) Pos() Position

+ func (as *AlterStatistics) String() string

+ func (as AlterStatistics) SQL() string

type DatabaseOptions

+ OptimizerStatisticsPackage *string

+ type DropStoredColumn struct

+ Name ID

+ func (dsc DropStoredColumn) SQL() string

+ type IndexAlteration interface

+ SQL func() string

+ type SetStatisticsOptions struct

+ Options StatisticsOptions

+ func (sso SetStatisticsOptions) SQL() string

+ type StatisticsAlteration interface

+ SQL func() string

+ type StatisticsOptions struct

+ AllowGC *bool

+ func (sa StatisticsOptions) SQL() string

Jan 19, 2023

Changes in this version

type ChangeStreamOptions

+ ValueCaptureType *string

+ func (cso ChangeStreamOptions) SQL() string

type DatabaseOptions

+ DefaultLeader *string

Nov 3, 2022

Changes in this version

+ type IntervalExpr struct

+ DatePart string

+ Expr Expr

+ func (ie IntervalExpr) SQL() string

Sep 21, 2022

Changes in this version

+ type AlterChangeStream struct

+ Alteration ChangeStreamAlteration

+ Name ID

+ Position Position

+ func (acs *AlterChangeStream) Pos() Position

+ func (acs *AlterChangeStream) String() string

+ func (acs AlterChangeStream) SQL() string

+ type AlterChangeStreamOptions struct

+ Options ChangeStreamOptions

+ func (ao AlterChangeStreamOptions) SQL() string

+ type AlterWatch struct

+ Watch []WatchDef

+ type ChangeStreamAlteration interface

+ SQL func() string

+ type ChangeStreamOptions struct

+ RetentionPeriod *string

+ type CreateChangeStream struct

+ Name ID

+ Options ChangeStreamOptions

+ Position Position

+ Watch []WatchDef

+ WatchAllTables bool

+ func (cs *CreateChangeStream) Pos() Position

+ func (cs *CreateChangeStream) String() string

+ func (cs CreateChangeStream) SQL() string

+ type DropChangeStream struct

+ Name ID

+ Position Position

+ func (dc *DropChangeStream) Pos() Position

+ func (dc *DropChangeStream) String() string

+ func (dc DropChangeStream) SQL() string

+ type WatchDef struct

+ Columns []ID

+ Position Position

+ Table ID

+ WatchAllCols bool

+ func (wd WatchDef) Pos() Position

Sep 3, 2022

Changes in this version

+ type Coalesce struct

+ ExprList []Expr

+ func (c Coalesce) SQL() string

Aug 29, 2022

Changes in this version

+ type NullIf struct

+ Expr Expr

+ ExprToMatch Expr

+ func (ni NullIf) SQL() string

Jul 25, 2022

Changes in this version

+ type DML struct

+ Comments []*Comment

+ Filename string

+ List []DMLStmt

+ func ParseDML(filename, s string) (*DML, error)

+ func (d *DML) InlineComment(n Node) *Comment

+ func (d *DML) LeadingComment(n Node) *Comment

+ type IfNull struct

+ Expr Expr

+ NullResult Expr

+ func (in IfNull) SQL() string

Jul 19, 2022

Changes in this version

+ type If struct

+ ElseResult Expr

+ Expr Expr

+ TrueResult Expr

+ func (i If) SQL() string

Jun 20, 2022

Changes in this version

+ type Insert struct

+ Columns []ID

+ Input ValuesOrSelect

+ Table ID

+ func (i *Insert) SQL() string

+ func (i *Insert) String() string

+ type Values [][]Expr

+ func (v Values) SQL() string

+ func (v Values) String() string

+ type ValuesOrSelect interface

+ SQL func() string

May 9, 2022

Changes in this version

type ColumnDef

+ Default Expr

+ type DropDefault struct

+ func (dp DropDefault) SQL() string

+ type JSONLiteral []byte

+ func (jl JSONLiteral) SQL() string

type SetColumnType

+ Default Expr

+ type SetDefault struct

+ Default Expr

+ func (sd SetDefault) SQL() string

Apr 11, 2022

Changes in this version

+ type Case struct

+ ElseResult Expr

+ Expr Expr

+ WhenClauses []WhenClause

+ func (c Case) SQL() string

+ type WhenClause struct

+ Cond Expr

+ Result Expr

Jan 6, 2022

Changes in this version

+ type AtTimeZoneExpr struct

+ Expr Expr

+ Type Type

+ Zone string

+ func (aze AtTimeZoneExpr) SQL() string

+ type ExtractExpr struct

+ Expr Expr

+ Part string

+ Type Type

+ func (ee ExtractExpr) SQL() string

Dec 6, 2021

Changes in this version

+ type TypedExpr struct

+ Expr Expr

+ Type Type

+ func (te TypedExpr) SQL() string

Oct 11, 2021

Changes in this version

+ type CreateView struct

+ Name ID

+ OrReplace bool

+ Position Position

+ Query Query

+ func (cv *CreateView) Pos() Position

+ func (cv *CreateView) String() string

+ func (cv CreateView) SQL() string

+ type DropView struct

+ Name ID

+ Position Position

+ func (dv *DropView) Pos() Position

+ func (dv *DropView) String() string

+ func (dv DropView) SQL() string

type TypeBase

+ const JSON

Jul 30, 2021

Changes in this version

+ type AddRowDeletionPolicy struct

+ RowDeletionPolicy RowDeletionPolicy

+ func (ardp AddRowDeletionPolicy) SQL() string

+ type AlterDatabase struct

+ Alteration DatabaseAlteration

+ Name ID

+ Position Position

+ func (ad *AlterDatabase) Pos() Position

+ func (ad *AlterDatabase) String() string

+ func (ad AlterDatabase) SQL() string

type CreateTable

+ RowDeletionPolicy *RowDeletionPolicy

+ type DatabaseAlteration interface

+ SQL func() string

+ type DatabaseOptions struct

+ EnableKeyVisualizer *bool

+ OptimizerVersion *int

+ VersionRetentionPeriod *string

+ func (do DatabaseOptions) SQL() string

+ type DropRowDeletionPolicy struct

+ func (drdp DropRowDeletionPolicy) SQL() string

+ type ReplaceRowDeletionPolicy struct

+ RowDeletionPolicy RowDeletionPolicy

+ func (rrdp ReplaceRowDeletionPolicy) SQL() string

+ type RowDeletionPolicy struct

+ Column ID

+ NumDays int64

+ func (rdp RowDeletionPolicy) SQL() string

type SelectFromTable

+ Hints map[string]string

+ type SetDatabaseOptions struct

+ Options DatabaseOptions

+ func (sdo SetDatabaseOptions) SQL() string

Jan 15, 2021

Changes in this version

+ type Array []Expr

+ func (a Array) SQL() string

type ColumnDef

+ Generated Expr

+ type DateLiteral civil.Date

+ func (dl DateLiteral) SQL() string

+ type SelectFromUnnest struct

+ Alias ID

+ Expr Expr

+ func (sfu SelectFromUnnest) SQL() string

+ type TimestampLiteral time.Time

+ func (tl TimestampLiteral) SQL() string

type TypeBase

+ const Numeric

+ type Update struct

+ Items []UpdateItem

+ Table ID

+ Where BoolExpr

+ func (u *Update) SQL() string

+ func (u *Update) String() string

+ type UpdateItem struct

+ Column ID

+ Value Expr

Oct 20, 2020

Changes in this version

type ArithOperator

+ const Plus

+ type Check struct

+ Expr BoolExpr

+ Position Position

+ func (c Check) Pos() Position

+ func (c Check) SQL() string

+ type Constraint interface

+ SQL func() string

+ type JoinType int

+ const CrossJoin

+ const FullJoin

+ const InnerJoin

+ const LeftJoin

+ const RightJoin

+ type PathExp []ID

+ func (pe PathExp) SQL() string

type Select

+ TableSamples []*TableSample

type SelectFrom

+ SQL func() string

+ type SelectFromJoin struct

+ Hints map[string]string

+ LHS SelectFrom

+ On BoolExpr

+ RHS SelectFrom

+ Type JoinType

+ Using []ID

+ func (sfj SelectFromJoin) SQL() string

+ type SelectFromTable struct

+ Alias ID

+ Table ID

+ func (sft SelectFromTable) SQL() string

type TableConstraint

+ Constraint Constraint

Aug 17, 2020

Changes in this version

type AlterColumn

+ Alteration ColumnAlteration

+ Name string

+ type ColumnAlteration interface

+ SQL func() string

type ColumnDef

+ Options ColumnOptions

+ type ColumnOptions struct

+ AllowCommitTimestamp *bool

+ func (co ColumnOptions) SQL() string

+ type SetColumnOptions struct

+ Options ColumnOptions

+ func (sco SetColumnOptions) SQL() string

+ type SetColumnType struct

+ NotNull bool

+ Type Type

+ func (sct SetColumnType) SQL() string

May 26, 2020

Changes in this version

type SelectFrom

+ Alias string

Mar 17, 2020

Changes in this version

+ type AddConstraint struct

+ Constraint TableConstraint

+ func (ac AddConstraint) SQL() string

+ type AlterColumn struct

+ Def ColumnDef

+ func (ac AlterColumn) SQL() string

type Comment

+ Isolated bool

type CreateTable

+ Constraints []TableConstraint

+ type DropConstraint struct

+ Name string

+ func (dc DropConstraint) SQL() string

+ type ForeignKey struct

+ Columns []string

+ Position Position

+ RefColumns []string

+ RefTable string

+ func (fk ForeignKey) Pos() Position

+ func (fk ForeignKey) SQL() string

+ type InOp struct

+ LHS Expr

+ Neg bool

+ RHS []Expr

+ Unnest bool

+ func (io InOp) SQL() string

+ type LiteralOrParam interface

+ SQL func() string

type Query

+ Offset LiteralOrParam

type Select

+ GroupBy []Expr

+ ListAliases []string

+ type TableConstraint struct

+ ForeignKey ForeignKey

+ Name string

+ Position Position

+ func (tc TableConstraint) Pos() Position

+ func (tc TableConstraint) SQL() string

Feb 17, 2020

Changes in this version

+ func IsKeyword(id string) bool

type AlterTable

+ Position Position

+ func (at *AlterTable) Pos() Position

+ func (at *AlterTable) String() string

+ type ArithOp struct

+ LHS Expr

+ Op ArithOperator

+ RHS Expr

+ func (ao ArithOp) SQL() string

+ type ArithOperator int

+ const Add

+ const BitAnd

+ const BitNot

+ const BitOr

+ const BitShl

+ const BitShr

+ const BitXor

+ const Concat

+ const Div

+ const Mul

+ const Neg

+ const Sub

type ColumnDef

+ Position Position

+ func (cd ColumnDef) Pos() Position

+ type Comment struct

+ End Position

+ Marker string

+ Start Position

+ Text []string

+ func (c *Comment) Pos() Position

+ func (c *Comment) String() string

type CreateIndex

+ Position Position

+ func (ci *CreateIndex) Pos() Position

+ func (ci *CreateIndex) String() string

type CreateTable

+ Position Position

+ func (ct *CreateTable) Pos() Position

+ func (ct *CreateTable) String() string

type DDL

+ Comments []*Comment

+ Filename string

+ func (ddl *DDL) InlineComment(n Node) *Comment

+ func (ddl *DDL) LeadingComment(n Node) *Comment

+ type DMLStmt interface

+ SQL func() string

+ func ParseDMLStmt(s string) (DMLStmt, error)

+ type Delete struct

+ Table string

+ Where BoolExpr

+ func (d *Delete) SQL() string

+ func (d *Delete) String() string

type DropIndex

+ Position Position

+ func (di *DropIndex) Pos() Position

+ func (di *DropIndex) String() string

type DropTable

+ Position Position

+ func (dt *DropTable) Pos() Position

+ func (dt *DropTable) String() string

+ type Node interface

+ Pos func() Position

+ type Position struct

+ Line int

+ Offset int

+ func (pos Position) IsValid() bool

+ func (pos Position) String() string

Jan 28, 2020

Changes in this version

type ColumnDef

+ AllowCommitTimestamp *bool

type Select

+ Distinct bool

Sep 13, 2019

Changes in this version

+ const False

+ const MaxLen

+ const Null

+ const Star

+ const True

+ type AddColumn struct

+ Def ColumnDef

+ func (ac AddColumn) SQL() string

+ type AlterTable struct

+ Alteration TableAlteration

+ Name string

+ func (at AlterTable) SQL() string

+ type BoolExpr interface

+ type BoolLiteral bool

+ func (b BoolLiteral) SQL() string

+ type BytesLiteral string

+ func (bl BytesLiteral) SQL() string

+ type ColumnDef struct

+ Name string

+ NotNull bool

+ Type Type

+ func (cd ColumnDef) SQL() string

+ type ComparisonOp struct

+ LHS Expr

+ Op ComparisonOperator

+ RHS Expr

+ RHS2 Expr

+ func (co ComparisonOp) SQL() string

+ type ComparisonOperator int

+ const Between

+ const Eq

+ const Ge

+ const Gt

+ const Le

+ const Like

+ const Lt

+ const Ne

+ const NotBetween

+ const NotLike

+ type CreateIndex struct

+ Columns []KeyPart

+ Interleave string

+ Name string

+ NullFiltered bool

+ Storing []string

+ Table string

+ Unique bool

+ func (ci CreateIndex) SQL() string

+ type CreateTable struct

+ Columns []ColumnDef

+ Interleave *Interleave

+ Name string

+ PrimaryKey []KeyPart

+ func (ct CreateTable) SQL() string

+ type DDL struct

+ List []DDLStmt

+ func ParseDDL(s string) (DDL, error)

+ type DDLStmt interface

+ SQL func() string

+ func ParseDDLStmt(s string) (DDLStmt, error)

+ type DropColumn struct

+ Name string

+ func (dc DropColumn) SQL() string

+ type DropIndex struct

+ Name string

+ func (di DropIndex) SQL() string

+ type DropTable struct

+ Name string

+ func (dt DropTable) SQL() string

+ type Expr interface

+ SQL func() string

+ type FloatLiteral float64

+ func (fl FloatLiteral) SQL() string

+ type Func struct

+ Args []Expr

+ Name string

+ func (f Func) SQL() string

+ type ID string

+ func (id ID) SQL() string

+ type IntegerLiteral int64

+ func (il IntegerLiteral) SQL() string

+ type Interleave struct

+ OnDelete OnDelete

+ Parent string

+ type IsExpr interface

+ SQL func() string

+ type IsOp struct

+ LHS Expr

+ Neg bool

+ RHS IsExpr

+ func (io IsOp) SQL() string

+ type KeyPart struct

+ Column string

+ Desc bool

+ func (kp KeyPart) SQL() string

+ type Limit interface

+ SQL func() string

+ type LogicalOp struct

+ LHS BoolExpr

+ Op LogicalOperator

+ RHS BoolExpr

+ func (lo LogicalOp) SQL() string

+ type LogicalOperator int

+ const And

+ const Not

+ const Or

+ type NullLiteral int

+ func (n NullLiteral) SQL() string

+ type OnDelete int

+ const CascadeOnDelete

+ const NoActionOnDelete

+ func (od OnDelete) SQL() string

+ type Order struct

+ Desc bool

+ Expr Expr

+ func (o Order) SQL() string

+ type Param string

+ func (p Param) SQL() string

+ type Paren struct

+ Expr Expr

+ func (p Paren) SQL() string

+ type Query struct

+ Limit Limit

+ Order []Order

+ Select Select

+ func ParseQuery(s string) (Query, error)

+ func (q Query) SQL() string

+ type Select struct

+ From []SelectFrom

+ List []Expr

+ Where BoolExpr

+ func (sel Select) SQL() string

+ type SelectFrom struct

+ Table string

+ TableSample *TableSample

+ type SetOnDelete struct

+ Action OnDelete

+ func (sod SetOnDelete) SQL() string

+ type StarExpr int

+ func (StarExpr) SQL() string

+ type StringLiteral string

+ func (sl StringLiteral) SQL() string

+ type TableAlteration interface

+ SQL func() string

+ type TableSample struct

+ Method TableSampleMethod

+ Size Expr

+ SizeType TableSampleSizeType

+ type TableSampleMethod int

+ const Bernoulli

+ const Reservoir

+ type TableSampleSizeType int

+ const PercentTableSample

+ const RowsTableSample

+ type Type struct

+ Array bool

+ Base TypeBase

+ Len int64

+ func (t Type) SQL() string

+ type TypeBase int

+ const Bool

+ const Bytes

+ const Date

+ const Float64

+ const Int64

+ const String

+ const Timestamp

+ func (tb TypeBase) SQL() string