builder

type Binds map[string]string

type Columns interface {
	// Add columns to the list.
	Add(...string) Columns

	// String convert Columns to string.
	String() string

	// Len says the size of the string.
	Len() int

	// Reset resets the list of columns.
	Reset()
}

type Delete struct {
	Table string
	Where Where
}

type GroupBy interface {
	Columns
}

type H map[string]any

type Having interface {
	Where
}

type Insert struct {
	Table      string
	Select     Select
	IgnoreMode bool
	Values     H

	OnUpdateKeys    Keys
	OnUpdateRawKeys RawKeys
	// contains filtered or unexported fields
}

type Join struct {
	Table string
	Type  string
	On    On
}

type Joins []Join

type Keys []string

type On interface {
	Where
}

type OrderBy interface {
	Columns
}

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

type RawKeys map[string]string

type Select struct {
	Table   string
	Columns Columns
	Joins   Joins
	Where   Where
	Having  Having
	GroupBy GroupBy
	OrderBy OrderBy
	Limit   uint64
	Offset  uint64
}

type Slicer interface {
	Len() int
	S() []any
}

type Update struct {
	Table  string
	Values H
	Binds  Binds
	Joins  Joins
	Where  Where
}

type Where interface {
	// Args return the arguments of the where.
	Args() []any

	// String convert Where to string.
	String() string

	// And add a new condition "AND".
	And(str string, args ...any) Where

	// AndIf a new condition "AND" if args is Valid & and not Zero.
	AndIf(str string, arg any) Where

	// AndIn add a new condition "AND" with the operator IN.
	AndIn(col string, s Slicer) Where

	// AndNotIn add a new condition "AND" with the operator NOT IN.
	AndNotIn(col string, s Slicer) Where

	// AndWhere merge Where's inside parenthesis with AND condition.
	// AND ( where )
	AndWhere(in ...Where) Where

	// Or add a new condition "OR".
	Or(str string, args ...any) Where

	// OrIf a new condition "or" if args is Valid & and not Zero.
	OrIf(str string, arg any) Where

	// OrIn add a new condition "OR" with the operator IN.
	OrIn(col string, s Slicer) Where

	// OrNotIn add a new condition "OR" with the operator NOT IN.
	OrNotIn(col string, s Slicer) Where

	// OrWhere merge Where's inside parenthesis with OR condition.
	// OR ( where )
	OrWhere(in ...Where) Where

	// Len says the length of the string.
	Len() int
}