qbey review
A flexible Rust query builder with bind values and safeguards for unfiltered writes.
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
qbey is an open-source Rust library for composing SQL statements, aimed at developers who want to build queries dynamically rather than execute them through the library. It covers SELECT, INSERT, UPDATE, and DELETE, with conditional WHERE clauses and support for joins, grouping, HAVING, unions, and subqueries. Its optional schema macro generates typed, qualified column accessors for compile-time checked references. For Rust teams working directly with SQL and database drivers, qbey offers a focused way to assemble statements while retaining control over execution.
The query-building features extend beyond basic filters. qbey generates SQL text alongside bind parameters, and a RawSql wrapper provides an escape hatch for embedding SQL expressions. A dialect trait lets developers customize placeholder styles and identifier quoting; an optional MySQL extension adds MySQL-specific syntax. The library is driver-agnostic, with integrations or documented testing involving sqlx, rusqlite, tokio-postgres, and postgres. These capabilities suit projects that need to compose queries across different driver contexts, though teams seeking a builder that also runs queries will need a separate execution layer.
A notable safety measure guards UPDATE and DELETE statements against missing WHERE conditions by default, reducing the risk of unintentionally broad writes. qbey is open source, self-hosted, and available for Linux, macOS, and Windows, with community support. The published category details identify Rust as its language and type safety as optional. This makes qbey a reasonable fit for solo developers and small or mid-market Rust teams that value flexible SQL composition and can manage their own execution and support. Teams requiring built-in async query execution or broad, ready-made dialect coverage should consider alternatives.
qbey pros and cons
- Where it wins
- Composes SELECT, INSERT, UPDATE, and DELETE statements with conditional clauses
- Supports joins, grouping, unions, subqueries, and bind parameters
- Blocks UPDATE and DELETE statements without WHERE conditions by default
- Where it doesn't
- Generates SQL but does not execute queries
- Async queries are not supported
- MySQL-specific syntax is provided through an extension
qbey 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