parser

type BinaryOperation struct {
	SQLField
	Operator *opcode.Op
	Left     ExprField
	Right    ExprField
	Not      bool
}

type CaseWhenExpr struct {
	SQLField
	WhenClauses []*WhenClause
	Else        ExprField
}

type Column struct {
	Type  ColumnType
	Name  string
	Array *Column
	Json  map[string]*Column
}

type ColumnType int

type ExprField interface {
	GetType() SQLFieldType
	GetTable() string
	GetFunc() string
	GetDistinct() bool
	GetArgs() []ExprField
	GetColName() *Column
	GetColType() ColumnType
	GetName() string
	GetRawName() string
	GetAsName() string
	GetValueKind() byte
	GetValue() any
	SetType(SQLFieldType)
	SetTable(string)
	SetFunc(string)
	SetDistinct(bool)
	SetArgs([]ExprField)
	SetName(*Column)
	SetAsName(string)
	SetValueKind(byte)
	SetValue(any)
	HasDistinct() bool
	IsAllValue() bool
}

type MySQLSelectParser struct {
	// contains filtered or unexported fields
}

type PatternLike struct {
	SQLField
	Left  ExprField
	Right ExprField
	Not   bool
}

type SQL interface {
	// 获取原始SQL
	OriginalSQL() string
}

type SQLField struct {
	Type      SQLFieldType
	Table     *string
	Func      *string
	Distinct  bool
	Args      []ExprField
	Name      *Column
	AsName    *string
	ValueKind *byte
	Value     any
}

type SQLFieldType int

type SQLLimit struct {
	Limit  *int64
	Offset *int64
}

type SQLOrderBy struct {
	SQLField
	Desc bool
}

type SQLSelect struct {
	Distinct bool
	Fields   []ExprField
	From     *SQLTable
	Where    ExprField
	GroupBy  []ExprField
	Having   ExprField
	OrderBy  []*SQLOrderBy
	Limit    *SQLLimit
	SQL      *string
}

type SQLTable struct {
	Name        *string
	AsName      *string
	TableSchema map[string][]*Column
	Ref         *SQLSelect
	Left        *SQLTable
	Right       *SQLTable
	On          ExprField
}

type SelectParser interface {
	// 返回SQL元数据
	Parse(strictMode bool) (SQL, error)
}

type WhenClause struct {
	Expr   ExprField
	Result ExprField
}