sqlc

sqlc is a command line tool that generates type-safe code from SQL queries. You write the SQL, and sqlc creates the functions your application calls.

sqlc reads your SQL queries and schema, then produces code that matches them. Mistakes in queries can be caught before the code runs, instead of appearing at runtime. The project lists the programming languages and databases it supports, and it is open source under the MIT licence.

• Generates functions from your SQL queries
• Type-safe interfaces for query results
• Catches query problems before runtime
• Runs on Linux, macOS and Windows
• Supports several programming languages

Backend developers who prefer writing SQL by hand and want typed code without a full ORM. It fits teams that want the query logic to stay visible in plain SQL files.

sqlc is open source under the MIT licence and free to download. It runs as a command line tool, so it fits into build scripts and CI. Because it generates code, commit the output and rerun the tool whenever a query changes.