Dbt-adapters

Fixes

- Use model alias for the CTE identifier generated during ephemeral materialization ([5273](https://github.com/dbt-labs/dbt-adapters/issues/5273))

Under the Hood

- Updating changie.yaml to add contributors and PR links ([219](https://github.com/dbt-labs/dbt-adapters/issues/219))

Contributors
- [jeancochrane](https://github.com/jeancochrane) ([#5273](https://github.com/dbt-labs/dbt-adapters/issues/5273))
- [leahwicz](https://github.com/leahwicz) ([#219](https://github.com/dbt-labs/dbt-adapters/issues/219))

Features

- render 'to' and 'to_columns' fields on foreign key constraints, and bump dbt-common lower bound to 1.6 ([271](https://github.com/dbt-labs/dbt-adapters/issues/271))

Fixes

- Incremental table varchar column definition changed ([276](https://github.com/dbt-labs/dbt-adapters/issues/276))

Under the Hood

- Rework record/replay to record at the database connection level. ([244](https://github.com/dbt-labs/dbt-adapters/issues/244))

Fixes

* Fix scenario where using the `--empty` flag causes metadata queries to contain limit clauses ([213](https://github.com/dbt-labs/dbt-adapters/issues/213))

Under the Hood

* --limit flag no longer subshells the query. This resolves the dbt Cloud experience issue where limit prevents ordering elements.. ([207](https://github.com/dbt-labs/dbt-adapters/issues/207))

Under the Hood

* Fix query timer resolution ([246](https://github.com/dbt-labs/dbt-adapters/issues/246))
* Add optional release_connection parameter to connection_named method ([247](https://github.com/dbt-labs/dbt-adapters/issues/247))

Features

* Add get_catalog_for_single_relation macro and capability to enable adapters to optimize catalog generation ([231](https://github.com/dbt-labs/dbt-adapters/issues/231))