We’ve just released sqlc version 1.21.0 which includes many bug fixes and a few new features, and coincidentally happens to be the first sqlc release built with Go 1.21. Read below for some highlights, or head straight to the sqlc changelog.
We’ll be at GopherCon 2023 in San Diego from September 24th through 26th. If you’ll be there too and want to say hi we’d love to chat with you! Please get in touch and let us know.
We’re about to reach 9000 GitHub stars, so thanks to all of you who’ve supported the sqlc project thus far and please continue to tell your friends and colleagues about the work we’re doing.
Here are some highlights from the just-released sqlc 1.21.0:
sqlc previously didn’t know how to parse a
CALL statement when using the MySQL engine,
which meant it was impossible to use sqlc with stored procedures in MySQL databases.
sqlc now supports
IS [NOT] NULL in queries. And
now work with
GitHub user @orisano continues to bring bugfixes and
sqlc’s SQLite engine. See the “Changes” section below for the
If you’re authoring a sqlc plugin, you can now configure sqlc to pass your plugin the values of specific environment variables.
For example, if your plugin
PATH environment variable, add
PATH to the
env list in the
version: '2' sql: - schema: schema.sql queries: query.sql engine: postgresql codegen: - out: gen plugin: test plugins: - name: test env: - PATH wasm: url: https://github.com/sqlc-dev/sqlc-gen-test/releases/download/v0.1.0/sqlc-gen-test.wasm sha256: 138220eae508d4b65a5a8cea555edd155eb2290daf576b7a8b96949acfeb3790
The full list of changes is in the sqlc changelog.