Release v1.31.0 · sqlc-dev/sqlc

Bug Fixes

Strip psql meta-commands from schema files (#4390)
Emit pointers for nullable enum columns when emit_pointers_for_null_types is set (#4388)
Map xid8 to pgtype.Uint64 for pgx/v5 (#4387)
Rename :one return variable when it conflicts with a parameter (#4383)
Coerce SQLite JSONB output regardless of type casing (#4385)
Dedupe sqlc.arg parameters wrapped in a type cast for MySQL (#4384)
Preserve MySQL optimizer hints in generated query text (#4382)
Catch invalid ON CONFLICT DO UPDATE column references (#4366)
Replace manual loop with copy() builtin (#4166)
(native) Make MySQL connection check immediate on first attempt (#4254)

(sqlfile) Add sqlfile.Split (#4146)
(sqlite) Add database analyzer using ncruces/go-sqlite3 (#4199)
(ast) Implement comprehensive SQL AST formatting (#4205)
(mysql) Improve AST formatting and add DELETE JOIN support (#4206)
(sqlite) Add SQLite support to format tests (#4207)
(expander) Add star expander for SELECT * and RETURNING * (PostgreSQL, MySQL, SQLite) (#4203)
Add SQLCEXPERIMENT environment variable for experimental features (#4228)
Add native database support for e2e tests without Docker (#4236)
(postgresql) Add analyzerv2 experiment for database-only analysis (#4237)
Graduate parsecmd experiment (#4253)
Add parse subcommand with AST JSON output (#4240)
Add ClickHouse support to sqlc parse (#4267)
Add sqlc-test-setup command for database test environment setup (#4304)