Adjustable Queries #57
Description
Requirements
- Not all columns may be used in queries.
WHEREclause used in statements must be adjustable. Default forDELETEfor example isid IN (?)at the moment.- Executed query should be replaceable, e.g.
ON DUPLICATE KEYmay specifycol = col + VALUES(col). - All functionality shall be usable w/o building custom types, e.g. table name, columns as
string,[]string.
Possible API
// Using query builder directly
sql := NewQueryBuilder(db, subject).SetColumns(columns).Insert()
db.NamedBulkExec(ctx, sql, ch)
// Functional options
db.Upsert(ctx, ch, options.SetColumns(columns))
// Using query builder directly #2
upsert := qb.Upsert(subject).Columns(columns)
db.NamedBulkExec(ctx, upsert, ch)
// or
upsert.Stream(ctx, db, ch)
db.Upsert().Columns(columns).Exec() // .Stream()
qb.Upsert().Columns().Exec(ctx, db, setofData) // .Stream(ctx, db, ch)