gsql review
Typed CRUD and upsert builders for Go, with SQL generation and database/sql execution.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
For Go developers who want typed SQL construction inside their applications, gsql is an open-source library built on Go’s database/sql package. It defines tables and columns with generics, then offers fluent builders for common query work. This makes it relevant to teams that want compile-time checking without code generation, whether working solo or in a larger organization. It is a library to incorporate into a Go application, not a hosted database tool.
The builder surface covers SELECT, WHERE, JOIN, ORDER BY, LIMIT and OFFSET, along with INSERT, bulk INSERT, UPSERT, UPDATE and DELETE. Build() returns SQL text and parameter arguments without executing a query, so developers can inspect generated statements separately from running them. Values are parameterized and identifiers are validated. Execution is available through Go database/sql interfaces, including *sql.DB and *sql.Tx. The listed dialects are PostgreSQL, MySQL and SQLite, so projects using other SQL dialects may need another approach.
The project is open source, with a free plan and MIT licensing identified on its package page; the published information describes no commercial pricing. Deployment is self-hosted, which fits developers who prefer a library integrated into their own Go code rather than a managed service. Support is through documentation. gsql is a focused choice for teams prioritizing typed CRUD query construction and explicit SQL generation; it is less suited to projects needing broad dialect coverage, a raw SQL escape hatch, or support beyond documentation.
gsql pros and cons
- Where it wins
- Uses Go generics for compile-time checks of column and value types
- Build() exposes SQL text and parameter arguments before execution
- Supports CRUD and upsert builders with database/sql execution
- Where it doesn't
- Dialect coverage is limited to PostgreSQL, MySQL, and SQLite
- No raw SQL escape hatch is listed
- Support is through documentation
gsql fact sheet, pricing and score →
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. How we rank.
Last updated · How we research and update