sq

Fluent SQL generator for Go and PostgreSQL.

package main

import (
	"context"
	"log"

	"github.com/silas/sq"
)

func main() {
	ctx := context.Background()
	pool, err := sq.Connect(ctx, "postgresql://postgres:[email protected]:5432/postgres")
	if err != nil {
		log.Fatal(err)
	}

	qb := sq.Select("user").
		From("user").
		Limit(1)

	var user string
	err = pool.Tx(ctx, func(tx sq.Tx) error {
		return tx.QueryRow(ctx, qb).Scan(&user)
	})
	if err != nil {
		log.Fatal(err)
	}

	println(user)
}

This is a fork of sqrl.

NOTE: The API for this library is not yet stable, expect breaking changes.