builder

type Builder interface {
	// Builds returns generated SQL and parameters.
	Build() (string, []interface{}, error)
}

type DefaultValue struct{}

type Deleter interface {
	Builder
	With(name string, q Builder) Deleter
	Using(using string) Deleter
	Where(where string, params ...interface{}) Deleter
	Returning(returning ...string) Deleter
}

type Insecter interface {
	Builder
	Columns(col ...string) Insecter
	Values(params ...interface{}) Insecter
	Where(where string, params ...interface{}) Insecter
	Returning(returning ...string) Insecter
}

type Inserter interface {
	Builder
	With(name string, q Builder) Inserter
	Columns(col ...string) Inserter
	Values(params ...interface{}) Inserter
	From(q Selecter) Inserter
	OnConflictDoNothing(target string, params ...interface{}) Inserter
	Returning(returning ...string) Inserter
}

type Selecter interface {
	Builder
	With(name string, q Builder) Selecter
	Columns(col string, params ...interface{}) Selecter
	From(from string, params ...interface{}) Selecter
	Where(where string, params ...interface{}) Selecter
	Union(all bool, q Selecter) Selecter
	Offset(offset uint64) Selecter
	Limit(limit uint64) Selecter
	Distinct(distinct ...string) Selecter
	GroupBy(groupBy string) Selecter
	Having(having string, params ...interface{}) Selecter
	OrderBy(orderBy string) Selecter
	For(locking string) Selecter
}

type Updater interface {
	Builder
	With(name string, q Builder) Updater
	From(from string, params ...interface{}) Updater
	Set(set string, params ...interface{}) Updater
	Where(where string, params ...interface{}) Updater
	Returning(returning ...string) Updater
}

type Upserter interface {
	Builder
	With(name string, q Builder) Upserter
	Columns(col ...string) Upserter
	Values(params ...interface{}) Upserter
	From(q Selecter) Upserter
	Update(update string, params ...interface{}) Upserter // unless specified, Columns with EXCLUDED values used
	Returning(returning ...string) Upserter
}