Have you worked with tools for building SQL queries programmatically?

Yes, there are libraries in Go for programmatically building SQL queries, such as Squirrel or sqlx. They allow you to create queries dynamically, avoiding errors when concatenating strings and simplifying parameter handling.

Example using Squirrel:

import (
    "github.com/Masterminds/squirrel"
    "fmt"
)

func buildQuery() {
    queryBuilder := squirrel.Select("id", "name").From("users").Where(squirrel.Eq{"status": "active"})
    sql, args, err := queryBuilder.ToSql()
    if err != nil {
        panic(err)
    }
    fmt.Println(sql)  // SELECT id, name FROM users WHERE status = ?
    fmt.Println(args) // [active]
}

This approach helps to safely and conveniently formulate queries.