dialects

type AlterTableQuery struct {
	Table         string
	DropColumns   []string
	ModifyColumns []ColumnDefinition
	AddColumns    []ColumnDefinition
	ForeignKeys   []ForeignKey
	Indexes       []Index
}

type AlterTableQueryBuilder interface {
	AlterTableQuery() *AlterTableQuery
}

type Column struct {
	Column   string
	Function *FunctionCall
	SubQuery QueryBuilder
	Raw      string

	As string
}

type ColumnDefinition struct {
	Name               string
	Datatype           DataType
	Nullable           bool
	Primary            bool
	AutoIncrement      bool
	DefaultValue       any
	Unique             bool
	DefaultCurrentTime bool
}

type Condition struct {
	Column   Column
	Operator string
	Value    any
	Or       bool
}

type CreateTableQuery struct {
	IfNotExists bool
	Temporary   bool
	Table       string
	Columns     []ColumnDefinition
	PrimaryKeys []string
	ForeignKeys []ForeignKey
	Indexes     []Index
}

type CreateTableQueryBuilder interface {
	CreateTableQuery() *CreateTableQuery
}

type DataType struct {
	Name string
	Size int
}

type DataTyper interface {
	DataType() DataType
}

type DeleteQuery struct {
	Table  string
	Wheres []Condition
}

type DeleteQueryBuilder interface {
	DeleteQuery() *DeleteQuery
}

type Dialect interface {
	EncodeSelectQuery(q *SelectQuery) (RawQuery, error)
	EncodeInsertQuery(q *InsertQuery) (RawQuery, error)
	EncodeUpdateQuery(q *UpdateQuery) (RawQuery, error)
	EncodeDeleteQuery(q *DeleteQuery) (RawQuery, error)
	EncodeCreateTableQuery(q *CreateTableQuery) (RawQuery, error)
	EncodeDropTableQuery(q *DropTableQuery) (RawQuery, error)
	EncodeAlterTableQuery(q *AlterTableQuery) (RawQuery, error)
	Features() Features
}

type DropTableQuery struct {
	Table    string
	IfExists bool
}

type DropTableQueryBuilder interface {
	DropTableQuery() *DropTableQuery
}

type Features struct {
	// Returning indicates the dialect supports the RETURNING clause on INSERT,
	// UPDATE, and DELETE statements.
	Returning bool
}

type ForUpdate string

type ForeignKey struct {
	Name           string
	Columns        []string
	ForeignTable   string
	ForeignColumns []string
}

type FunctionCall struct {
	Name      string
	Arguments string
}

type Index struct {
	Name    string
	Table   string
	Columns []string
	Unique  bool
}

type InsertQuery struct {
	Table     string
	Values    []map[string]any
	Returning []string
}

type InsertQueryBuilder interface {
	InsertQuery() *InsertQuery
}

type Join struct {
	Direction  string
	Table      string
	Conditions []Condition
}

type Limit struct {
	Limit  int
	Offset int
}

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

type MultiQueryBuilder interface {
	MultiQuery() []MultiQuery
}

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

type OrderColumn struct {
	Column     string
	Descending bool
}

type QueryBuilder interface {
	Query() *SelectQuery
}

type RawQuery struct {
	SQL      string
	Bindings []any
}

type RawString string

type Select struct {
	Distinct bool
	Columns  []Column
}

type SelectQuery struct {
	Select    Select
	From      string
	Joins     []Join
	Wheres    []Condition
	Havings   []Condition
	GroupBys  []string
	OrderBys  []OrderColumn
	Limit     Limit
	ForUpdate ForUpdate
}

type UpdateQuery struct {
	Table     string
	Values    map[string]any
	Returning []Column
	Wheres    []Condition
}

type UpdateQueryBuilder interface {
	UpdateQuery() *UpdateQuery
}