sql

type Condition struct {
	Field    string           // Field name
	Operator string           // "=", ">", "<", ">=", "<=", "!=", "LIKE", "IN", "NOT IN", "IS NULL", "IS NOT NULL"
	Value    any              // Single value
	Values   []any            // Multiple values for IN clause
	Subquery *SelectStatement // Subquery for IN/EXISTS clauses
}

type DeleteStatement struct {
	Table string
	Where *WhereClause
}

type InsertStatement struct {
	Table  string
	Fields []string
	Values [][]any // Multiple rows of values
}

type JoinClause struct {
	Type      JoinType
	Table     TableRef
	Condition *WhereClause
}

type JoinType int

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

type OrderByClause struct {
	Field     string
	Direction OrderDirection
}

type OrderDirection int

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

type SQLStatement interface {
	GetType() StatementType
	GetTableName() string
}

type SelectField struct {
	Expression string // Field name or expression
	Alias      string // Optional alias
}

type SelectStatement struct {
	Fields  []SelectField
	From    TableRef
	Where   *WhereClause
	OrderBy []*OrderByClause
	GroupBy []string
	Having  *WhereClause
	Limit   *int
	Offset  *int
	Joins   []*JoinClause
}

type StatementType int

type TableRef struct {
	Table string // Table name
	Alias string // Optional alias
}

type Token struct {
	Type    TokenType
	Literal string
	Line    int
	Column  int
}

type TokenType int

type UpdateStatement struct {
	Table string
	Set   map[string]any
	Where *WhereClause
}

type WhereClause struct {
	Operator  string       // "AND", "OR", "NOT"
	Left      *WhereClause // Left operand for logical operators
	Right     *WhereClause // Right operand for logical operators
	Condition *Condition   // Leaf condition
}