how to avoid writing dreadful SQL statements

• sqlc

  169 10,709 9.7 Go

  Generate type-safe code from SQL

  

Use something that does codegen, like sqlc or Bob.

• bob

  32 574 9.0 Go

  SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite (by stephenafamo)

Use something that does codegen, like sqlc or Bob.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• query

  2 69 10.0 Go

  Simple Query Builder for PostgreSQL - WIP (by andrewpillar)

I have written about this before, and my thoughts always settle on using a query builder. I've built a simple one, which works for what I need, but there are more feature complete ones out there such as squirrel. I've also written about how you can implement a simple CRUD library for database interactions using generics and query building to have that nice middle-ground between an ORM and query building.

• Squirrel

  52 6,490 2.8 Go

  Fluent SQL generation for golang

  

I have written about this before, and my thoughts always settle on using a query builder. I've built a simple one, which works for what I need, but there are more feature complete ones out there such as squirrel. I've also written about how you can implement a simple CRUD library for database interactions using generics and query building to have that nice middle-ground between an ORM and query building.

Suggest a related project