Bug Fixes

• Update incorrect signatures (fix(engine/mysql): Update incorrect signatures #1180 )
• Correct aggregate func sig (fix(engine/postgresql): Correct aggregate func sig #1182 )
• Jsonb_build_object (fix(engine/postgresql): jsonb_build_object #1211 )
• Case-insensitive identifiers (fix(engine/mysql): Case-insensitive identifiers #1216 )
• Incorrect handling of meta (fix(inflection): Incorrect handling of meta #1228 )
• Detect invalid INSERT expression (fix(compiler): Detect invalid INSERT expression #1231 )
• Respect alias name for coalesce (fix(compiler): Respect alias name for coalesce #1232 )
• Mark nullable when casting NULL (fix(compiler): Mark nullable when casting NULL #1233 )
• Support nullable fields in joins for MySQL engine (fix(engine/mysql): Support nullable fields in joins for MySQL engine #1249 )
• Fix between expression handling of table references (fix(compiler): Fix between expression handling of table references #1268 )
• Support nullable fields in joins on same table (fix(compiler): Support nullable fields in joins on same table #1270 )
• Fix missing binds in ORDER BY (fix(engine/mysql): Fix missing binds in ORDER BY #1273 )
• Set RV for TargetList items on updates (fix(compiler): Set RV for TargetList items on updates #1252 )
• Fix MySQL parser for query without trailing semicolon (fix(engine/mysql): Fix MySQL parser for query without trailing semicolon #1282 )
• Validate table alias references (fix(compiler): Validate table alias references #1283 )
• Add support for MySQL ON DUPLICATE KEY UPDATE (fix(engine/mysql): Add support for MySQL ON DUPLICATE KEY UPDATE #1286 )
• Support references to columns in joined tables in UPDATE statements (fix(compiler): Support references to columns in joined tables in UPDATE statements #1289 )
• Add validation for GROUP BY clause column references (fix(compiler): Add validation for GROUP BY clause column references #1285 )
• Prevent variable redeclaration in single param conflict (fix(codegen): Prevent variable redeclaration in single param conflict #1298 )
• Use common params struct field for same named params (fix(compiler): Use common params struct field for same named params #1296 )

Documentation

• Replace deprecated go get with go install (docs: Replace deprecated go get with go install #1181 )
• Fix package name referenced in tutorial (docs: Fix package name referenced in tutorial #1202 )
• Add environment variables (docs: Add environment variables reference #1264 )
• Add go.17+ install instructions (docs: add go.17+ install instructions #1280 )
• Warn about golang-migrate file order (docs: warn about golang-migrate file order #1302 )

Features

• Instrument compiler via runtime/trace (feat: Instrument compiler via runtime/trace #1258 )
• Add MySQL support for BETWEEN arguments (feat: Add MySQL support for BETWEEN arguments #1265 )

Refactor

• Move from io/ioutil to io and os package (refactor: move from io/ioutil to io and os package #1164 )

Styling

• Apply gofmt to sample code (style: apply gofmt to sample code #1261 )

New Contributors

• @Juneezee made their first contribution in refactor: move from io/ioutil to io and os package #1164
• @ovadbar made their first contribution in Allow for mixed parameters types (1ドル or ?) and sqlc.arg() #1072
• @l4u made their first contribution in Fix execrows in README #1199
• @oliverpool made their first contribution in Exportable Run function #1204
• @cqsd made their first contribution in Document emit_result_struct_pointers and emit_params_struct_pointers options #1209
• @snakeclown made their first contribution in Update config doc to show MySQL type overrides #1248
• @timstudd made their first contribution in fix(engine/mysql): Support nullable fields in joins for MySQL engine #1249
• @orisano made their first contribution in style: apply gofmt to sample code #1261
• @andreasgan made their first contribution in fix(compiler): Set RV for TargetList items on updates #1252
• @lopezator made their first contribution in docs: add go.17+ install instructions #1280
• @danielmmetz made their first contribution in Add DBTX Param config option #1279
• @wabain made their first contribution in Consistent whitespace handling in Go query template #1301
• @remLse made their first contribution in docs: warn about golang-migrate file order #1302

Full Changelog: v1.10.0...v1.11.0