mysql

type DeleteBuilder interface {
	Table(name string) DeleteBuilder
	Where(query string, args ...any) DeleteBuilder
	Or(query string, args ...any) DeleteBuilder
	ToSql() string
}

type InsertBuilder interface {
	Table(name string) InsertBuilder
	Columns(col ...string) InsertBuilder
	AppendValues(v ...any) InsertBuilder
	ToSql() string
}

type SelectBuilder interface {
	Table(query string) SelectBuilder
	Select(column ...string) SelectBuilder
	Joins(query string, args ...any) SelectBuilder
	Where(query string, args ...any) SelectBuilder
	Having(query string, args ...any) SelectBuilder
	Or(query string, args ...any) SelectBuilder
	Group(name string) SelectBuilder
	Order(v string) SelectBuilder
	PageLimit(page, limit int) SelectBuilder
	ToCountSql() string
	ToSql() string
}

type UpdateBuilder interface {
	Table(name string) UpdateBuilder
	Where(query string, args ...any) UpdateBuilder
	Or(query string, args ...any) UpdateBuilder
	Update(column string, v any) UpdateBuilder
	ToSql() string
}