Features
- Add tests for cross-database `cast` macro ([76](https://github.com/dbt-labs/dbt-postgres/issues/76))
- Cross-database `date` macro ([82](https://github.com/dbt-labs/dbt-postgres/issues/82))
- Add support for Python 3.12 ([17](https://github.com/dbt-labs/dbt-postgres/issues/17))
- Allow configuring snapshot column names ([144](https://github.com/dbt-labs/dbt-postgres/issues/144))
- Microbatch incremental strategy implementation: merge ([149](https://github.com/dbt-labs/dbt-postgres/issues/149))
Fixes
- Fix the semicolon semantics for indexes while respecting other bug fix ([85](https://github.com/dbt-labs/dbt-postgres/issues/85))
- Default to psycopg2-binary and allow overriding to psycopg2 via DBT_PSYCOPG2_NAME (restores previous behavior) ([96](https://github.com/dbt-labs/dbt-postgres/issues/96))
- Fix `persist_docs` for `materialized_view` materializations. Previously, using this configuration with materialized view models would lead to an error. ([120](https://github.com/dbt-labs/dbt-postgres/issues/120))
Under the Hood
- Add support for experimental record/replay testing. ([123](https://github.com/dbt-labs/dbt-postgres/issues/123))
- Updating changie.yaml to add contributors and PR links ([109](https://github.com/dbt-labs/dbt-postgres/issues/109))
Contributors
- [dbeatty10](https://github.com/dbeatty10) ([#76](https://github.com/dbt-labs/dbt-postgres/issues/76), [#82](https://github.com/dbt-labs/dbt-postgres/issues/82))
- [gshank](https://github.com/gshank) ([#144](https://github.com/dbt-labs/dbt-postgres/issues/144))
- [leahwicz](https://github.com/leahwicz) ([#109](https://github.com/dbt-labs/dbt-postgres/issues/109))
- [michelleark](https://github.com/michelleark) ([#149](https://github.com/dbt-labs/dbt-postgres/issues/149))
- [mikealfare](https://github.com/mikealfare) ([#17](https://github.com/dbt-labs/dbt-postgres/issues/17), [#96](https://github.com/dbt-labs/dbt-postgres/issues/96))
- [morsapaes](https://github.com/morsapaes) ([#120](https://github.com/dbt-labs/dbt-postgres/issues/120))
- [peterallenwebb](https://github.com/peterallenwebb) ([#123](https://github.com/dbt-labs/dbt-postgres/issues/123))
- [versusfacit](https://github.com/versusfacit) ([#85](https://github.com/dbt-labs/dbt-postgres/issues/85))
Previous Releases
For information on prior major and minor releases, see their changelogs:
- [1.8](https://github.com/dbt-labs/dbt-postgres/blob/1.8.latest/CHANGELOG.md)