doug-martin/goqu

Health v2 · maintenance only

Adoption not part of the score

2671 stars · 223 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

goqu is an expressive SQL query builder and executor library for Go, supporting multiple database dialects like PostgreSQL, MySQL, SQLite3, and SQL Server. It provides a type-safe DSL for building SELECT, INSERT, UPDATE, and DELETE statements with parameter interpolation and row scanning into structs, while explicitly not being a full ORM.

Use cases

• build SQL queries programmatically in Go
• generate parameterized SQL for postgres, mysql, or sqlite
• scan query results into Go structs or primitive values
• write database-agnostic queries across multiple SQL dialects
• catch SQL construction errors at compile time with an expressive DSL
• interpolate query parameters for debugging logged SQL
• build insert, multi-insert, update, and delete statements

When to choose

• you want programmatic SQL generation without a full ORM's associations and hooks
• you need to target multiple SQL dialects with one query-building API
• you prefer mixing hand-written SQL with builder-generated queries
• you want compile-time safety for common SQL expression construction

When to avoid

• you need ORM features like associations, hooks, or migrations - use gorm instead
• you want to write raw SQL exclusively without a builder layer
• you need every database-specific SQL nuance, since goqu covers only common expressions

Facets

library · maturity stable

database orm serialization databases developer-tools backend go windows cross-platform sql-builder query-builder querybuilder postgresql mysql sqlite sqlserver dialects parameter-interpolation not-an-orm linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="doug-martin/goqu")