v9.0.0

• Check https://salsita.github.io/node-pg-migrate/upgrading#from-v8-to-v9 for upgrading guide
• Check #1635 for future plans

What's Changed

• infra: use merge_group by @Shinigami92 in #1453
• infra: merge_group for semantic PR by @Shinigami92 in #1454
• infra: utilize git clean by @Shinigami92 in #1452
• chore(deps): update pnpm to v10.12.4 by @renovate[bot] in #1447
• chore(deps): update devdependencies by @renovate[bot] in #1445
• chore(deps): update dependency @stylistic/eslint-plugin to v5 by @renovate[bot] in #1450
• chore(deps): update dependency prettier to v3.6.2 by @renovate[bot] in #1449
• chore(deps): update eslint by @renovate[bot] in #1446
• feat: support index based filename naming strategy by @adrenalin in #1443
• fix: remove unused silent option from dotenv config by @brenoepics in #1461
• test: remove outdated TODO comment in createTable spec by @brenoepics in #1466
• docs: simplify theme config and add tsconfig for Vitepress by @brenoepics in #1468
• chore(deps): update pnpm to v10.13.1 by @renovate[bot] in #1467
• chore(deps): update devdependencies by @renovate[bot] in #1456
• feat!: jiti support by @brenoepics in #1460
• fix!: throw error when no constraint options are provided in addConstraint by @brenoepics in #1462
• fix!: throw error when no policy options are provided in alterPolicy by @brenoepics in #1463
• fix!: throw error when no sequence options are provided in alterSequence by @brenoepics in #1464
• fix!: throw error when no options are provided in alterTable by @brenoepics in #1465
• chore(deps): update dependency dotenv to v17 by @renovate[bot] in #1451
• chore(deps): update eslint by @renovate[bot] in #1457
• chore(deps): update dependency @vitest/eslint-plugin to v1.3.4 by @renovate[bot] in #1448
• chore(deps): lock file maintenance by @renovate[bot] in #1444
• fix(deps): update dependency yargs to v18 by @renovate[bot] in #1426
• chore(deps): update devdependencies by @renovate[bot] in #1472
• chore(deps): update eslint by @renovate[bot] in #1473
• chore(deps): update dependency eslint-plugin-unicorn to v60 by @renovate[bot] in #1475
• refactor!: replace StringIdGenerator with generator function by @brenoepics in #1477
• fix!: change indexMethod type from Name to string in operator functions by @brenoepics in #1476
• release: 9.0.0-alpha.0 by @Shinigami92 in #1479
• infra: add vitest project by @brenoepics in #1480
• fix: enable quiet mode in default dotenv config by @brenoepics in #1481
• infra: add vitest workspaces and TestContainer by @brenoepics in #1478
• chore(deps): update actions/download-artifact action to v5 by @renovate[bot] in #1491
• chore(deps): update dependency typescript to v5.9.2 by @renovate[bot] in #1484
• fix(deps): update dependency jiti to ~2.5.0 by @renovate[bot] in #1487
• chore(deps): update dependency vitepress to v1.6.4 by @renovate[bot] in #1490
• feat: add nulls option to createIndex by @jonahkagan in #1489
• chore(deps): update devdependencies by @renovate[bot] in #1485
• chore(deps): update all non-major dependencies by @renovate[bot] in #1483
• chore(deps): update eslint by @renovate[bot] in #1486
• release: 9.0.0-alpha.1 by @Shinigami92 in #1492
• chore(deps): update actions/upload-pages-artifact action to v4 by @renovate[bot] in #1495
• chore(deps): update amannn/action-semantic-pull-request action to v6 by @renovate[bot] in #1496
• chore(deps): update actions/checkout action to v5 by @renovate[bot] in #1494
• chore(deps): update devdependencies by @renovate[bot] in #1493
• feat: Support JS/TS config file loading in migration CLI by @brenoepics in #1505
• chore(deps): update dependency esbuild-fix-imports-plugin to v1.0.22 by @renovate[bot] in #1499
• chore(deps): update all non-major dependencies by @renovate[bot] in #1500
• chore(deps): lock file maintenance by @renovate[bot] in #1474
• release: 9.0.0-alpha.2 by @Shinigami92 in #1506
• fix: keep migration file order intact while importing by @benkroeger in #1514
• chore(deps): update actions/setup-node action to v5 by @renovate[bot] in #1510
• chore(deps): update devdependencies by @renovate[bot] in #1508
• chore(deps): update all non-major dependencies by @renovate[bot] in #1509
• chore(deps): update eslint by @renovate[bot] in #1501
• chore(deps): update dependency @vitest/eslint-plugin to v1.3.9 by @renovate[bot] in #1507
• chore(deps): remove unused cross-env by @Shinigami92 in #1515
• chore(deps): update dependency eslint-plugin-unicorn to v61 by @renovate[bot] in #1511
• chore(deps): lock file maintenance by @renovate[bot] in #1512
• release: 9.0.0-alpha.3 by @Shinigami92 in #1516
• chore(deps): update dependency typescript to v5.9.3 by @renovate[bot] in #1523
• fix: Ignore default property in FunctionParams while dropping function by @JAPNITSINGH in #1531
• chore(deps): update actions/setup-node action to v6 - autoclosed by @renovate[bot] in #1526
• fix(deps): update dependency jiti to ~2.6.0 by @renovate[bot] in #1522
• chore(deps): update all non-major dependencies by @renovate[bot] in #1518
• chore(deps): update github artifact actions (major) by @renovate[bot] in #1529
• chore(deps): update eslint by @renovate[bot] in #1521
• chore(deps): update devdependencies by @renovate[bot] in #1517
• chore(deps): update dependency eslint-plugin-unicorn to v62 by @renovate[bot] in #1528
• chore(deps): update dependency @vitest/eslint-plugin to v1.4.0 by @renovate[bot] in #1520
• fix: allow falsy default values in function by @therealsujitk in #1533
• release: 9.0.0-alpha.4 by @Shinigami92 in #1534
• chore(deps): update all non-major dependencies by @renovate[bot] in #1539
• chore(deps): update actions/checkout action to v6 by @renovate[bot] in #1542
• fix(deps): update dependency glob to ~11.1.0 by @renovate[bot] in #1543
• chore(deps): update devdependencies by @renovate[bot] in #1538
• chore(deps): update dependency @eslint/compat to v2 by @renovate[bot] in #1540
• chore(deps): update eslint by @renovate[bot] in #1535
• chore(deps): update vitest to v4 (major) by @renovate[bot] in #1530
• chore(deps): update vitest by @renovate[bot] in #1537
• chore(deps): update dependency prettier to v3.7.4 by @renovate[bot] in #1545
• chore(deps): update dependency typescript-eslint to v8.49.0 by @renovate[bot] in #1546
• chore(deps): update pnpm to v10.25.0 by @renovate[bot] in #1548
• fix(deps): update dependency glob to v13 by @renovate[bot] in #1549
• chore: upgrade supported db systems by @Shinigami92 in #1550
• chore(deps): update devdependencies by @renovate[bot] in #1547
• chore(deps): lock file maintenance by @renovate[bot] in #1519
• release: 9.0.0-alpha.5 by @Shinigami92 in #1551
• docs: fix typo by @PirAhmedShah in #1556
• feat: handle PgLiteral in index expressions by @brenoepics in #1561
• chore: add eslint-plugin-import-x by @Shinigami92 in #1562
• chore(deps): update github artifact actions (major) by @renovate[bot] in #1554
• chore(deps): update vitest by @renovate[bot] in #1558
• chore(deps): update all non-major dependencies by @renovate[bot] in #1559
• chore(deps): update devdependencies by @renovate[bot] in #1552
• chore(deps): update eslint by @renovate[bot] in #1553
• chore(deps): lock file maintenance by @renovate[bot] in #1555
• release: 9.0.0-alpha.6 by @Shinigami92 in #1563
• chore(deps): update eslint by @renovate[bot] in #1564
• chore(deps): update devdependencies by @renovate[bot] in #1565
• chore(deps): update vitest by @renovate[bot] in #1569
• chore(deps): update dependency prettier to v3.8.1 by @renovate[bot] in #1567
• chore(deps): update all non-major dependencies by @renovate[bot] in #1566
• chore(deps): lock file maintenance by @renovate[bot] in #1568
• chore: switch to trusted publishing by @Shinigami92 in #1571
• fix: use type-only import in TypeScript migration template by @shimscho in #1579
• chore(deps): update github artifact actions (major) by @renovate[bot] in #1576
• chore(deps): update all non-major dependencies by @renovate[bot] in #1572
• chore(deps): lock file maintenance by @renovate[bot] in #1575
• chore(deps): update eslint by @renovate[bot] in #1573
• chore(deps): update vitest by @renovate[bot] in #1577
• chore(deps): update devdependencies by @renovate[bot] in #1574
• chore(deps): update eslint (major) by @renovate[bot] in #1570
• chore: update license year by @Shinigami92 in #1580
• release: 9.0.0-alpha.7 by @Shinigami92 in #1581
• feat: Add migration loader strategies with SQL grouping and docs by @peturv in #1582
• release: 9.0.0-alpha.8 by @Shinigami92 in #1583
• chore(deps): update all non-major dependencies by @renovate[bot] in #1590
• chore(deps): update devdependencies by @renovate[bot] in #1586
• chore(deps): update vitest by @renovate[bot] in #1584
• chore(deps): update actions/configure-pages action to v6 by @renovate[bot] in #1591
• chore(deps): update actions/deploy-pages action to v5 by @renovate[bot] in #1592
• chore(deps): update pnpm/action-setup action to v5 by @renovate[bot] in #1588
• chore: switch from eslint to oxlint by @Shinigami92 in #1594
• chore: switch from prettier to oxfmt by @Shinigami92 in #1595
• chore: switch from tsup to tsdown by @Shinigami92 in #1596
• chore(deps): update davelosert/vitest-coverage-report-action action to v2.11.1 by @renovate[bot] in #1597
• chore(deps): update dependency typescript to v6 by @renovate[bot] in #1599
• release: 9.0.0-alpha.9 by @Shinigami92 in #1600
• infra: add dotenv renovate group by @Shinigami92 in #1601
• chore(deps): update dependency @types/node to v20.19.39 by @renovate[bot] in #1598
• chore(deps): update pnpm/action-setup action to v6 by @renovate[bot] in #1609
• chore(deps): update actions/upload-pages-artifact action to v5 by @renovate[bot] in #1608
• chore(deps): update vitest to v4.1.4 by @renovate[bot] in #1603
• chore(deps): update all non-major dependencies by @renovate[bot] in #1602
• chore(deps): update devdependencies by @renovate[bot] in #1606
• chore(deps): update dependency @types/config to v4 by @renovate[bot] in #1587
• chore(deps): update dependency oxfmt to v0.45.0 by @renovate[bot] in #1605
• chore(deps): update oxlint by @renovate[bot] in #1607
• chore(deps): update dependency tsdown to v0.21.10 by @renovate[bot] in #1611
• chore(deps): update all non-major dependencies by @renovate[bot] in #1613
• chore(deps): update oxlint by @renovate[bot] in #1614
• chore(deps): update dependency typescript to v6.0.3 by @renovate[bot] in #1612
• chore(deps): update dependency oxfmt to v0.47.0 by @renovate[bot] in #1618
• chore(deps): update oxlint by @renovate[bot] in #1619
• chore(deps): update pnpm to v10.33.2 by @renovate[bot] in #1616
• chore(deps): update vitest to v4.1.5 by @renovate[bot] in #1617
• fix(deps): update dependency jiti to ~2.7.0 by @renovate[bot] in #1625
• chore(deps): update dependency oxfmt to v0.49.0 by @renovate[bot] in #1623
• chore(deps): update dependency oxlint to v1.64.0 by @renovate[bot] in #1624
• chore(deps): update all non-major dependencies by @renovate[bot] in #1621
• chore(deps): update vitest to v4.1.6 by @renovate[bot] in #1630
• chore(deps): update all non-major dependencies by @renovate[bot] in #1631
• chore(deps): update oxlint by @renovate[bot] in #1633
• chore(deps): update dependency oxfmt to v0.50.0 by @renovate[bot] in #1632
• docs: add @brenoepics and @osdiab as co-maintainers by @Shinigami92 in #1634
• feat: Create new files ext by @beterrabaA in #1636
• release: 9.0.0-alpha.10 by @Shinigami92 in #1637
• chore(deps): update vitest to v4.1.7 by @renovate[bot] in #1640
• chore(deps): update dependency node to v24.16.0 by @renovate[bot] in #1641
• docs: Fix documentation of JSON config options by @acoulton in #1627
• chore(deps): update pnpm to v10.34.1 by @renovate[bot] in #1646
• feat: introduce advisory lock mode by @nemisj in #1648
• chore(deps): update all non-major dependencies to v6.0.3 by @renovate[bot] in #1649
• feat: add jiti tsconfigPaths option for migrations by @Shinigami92 in #1645
• release: 9.0.0-alpha.11 by @Shinigami92 in #1651
• feat: support array column type option by @dosacha in #1653
• feat: support IF EXISTS table guard for dropConstraint by @dosacha in #1654
• feat: add renameIndex method by @beterrabaA in #1638
• chore(deps): update actions/checkout action to v7 by @renovate[bot] in #1655
• chore(deps): update all non-major dependencies by @renovate[bot] in #1652
• chore(deps): update vitest to v4.1.9 by @renovate[bot] in #1650
• chore(deps): update dependency oxfmt to v0.57.0 by @renovate[bot] in #1642
• chore(deps): update oxlint by @renovate[bot] in #1643
• release: 9.0.0-alpha.12 by @Shinigami92 in #1656
• docs: programmatic api example by @mrl5 in #1657
• docs: add v8 to v9 upgrading guide by @Shinigami92 in #1662
• release: 9.0.0 by @Shinigami92 in #1663

New Contributors

• @adrenalin made their first contribution in #1443
• @jonahkagan made their first contribution in #1489
• @JAPNITSINGH made their first contribution in #1531
• @therealsujitk made their first contribution in #1533
• @PirAhmedShah made their first contribution in #1556
• @shimscho made their first contribution in #1579
• @peturv made their first contribution in #1582
• @beterrabaA made their first contribution in #1636
• @acoulton made their first contribution in #1627
• @nemisj made their first contribution in #1648
• @dosacha made their first contribution in #1653
• @mrl5 made their first contribution in #1657

Full Changelog: v8.0.4...v9.0.0