reifydb-sql 0.4.11

// SPDX-License-Identifier: Apache-2.0
// Copyright (c) 2025 ReifyDB

#[derive(Debug, Clone)]
pub enum Statement {
	Select(Box<SelectStatement>),
	Insert(InsertStatement),
	Update(UpdateStatement),
	Delete(DeleteStatement),
	CreateTable(CreateTableStatement),
	CreateIndex(CreateIndexStatement),
	DropTable(DropTableStatement),
}

#[derive(Debug, Clone)]
pub struct CteDefinition {
	pub name: String,
	pub query: SelectStatement,
}

#[derive(Debug, Clone)]
pub struct SelectStatement {
	pub ctes: Vec<CteDefinition>,
	pub distinct: bool,
	pub columns: Vec<SelectColumn>,
	pub from: Option<FromClause>,
	pub joins: Vec<JoinClause>,
	pub where_clause: Option<Expr>,
	pub group_by: Vec<Expr>,
	pub having: Option<Expr>,
	pub order_by: Vec<OrderByItem>,
	pub limit: Option<u64>,
	pub offset: Option<u64>,
	pub set_op: Option<(SetOp, Box<SelectStatement>)>,
}

#[derive(Debug, Clone)]
pub enum SetOp {
	Union,
	UnionAll,
	Intersect,
	Except,
}

#[derive(Debug, Clone)]
pub enum SelectColumn {
	AllColumns,
	Expr {
		expr: Expr,
		alias: Option<String>,
	},
}

#[derive(Debug, Clone)]
pub enum FromClause {
	Table {
		name: String,
		shape: Option<String>,
		alias: Option<String>,
	},
	Subquery(Box<SelectStatement>),
}

#[derive(Debug, Clone)]
pub struct JoinClause {
	pub join_type: JoinType,
	pub table: FromClause,
	pub table_alias: Option<String>,
	pub on: Expr,
}

#[derive(Debug, Clone)]
pub enum JoinType {
	Inner,
	Left,
	Cross,
}

#[derive(Debug, Clone)]
pub struct OrderByItem {
	pub expr: Expr,
	pub direction: OrderDirection,
}

#[derive(Debug, Clone)]
pub enum OrderDirection {
	Asc,
	Desc,
}

#[derive(Debug, Clone)]
pub struct InsertStatement {
	pub table: String,
	pub shape: Option<String>,
	pub columns: Vec<String>,
	pub source: InsertSource,
}

#[derive(Debug, Clone)]
pub enum InsertSource {
	Values(Vec<Vec<Expr>>),
	Select(Box<SelectStatement>),
}

#[derive(Debug, Clone)]
pub struct UpdateStatement {
	pub table: String,
	pub shape: Option<String>,
	pub assignments: Vec<(String, Expr)>,
	pub where_clause: Option<Expr>,
}

#[derive(Debug, Clone)]
pub struct DeleteStatement {
	pub table: String,
	pub shape: Option<String>,
	pub where_clause: Option<Expr>,
}

#[derive(Debug, Clone)]
pub struct CreateTableStatement {
	pub table: String,
	pub shape: Option<String>,
	pub columns: Vec<Column>,
	pub primary_key: Vec<String>,
	pub if_not_exists: bool,
}

#[derive(Debug, Clone)]
pub struct CreateIndexStatement {
	pub unique: bool,
	pub index_name: String,
	pub table: String,
	pub shape: Option<String>,
	pub columns: Vec<IndexColumn>,
}

#[derive(Debug, Clone)]
pub struct IndexColumn {
	pub name: String,
	pub direction: Option<OrderDirection>,
}

#[derive(Debug, Clone)]
pub struct DropTableStatement {
	pub table: String,
	pub shape: Option<String>,
	pub if_exists: bool,
}

#[derive(Debug, Clone)]
pub struct Column {
	pub name: String,
	pub data_type: SqlType,
	pub nullable: bool,
}

#[derive(Debug, Clone)]
pub enum SqlType {
	Int,
	Int2,
	Int4,
	Int8,
	Smallint,
	Integer,
	Bigint,
	Float4,
	Float8,
	Real,
	Double,
	Boolean,
	Bool,
	Varchar(Option<u64>),
	Char(Option<u64>),
	Text,
	Utf8,
	Blob,
	FloatType,
	Numeric,
}

#[derive(Debug, Clone)]
pub enum Expr {
	Identifier(String),
	QualifiedIdentifier(String, String),
	IntegerLiteral(i64),
	FloatLiteral(f64),
	StringLiteral(String),
	BoolLiteral(bool),
	Null,
	BinaryOp {
		left: Box<Expr>,
		op: BinaryOp,
		right: Box<Expr>,
	},
	UnaryOp {
		op: UnaryOp,
		expr: Box<Expr>,
	},
	FunctionCall {
		name: String,
		args: Vec<Expr>,
	},
	Between {
		expr: Box<Expr>,
		low: Box<Expr>,
		high: Box<Expr>,
		negated: bool,
	},
	InList {
		expr: Box<Expr>,
		list: Vec<Expr>,
		negated: bool,
	},
	InSelect {
		expr: Box<Expr>,
		subquery: Box<SelectStatement>,
		negated: bool,
	},
	IsNull {
		expr: Box<Expr>,
		negated: bool,
	},
	Cast {
		expr: Box<Expr>,
		data_type: SqlType,
	},
	Nested(Box<Expr>),
	Case {
		operand: Option<Box<Expr>>,
		when_clauses: Vec<(Expr, Expr)>,
		else_clause: Option<Box<Expr>>,
	},
	Exists(Box<SelectStatement>),
	Subquery(Box<SelectStatement>),
	Like {
		expr: Box<Expr>,
		pattern: Box<Expr>,
		negated: bool,
	},
}

#[derive(Debug, Clone)]
pub enum BinaryOp {
	Eq,
	NotEq,
	Lt,
	Gt,
	LtEq,
	GtEq,
	And,
	Or,
	Add,
	Sub,
	Mul,
	Div,
	Mod,
	Concat,
}

#[derive(Debug, Clone)]
pub enum UnaryOp {
	Not,
	Neg,
}