Masterminds/squirrel

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

7979 stars · 511 forks observed · 2026-08-28

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

Squirrel is a fluent SQL query builder library for Go that composes SELECT, INSERT, UPDATE, and DELETE statements from reusable parts. It is explicitly not an ORM; it generates SQL and placeholder arguments and can execute queries via database/sql.

Use cases

• build sql queries programmatically in go
• compose conditional where clauses dynamically
• generate postgres queries with dollar placeholders
• avoid string-concatenating sql statements
• build insert statements with multiple values
• cache prepared statements in go

When to choose

• you want composable, type-safe-ish SQL generation without a full ORM
• you need dynamic query building based on runtime conditions
• you target PostgreSQL and want placeholder formatting handled for you

When to avoid

• you want an ORM with struct-to-table mapping and migrations
• you need a project under active feature development - Squirrel is declared complete and in maintenance
• you prefer raw SQL or a query builder for another language

Facets

library · maturity maintenance

database orm serialization databases developer-tools backend go windows cross-platform sql-builder query-builder fluent-api postgresql not-an-orm linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="Masterminds/squirrel")