[Feature] Support for Athena

### Is this your first time submitting a feature request?

- [X] I have read the [expectations for open source contributors](https://docs.getdbt.com/docs/contributing/oss-expectations)
- [X] I have searched the existing issues, and I could not find an existing issue for this feature
- [X] I am requesting a straightforward extension of existing metricflow functionality, rather than a Big Idea better suited to a discussion

### Describe the feature

Support for Trino was added in [this](https://github.com/dbt-labs/metricflow/issues/207) PR,
Athena is based on Trino - specifically on when using workgroup v3.

Due to the architecture, Athena is slightly different from Trino, some adaptation might be needed.

### Describe alternatives you've considered

_No response_

### Who will this benefit?

Users using [dbt-athnea](https://github.com/dbt-athena/dbt-athena) might benefit from this.

### Are you interested in contributing this feature?

I can if times allows me.

### Anything else?

_No response_