How masterminds/squirrel works
Squirrel is a fluent Go SQL generator, not an ORM. Callers compose SELECT, INSERT, UPDATE, DELETE, and CASE expressions, then serialize them into SQL plus bound arguments or execute them through a supplied database runner. Expression predicates and placeholder formatting support composable queries and PostgreSQL-style placeholders; optional context-aware runners and prepared-statement caching extend execution. The graph follows only relationships visible in excerpts or documented by the README; some builder internals and individual query execution paths were not sampled.
Main entry points: select.go SELECT builder · statement.go Statement entrypoints · squirrel.go Runner interfaces · update.go UPDATE builder
Components 16
Builder API
- Statement entrypoints
statement.go - SELECT builder
select.go - INSERT builder
insert.go - UPDATE builder
update.go - DELETE builder
delete.go - CASE expressions
case.go
SQL Composition
- SQL expressions
expr.go - Predicate parts
where.go - SQL parts
part.go - Placeholder formats
placeholder.go
Execution
- Runner interfaces
squirrel.go - Context runners
squirrel_ctx.go - Row scanner
row.go - Prepared statement cache
stmtcacher.go
Other components
- Go caller
- SQL database
Connections 32
- Go caller → Statement entrypoints: starts builders
README.md - Go caller → SELECT builder: composes SELECT
README.md - Go caller → INSERT builder: composes INSERT
README.md - Statement entrypoints → SELECT builder: creates
statement.go - Statement entrypoints → INSERT builder: creates
statement.go - Statement entrypoints → UPDATE builder: creates
statement.go - Statement entrypoints → DELETE builder: creates
statement.go - Statement entrypoints → CASE expressions: creates
statement.go - SELECT builder → Predicate parts: adds predicates
select.go - DELETE builder → Predicate parts: adds predicates
delete.go - UPDATE builder → SELECT builder: accepts subquery
update.go - SELECT builder → SQL expressions: uses expressions
expr.go - INSERT builder → SQL expressions: uses expressions
insert.go - UPDATE builder → SQL expressions: uses expressions
update.go - DELETE builder → SQL expressions: uses expressions
delete.go - CASE expressions → SQL parts: wraps parts
case.go - Predicate parts → SQL parts: builds parts
where.go - SQL expressions → Placeholder formats: formats placeholders
expr.go - SELECT builder → Placeholder formats: formats placeholders
select.go - INSERT builder → Placeholder formats: formats placeholders
insert.go - UPDATE builder → Placeholder formats: formats placeholders
update.go - DELETE builder → Placeholder formats: formats placeholders
delete.go - SELECT builder → Runner interfaces: executes via
- INSERT builder → Runner interfaces: executes via
insert.go - UPDATE builder → Runner interfaces: executes via
update.go - DELETE builder → Runner interfaces: executes via
delete.go - Runner interfaces → SQL database: runs SQL
squirrel.go - Context runners → SQL database: runs context SQL
squirrel_ctx.go - Runner interfaces → Row scanner: wraps query row
squirrel.go - Prepared statement cache → SQL database: prepares statements
stmtcacher.go - Go caller → Prepared statement cache: may configure
README.md - Go caller → Context runners: may use context
squirrel_ctx.go