When will support for dbt-fusion be added?

### Describe the feature
- Add support for `dbt-fusion`
- **Question**: any idea of when this will be available?

### Describe alternatives you've considered
As it stands, none available if we want to use `dbt-fusion` w/ `dbt-glue`

### Additional context
- `dbt-core` end of life is 2026: https://docs.getdbt.com/docs/dbt-versions/core
- `dbt-fusion` will be its replacement
- `dbt-glue` is not part of the currently supported adapters

https://docs.getdbt.com/docs/dbt-versions/core-upgrade/upgrading-to-fusion

### Who will this benefit?
All `dbt-glue` users as eventually they will have to migrate to `dbt-fusion`

### Are you interested in contributing this feature?
I'm afraid not sorry, I trust AWS will find the ressources to continue supporting its products :)

Start by reviewing the dbt-glue adapter and the linked dbt-fusion migration documentation to determine the compatibility requirements. Done means dbt-glue supports dbt-fusion as a supported adapter, but the issue does not name implementation files or tests.

Written by the indexing model from the issue text.