awesome-go-sql

Actual example use cases for a curated list of golang sql builder/generator/scanner/helper libraries

Summary

For static queries, try sqlc.

For dynamic queries, try go-sqlbuilder, squirrel, or jet to craft the SQL string and args slice, then use scany or ksql to run the query and scan to a struct/slice.

Completed Examples

No libraries besides database drivers

• database/sql
• github.com/jackc/pgx/v5

Model/SQL/Function Generators

• github.com/sqlc-dev/sqlc
• github.com/go-jet/jet/v2

SQL Builders

• github.com/huandu/go-sqlbuilder
• github.com/Masterminds/squirrel
• github.com/doug-martin/goqu/v9

Struct Scanners

• github.com/georgysavva/scany/v2
• github.com/vingarcia/ksql
• github.com/blockloop/scan
• github.com/jmoiron/sqlx

Ran Into Problems

• github.com/bokwoon95/sq Queries have errors.
• github.com/lqs/sqlingo Failed to generate files for postgres.