builder

type Builder interface {
	Insert(data map[string]interface{}) Builder
	Update(data map[string]interface{}) Builder
	Upsert(data map[string]interface{}) Builder
	Delete() Builder
	Explain() Builder
	Select(field string) Builder
	Table(table string, alias ...string) Builder
	From(table string, alias ...string) Builder
	Join(table string, on string, alias ...string) Builder
	LeftJoin(table string, on string, alias ...string) Builder
	RightJoin(table string, on string, alias ...string) Builder
	Statement(stmt string, values []interface{}) Builder
	In(in map[string]interface{}) Builder
	InSingleProp(prop string, data interface{}) Builder
	Exists(other Builder, condition Condition) Builder
	Alias(name string) string
	Compare(conditions []Condition) Builder
	CompareSingleProp(condition Condition) Builder
	NotEqual(column string, value interface{}) Builder
	Equal(column string, value interface{}) Builder
	BetweenTime(column string, from, to time.Time) Builder
	Next(id int64) Builder
	Page(index int) Builder
	Size(n int) Builder
	Order(column, direction string) Builder
	Orders(orders map[string]interface{}) Builder
	Group(column string) Builder
	Groups(column []string) Builder
	And() Builder
	Or() Builder
	Not(Builder) Builder
	Status() (int, int, int)
	Reset(section string) Builder
	Build() (string, []interface{})
}

type Condition struct {
	Operator string
	Key      string
	Value    interface{}
}

type Merge struct {
	Type      transformer.Type
	Track     string //identifier to check duplicates - or condition
	Operation MergeOperation
}

type MergeOperation int

type QueryParams struct {
	Object       interface{}
	In           map[string]interface{}
	Notin        map[string]interface{}
	Conditions   []Condition
	Next         int64
	Page         int
	Size         int
	Orderby      map[string]interface{}
	Groupby      []string
	ColumnFilter []string
	Priority     []string
	Merge        *Merge
	BetweenTime  map[string][]time.Time
	IsDistinct   bool
}

type Scanner func(args ...interface{}) error