ozzo-dbx
A Go package that enhances database/sql with powerful data retrieval methods and DB-agnostic query building.
What is ozzo-dbx?
ozzo-dbx is a Go package that enhances the standard `database/sql` library by adding powerful data retrieval methods and a database-agnostic query builder. It solves the problem of writing repetitive and error-prone SQL code by providing a structured, programmatic way to build and execute queries while maintaining compatibility with major relational databases.
Go developers working with relational databases who need a lightweight, non-ORM tool to simplify query building, reduce boilerplate, and safely interact with SQL databases.
Developers choose ozzo-dbx because it offers a clean, expressive API for database operations without the overhead of a full ORM, keeps them close to SQL, and ensures DB portability with built-in quoting and parameter binding for security.
Overview
A Go (golang) package that enhances the standard database/sql package by providing powerful data retrieval methods as well as DB-agnostic query building capabilities.
Use Cases
Best For
- Building database layers in Go applications without a full ORM
- Writing DB-agnostic SQL queries that work across multiple database systems
- Reducing boilerplate code for CRUD operations in Go
- Safely parameterizing SQL queries to prevent injection attacks
- Programmatically constructing complex SQL conditions and clauses
- Adding structured logging and instrumentation to database queries
Not Ideal For
- Applications requiring automatic relationship management and schema migrations offered by full ORMs
- Projects where database-specific SQL optimizations and features are critical
- Teams that prefer writing raw SQL without any abstraction layer
- Systems needing support for databases outside the core five (SQLite, MySQL, PostgreSQL, MS SQL Server, Oracle)
Pros & Cons
Pros
Populates query results directly into structs, maps, or slices with configurable field mapping using struct tags, reducing boilerplate for data retrieval as shown in the README's examples for populating nested structs.
Programmatically constructs SELECT, INSERT, UPDATE, DELETE queries that work across SQLite, MySQL, PostgreSQL, and others, with automatic table and column quoting for portability, demonstrated in the query building sections.
Uses named parameters like `{:ParamName}` to prevent SQL injection, ensuring safe query execution without manual escaping, as highlighted in the binding parameters section.
Provides Insert, Read, Update, Delete methods on model structs with minimal code, though limited to simple primary keys, as detailed in the CRUD operations part of the README.
Cons
Lacks advanced ORM capabilities such as automatic relationship handling, schema migrations, and lazy loading, which are common in full-featured ORMs like GORM, forcing developers to handle these manually.
Query building only works fully for five databases; the README admits that for other databases, it may not work as expected, requiring custom builder implementation.
CRUD Model methods do not support composite primary keys—for example, SelectQuery.Model() fails here, forcing use of lower-level query building with Where() clauses, as noted in the Read section.
Frequently Asked Questions
Related Projects
sqlcGenerate type-safe code from SQL
SquirrelFluent SQL generation for golang
xoCommand line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
jetType safe SQL builder with code generation and automatic query result data mapping
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.