Dew
Dew: A free Go library for typed SQL queries without an ORM. Ranked #41 of 51 in Database Query Builders by our editors (4.9/10); pricing: Free plan; best for go developers wanting a free typed query builder.
At a glance
- Editor score4.9 / 10
- PricingFree plan
- Best forGo developers wanting a free typed query builder
- Free planYes
- Paid fromNone
- Type safetyStatic
- Facts checked4 Oct 2026
Where it wins
- Defines schemas and typed columns from Go structs
- Builds CRUD, joins, subqueries, and aggregate queries
- Supports PostgreSQL, MySQL, SQLite, and MSSQL
Where it doesn't
- Focused on Go rather than multiple programming languages
- Raw SQL expressions mean some queries leave the typed builder
- No ORM layer for developers who want ORM-managed access
Our verdict on Dew
Dew is an open-source Go library for composing and executing database queries without an ORM. It is aimed at Go developers who want statically typed schemas and query construction while retaining direct control over database access. Schemas and typed columns come from Go structs, and a fluent API covers SELECT, INSERT, UPDATE, and DELETE operations. For teams that prefer explicit SQL-oriented code to ORM abstractions, Dew offers a focused option; developers seeking an ORM or a builder for another language should look elsewhere.
Its breadth extends beyond basic CRUD. Dew supports filters, ordering, limits, offsets, joins, nested queries, subqueries, and aggregates including COUNT, SUM, AVG, MAX, and MIN. Builders can run through database connections or transactions, and raw SQL expressions provide an escape hatch when the builder does not cover an expression. Generated SQL and arguments can also be obtained without executing a SELECT, which can suit workflows that need to inspect or pass along query output. That flexibility comes with a tradeoff: raw SQL gives developers more control but moves some work outside the typed builder.
The published product information lists PostgreSQL, MySQL, SQLite, and MSSQL dialects, with database access through Go’s database/sql drivers. Installation is via Go modules, and the product is free. Its scope fits solo developers and small to mid-market teams working in Go that want typed query composition across these dialects without adopting an ORM. It is less suitable for projects needing broad language support or ORM-managed data access. Buyers evaluating a wider application platform should compare alternatives; Dew’s focus is query building and execution in Go.
Your product? Our editors can test Dew in depth and publish a review, labelled as paid · from $99/mo →
Dew pricing
Dew fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Languages | Go |
| SQL dialects | PostgreSQL, MySQL, SQLite, MSSQL |
| Type safety | Static |
| Async queries | Yes |
| Raw SQL support | Yes |
| Compile without execution | Yes |
| Built for | Solo, Small business, Mid-market (editorial estimate) |
| Pricing | Free plan |
| Website | dew.xenous.org |
| Facts checked | 4 Oct 2026 |
Alternatives to Dew
- jOOQA fluent SQL framework for JVM teams that want generated, type-safe database access.9.3
- SQLAlchemySQL construction, ORM, and database services for Python applications.9.1
- JetBrains ExposedA free, open-source Kotlin library with a type-safe SQL DSL and JDBC and R2DBC access.9.0
Used Dew? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Dew for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Dew is listed in our Database Query Builders directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/dew/"><img src="https://www.itechguides.com/best/badge/dew.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
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