v1.20.0

What's Changed

• Mention UUID type for pgx/v5 by @peterwillis in #2448
• Update BUG_REPORT.yml by @andrewmbenton in #2460
• scripts: Add new version to BUG_REPORT.yml by @kyleconroy in #2461
• build: Run all supported versions of MySQL / PostgreSQL by @kyleconroy in #2463
• docs: Add a description to the document for cases when a query result has no rows by @n3xem in #2462
• feat: add basic parsing of boolean flag query metadata annotations by @andrewmbenton in #2464
• feat(vet): Introduce a query annotation to opt out of sqlc vet rules by @andrewmbenton in #2474
• fix(vet): report an error when a query is unpreparable, remove dead code by @andrewmbenton in #2486
• build(deps): bump pygments from 2.7.4 to 2.15.0 in /docs by @dependabot in #2485
• build(deps): bump github.com/jackc/pgconn from 1.14.0 to 1.14.1 by @dependabot in #2483
• feat(vet): Add output from EXPLAIN ... for queries to the CEL program environment by @andrewmbenton in #2489
• docs: update copyright and author by @andrewmbenton in #2490
• fix: sqlite log by @mcdoker18 in #2488
• build(deps): bump github.com/google/cel-go from 0.16.0 to 0.17.1 by @dependabot in #2484
• docs: Check Python dependencies via dependabot by @kyleconroy in #2497
• build(deps): bump idna from 2.10 to 3.4 in /docs by @dependabot in #2499
• build(deps): bump packaging from 20.9 to 23.1 in /docs by @dependabot in #2498
• build(deps): bump pygments from 2.15.0 to 2.15.1 in /docs by @dependabot in #2500
• fix(engine/sqlite): support for repeated table_option by @orisano in #2482
• test: Add profiles to docker compose by @kyleconroy in #2503
• Add example sqlc.yaml for migration parsing by @samfweb in #2479
• fix(engine/sqlite): added function to convert cast node by @orisano in #2470
• build(deps): bump certifi from 2022.12.7 to 2023.7.22 in /docs by @kyleconroy in #2504
• fix(engine/sqlite): fixed to be able to find relation from WITH clause by @orisano in #2444
• build(deps): bump sphinx from 4.4.0 to 6.1.0 in /docs by @kyleconroy in #2505
• build: Add psql and mysqlsh to devenv by @kyleconroy in #2507
• fix(sql/catalog): Support pg_dump output by @kyleconroy in #2508
• docs: small updates by @andrewmbenton in #2506
• fix(engine/sqlite): fixed IN operator precedence by @orisano in #2428
• fix(engine/sqlite): fix table_alias rules by @orisano in #2465
• fix(engine/sqlite): fix join_operator rule by @orisano in #2434
• fix(vet): clean up unnecessary prepareable() func and a var name collision by @andrewmbenton in #2509
• Clarify option package support by @johanbrandhorst in #2513
• fix(vet): Split vet messages out of codegen.proto by @kyleconroy in #2511
• build(deps): bump urllib3 from 1.26.5 to 2.0.4 in /docs by @dependabot in #2516
• build(deps): bump chardet from 4.0.0 to 5.1.0 in /docs by @dependabot in #2517
• build(deps): bump snowballstemmer from 2.1.0 to 2.2.0 in /docs by @dependabot in #2519
• build(deps): bump pytz from 2021.1 to 2023.3 in /docs by @dependabot in #2520
• build(deps): bump sphinxcontrib-htmlhelp from 2.0.0 to 2.0.1 in /docs by @dependabot in #2518
• fix missing unsigned param by @hiroebe in #2522
• feat(debug): add debug flag and docs for dumping vet rule variables by @andrewmbenton in #2521
• Fix code geneation for sqlc.slice by @SoMuchForSubtlety in #2431
• build(deps): bump pyparsing from 2.4.7 to 3.1.0 in /docs by @dependabot in #2530
• build(deps): bump alabaster from 0.7.12 to 0.7.13 in /docs by @dependabot in #2526
• feat(sqlite): virtual tables and fts5 supported by @mcdoker18 in #2531
• fix(vet): query.cmd was always set to ":" by @thokra-nav in #2525
• build(docs): Ignore updates for sphinx by @kyleconroy in #2532
• build(deps): bump babel from 2.9.1 to 2.12.1 in /docs by @dependabot in #2527
• build(deps): bump sphinxcontrib-applehelp from 1.0.2 to 1.0.4 in /docs by @dependabot in #2533
• chore!: Rename kyleconroy/sqlc to sqlc-dev/sqlc by @kyleconroy in #2523
• docs: Point GitHub links to new repository location by @kyleconroy in #2534
• fix(engine/sqlite): To lowercase ast.ResTarget.Name by @orisano in #2433
• chore(proto): reformat protos using buf format -w by @andrewmbenton in #2536
• build(deps): bump google.golang.org/grpc from 1.56.2 to 1.57.0 by @dependabot in #2535
• fix(compiler): correctly validate alias in order/group by clauses for joins by @andrewmbenton in #2537
• chore: Update FEATURE_REQUEST.yml to include SQLite engine option by @andrewmbenton in #2540
• feat(sql/catalog): Support ALTER TABLE IF EXISTS by @kyleconroy in #2542
• feat(mysql): Implement cast function parser by @RadhiFadlillah in #2473
• feat(mysql): :copyfrom support via LOAD DATA INFILE by @kyleconroy in #2545
• feat(postgresql): Add support for PostgreSQL multi-dimensional arrays by @colli173 in #2338
• fix(codegen/golang): fix sqlc.embed to work with pq.Array wrap by @orisano in #2544
• refactor(compiler): remove some duplicate code by @andrewmbenton in #2546
• build(deps): bump pyparsing from 3.1.0 to 3.1.1 in /docs by @dependabot in #2547
• chore: Finish migration to sqlc-dev/sqlc by @kyleconroy in #2548
• feat(vet): Add default query parameters for explain queries by @kyleconroy in #2543
• feat(cmd/sqlc): Bump version to 1.20.0 by @kyleconroy in #2549

New Contributors

• @peterwillis made their first contribution in #2448
• @n3xem made their first contribution in #2462
• @samfweb made their first contribution in #2479
• @hiroebe made their first contribution in #2522
• @SoMuchForSubtlety made their first contribution in #2431
• @thokra-nav made their first contribution in #2525
• @RadhiFadlillah made their first contribution in #2473
• @colli173 made their first contribution in #2338

Full Changelog: v1.19.1...v1.20.0