(aws-athena): Construct for Athena DynamoDB connector

### Describe the feature

Hello, due to recent popular demand, I have an enhancement request to put forward. In essence, it would be great to have a Construct for Athena's [DynamoDB connector](https://docs.aws.amazon.com/athena/latest/ug/athena-prebuilt-data-connectors-dynamodb.html).

### Use Case

Whilst one is able to provision the connector manually in the service directly, automating this would be a great experience.

Would you kindly review this request for consideration as an enhancement, or please share any potential alternative solutions which I may not yet be aware of.

Thank you, and as always, please let me know if i can provide any further clarity or info.

### Proposed Solution

_No response_

### Other Information

_No response_

### Acknowledgements

- [ ] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

2.33.0 (build 859272d)

### Environment details (OS name and version, etc.)

N/A

Start with the linked Athena DynamoDB connector documentation and inspect the aws-cdk repository for existing Athena construct patterns; no specific file or test is named in the issue. Clarify the construct's inputs and provisioning behavior, then define completion as automated provisioning of the Athena DynamoDB connector with appropriate test coverage.

Written by the indexing model from the issue text.