sq
A code-generated, type-safe SQL query builder and struct mapper for Go that eliminates magic strings and boilerplate.
What is sq?
sq (Structured Query) is a Go library that provides a type-safe query builder and struct mapper on top of database/sql. It generates Go structs from your database schema to eliminate magic strings in queries and automate the mapping of SQL results to Go variables, reducing boilerplate code. The library focuses on making SQL querying in Go pleasant and efficient by improving null handling and ensuring queries reflect the actual database structure.
Go developers working with PostgreSQL or MySQL who need a type-safe, non-ORM way to build SQL queries and map results directly to structs without manual row scanning. It is particularly suited for projects where database schema changes are frequent and safety from typos is critical.
Developers choose sq over alternatives because it generates type-safe table and column definitions from the database, eliminating magic strings and schema mismatches. Its unique selling point is that the SELECT clause directly maps to Go variables automatically, removing the need for repetitive scanning code or struct tags, while providing better null handling by scanning NULLs as zero values without requiring sql.NullXXX structs or pointers.
Overview
Type safe SQL query builder and struct mapper for Go
Use Cases
Best For
Related Projects
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.
