sqlr

Aug 2, 2026

Changes in this version

type Builder

+ func (b *Builder) BindMap(values map[string]any) *Builder

+ func (b *Builder) BindNamed(values NamedBinder) *Builder

+ func (b *Builder) BindRows(name string, rows RowSource) *Builder

+ func (b *Builder) BindValue(name string, value any) *Builder

+ type GeneratedScanPlan interface

+ SQLRNeedsSinks func() bool

+ SQLRScanTargets func(destination any, targets []any, sinks []any) error

+ type NamedBinder interface

+ SQLRBindValue func(name string) (value any, found bool, err error)

+ type NamedRowsBinder interface

+ SQLRBindRows func(name string) (rows RowSource, found bool, err error)

+ type RowSource interface

+ Len func() int

+ SQLRAppendRow func(row int, columns []string, args []any) ([]any, error)

type SQLR

+ func (s *SQLR) Compile(query string) (*Template, error)

+ func (s *SQLR) MustCompile(query string) *Template

+ type ScanPlanner interface

+ SQLRScanPlan func(columns []string) (GeneratedScanPlan, error)

+ type Template struct

+ func (t *Template) Bind(args ...any) *Builder

+ func (t *Template) BindMap(values map[string]any) *Builder

+ func (t *Template) BindNamed(values NamedBinder) *Builder

+ func (t *Template) BindRows(name string, rows RowSource) *Builder

+ func (t *Template) BindValue(name string, value any) *Builder

+ func (t *Template) Builder() *Builder

+ func (t *Template) SQL() string

Sep 1, 2025

Changes in this version

+ var ErrBuilderReleased = errors.New("sqlr: builder already released; call Write() on *SQLR for a new query")

+ var ErrColumnNotFound = errors.New("sqlr: column not found")

+ var ErrFieldAmbiguous = errors.New("sqlr: ambiguous field name")

+ var ErrMoreThanOneRow = errors.New("sqlr: more than one row")

+ var ErrParamMissing = errors.New("sqlr: missing parameter")

+ var ErrParamNameTooLong = errors.New("sqlr: parameter name too long")

+ var ErrRowsEmpty = errors.New("sqlr: empty rows")

+ var ErrRowsMalformed = errors.New("sqlr: malformed :rows placeholder")

+ var ErrSliceEmpty = errors.New("sqlr: empty slice")

+ var ErrTooManyParams = errors.New("sqlr: too many parameters")

+ func Scalar(v any) any

+ type Builder struct

+ func (b *Builder) Bind(args ...any) *Builder

+ func (b *Builder) Build() (string, []any, error)

+ func (b *Builder) Exec(db Execer) (sql.Result, error)

+ func (b *Builder) ExecContext(ctx context.Context, db Execer) (sql.Result, error)

+ func (b *Builder) Preview() (string, []any, error)

+ func (b *Builder) Release()

+ func (b *Builder) ScanAll(db Queryer, dest any) error

+ func (b *Builder) ScanAllContext(ctx context.Context, db Queryer, dest any) error

+ func (b *Builder) ScanOne(db Queryer, dest any) error

+ func (b *Builder) ScanOneContext(ctx context.Context, db Queryer, dest any) error

+ func (b *Builder) Write(sql string) *Builder

+ func (b *Builder) Writef(format string, args ...any) *Builder

+ type Config struct

+ MaxNameLen int

+ MaxParams int

+ type Dialect int

+ const MySQL

+ const Postgres

+ const SQLServer

+ const SQLite

+ func (d Dialect) String() string

+ type Execer interface

+ ExecContext func(ctx context.Context, query string, args ...any) (sql.Result, error)

+ type P = map[string]any

+ type Queryer interface

+ QueryContext func(ctx context.Context, query string, args ...any) (*sql.Rows, error)

+ type SQLR struct

+ func New(dialect Dialect, cfg ...Config) *SQLR

+ func (s *SQLR) Write(sql string) *Builder