Take a look at github.com/wroge/esquel.
superbasic.Compile compiles expressions into an SQL template and thus offers an alternative to conventional query builders.
Compilereplaces placeholders?with expressions.Joinjoins expressions by a separator.
create := superbasic.Compile("CREATE TABLE presidents (\n\t?\n)",
superbasic.Join(",\n\t",
superbasic.SQL("nr SERIAL PRIMARY KEY"),
superbasic.SQL("first TEXT NOT NULL"),
superbasic.SQL("last TEXT NOT NULL"),
),
)
fmt.Println(create.ToSQL())
// CREATE TABLE presidents (
// nr SERIAL PRIMARY KEY,
// first TEXT NOT NULL,
// last TEXT NOT NULL
// )Mapis a generic mapper function particularly helpful in the context of Join.Finalizereplaces?placeholders with a string that can contain a positional part by%d.
presidents := []President{
{"George", "Washington"},
{"John", "Adams"},
}
insert := superbasic.Join(" ",
superbasic.SQL("INSERT INTO presidents (first, last)"),
superbasic.Compile("VALUES ?",
superbasic.Join(", ",
superbasic.Map(presidents,
func(_ int, president President) superbasic.Expression {
return superbasic.Values{president.First, president.Last}
})...,
),
),
superbasic.SQL("RETURNING nr"),
)
fmt.Println(superbasic.Finalize("$%d", insert))
// INSERT INTO presidents (first, last) VALUES ($1, $2), ($3, $4) RETURNING nr [George Washington John Adams]Ifcondition is true, return expression, else skip.Switchreturns an expression matching a value.
dialect := "sqlite"
contains := "Joe"
query := superbasic.Join(" ", superbasic.SQL("SELECT * FROM presidents"),
superbasic.If(contains != "", superbasic.Compile("WHERE ?",
superbasic.Switch(dialect,
superbasic.Case("postgres", superbasic.SQL("POSITION(? IN presidents.first) > 0", contains)),
superbasic.Case("sqlite", superbasic.SQL("INSTR(presidents.first, ?) > 0", contains)),
))))
fmt.Println(superbasic.Finalize("?", query))
// SELECT * FROM presidents WHERE INSTR(presidents.first, ?) > 0 [Joe] <nil>To scan rows to types, i recommend wroge/scan.