builq alternatives and similar packages

Based on the "SQL Query Builders" category.
Alternatively, view builq alternatives based on common mentions on social networks and blogs.

Hotcoal

1.1 6.9 builq VS Hotcoal

Hotcoal - Secure your handcrafted SQL against injection

Do you think we are missing an alternative of builq or a related project?

Add another 'SQL Query Builders' Package

README

builq

Easily build queries in Go.

Rationale

The simplest way to represent SQL query is a string. But the query arguments and their indexing ($1, $2 etc) require additional attention. This tiny library helps to build queries and handles parameter indexing.

Features

Simple and easy.
Tested.
Dependency-free.

See GUIDE.md for more details.

Install

Go version 1.19+

go get github.com/cristalhq/builq

Example

cols := builq.Columns{"foo, bar"}

var b builq.Builder
b.Addf("SELECT %s FROM %s", cols, "users").
    Addf("WHERE active IS TRUE").
    Addf("AND user_id = %$ OR user = %$", 42, "root")

query, args, err := b.Build()
if err != nil {
    panic(err)
}

fmt.Printf("query:\n%v", query)
fmt.Printf("args:\n%v", args)

// Output:
//
// query:
// SELECT foo, bar FROM users
// WHERE active IS TRUE
// AND user_id = $1 OR user = $2
// args:
// [42 root]

See examples: examples_test.go.