v1.22.0

What's new

Managed databases for sqlc vet

If you're using sqlc vet to write rules that require access to a running database, sqlc can now start and manage that database for you. PostgreSQL support is available today, with MySQL on the way.

When you turn on managed databases, sqlc will use your schema to create a template database that it can copy to make future runs of sqlc vet very performant.

This feature relies on configuration obtained via sqlc Cloud. If you're interested in early access you can sign up here or send us an email at [email protected].

Read more in the managed databases documentation.

What's changed

• build(deps): bump golang from 1.21.0 to 1.21.1 by @dependabot in #2711
• fix(codegen/golang): Refactor imports code to match templates by @kyleconroy in #2709
• ci: bump go version to latest in workflows by @andrewmbenton in #2722
• fix(codegen/golang): support name type by @orisano in #2715
• fix(wasm): Move Runner struct to shared file by @kyleconroy in #2725
• fix(engine/sqlite): fix grammer to avoid missing join_constraint by @orisano in #2732
• fix(convert): Support YAML anchors in plugin options by @kyleconroy in #2733
• Enables the configuration of copyfrom.go similar to quierer and friends by @XanderAtGoingDutch in #2727
• test(endtoend): Verify all schemas in endtoend by @kyleconroy in #2744
• test(examples): Use a hosted database for example testing by @kyleconroy in #2749
• test(endtoend): Pull region from environment by @kyleconroy in #2750
• build(deps): bump google.golang.org/grpc from 1.57.0 to 1.58.1 by @dependabot in #2743
• build(deps): Bump wasmtime-go from v12 to v13 by @kyleconroy in #2756
• docs: clarify nullable override behavior by @andrewmbenton in #2753
• build(windows): Downgrade to mingw 11.2.0 by @kyleconroy in #2757
• build(deps): bump urllib3 from 2.0.4 to 2.0.5 in /docs by @dependabot in #2747
• build(deps): bump google.golang.org/grpc from 1.58.1 to 1.58.2 by @dependabot in #2758
• feat(vet): Run rules against a managed database by @kyleconroy in #2751
• chore(endtoend): Skip tests if secrets are missing by @kyleconroy in #2763
• docs: Add managed databases to sidebar by @kyleconroy in #2764
• fix: Disallow time.Time in mysql :copyfrom queries, not all queries by @Jille in #2768
• chore: Skip certain tests on PRs by @kyleconroy in #2769
• feat(upload): Point upload command at new endpoint by @kyleconroy in #2772
• fix(engine/sqlite): Fix convert process for VALUES by @orisano in #2737
• docs: Release notes for v1.22.0 by @andrewmbenton in #2773
• docs: Pull renaming and type overrides into separate sections by @kyleconroy in #2774
• docs: Update the docs banner for managed dbs by @kyleconroy in #2775
• build(deps): bump github.com/google/cel-go from 0.18.0 to 0.18.1 by @dependabot in #2778
• feat(compiler): Support DO statements by @kyleconroy in #2777
• docs: update changelog with all v1.22.0 changes by @andrewmbenton in #2780
• cmd/sqlc: Bump version to v1.22.0 by @kyleconroy in #2776

New Contributors

• @XanderAtGoingDutch made their first contribution in #2727

Full Changelog: v1.21.0...v1.22.0