[Bug] dbt-core and dbt-adapters version mismatch

[guenp]

Is this a new bug?

• I believe this is a new bug
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

dbt-core complains when the adapter version does not match the dbt-core version (see line). Because we released dbt-duckdb 1.9.0 before dbt-adapters 1.9.0 got released that's an error that shows up.
Another issue we're seeing is that dbt-core 1.8.8 depends on on dbt-adapters <1.7.1 (see line) but the latest version is 1.8.0 (which just came out last week)
It seems like the solution to this would be for dbt-core to release a new version 1.9.0

Expected Behavior

No errors or version conflicts

Steps To Reproduce

It appears in CI/CD (Dependabot) for projects with dbt-core and dbt-duckdb dependency

Relevant log output

N/A

Environment

- OS:N/A
- Python:N/A
- dbt-adapters:1.8.8

Additional Context

N/A