sqlc Documentation

Overview

Installing sqlc

Tutorials

Getting started with MySQL Getting started with PostgreSQL Getting started with SQLite

Commands

analyze - Analyzing query result types fmt - Formatting queries generate - Generating code parse - Parsing SQL into an AST push - Uploading projects verify - Verifying schema changes vet - Linting queries

How-to Guides

Retrieving rows Counting rows Inserting rows Updating rows Deleting rows Preparing queries Using transactions Naming parameters Modifying the database schema Configuring generated structs Embedding structs Overriding types Renaming fields

sqlc Cloud

Managed databases

Reference

Changelog CLI Configuration Datatypes Environment variables Database and language support Macros Query annotations

Conceptual Guides

Using sqlc in CI/CD Using Go and pgx Using plugins Developing sqlc Privacy and data collection

ReferenceChangelog

v1.9.0

Released 2021-08-13 · View on GitHub

Documentation

Update documentation (a bit) for v1.9.0 (#1117)

Build

Bump golang from 1.16.6 to 1.16.7 (#1107)

Cmd/sqlc

Bump version to v1.9.0 (#1121)

Compiler

Add tests for COALESCE behavior (#1112)
Handle subqueries in SELECT statements (#1113)

On this page

Documentation Build Cmd/sqlc Compiler