Go SQL

Use sqlc to generate type-safe Go code from SQL queries, and goose for migrations. Write SQL, get Go.

This combo gives you:

• Compile-time checking of column names and types.
• Real SQL in your editor, no DSL or ORM to learn.
• A Querier interface auto-generated for mocking in tests.

Project layout

myservice/
├── db/
│   ├── migrations/
│   │   └── 001_create_users.sql
│   └── queries/