AWS CDK Aurora: Migrating from v1 to v2 with AWS CDK

### Describe the issue

We have a deployment made with aws cdk and are using aurora serverless v1. We use the cdk code in our deployment pipeline and since it is a part of our deployment pipeline, our infrastructure changes happen through it.

We are getting Aurora V1 deprecation notices and it is planned to be deprecated in March 2025.

Can you please provide information about if there is aws cdk support to migrate to a serverless / provisioned aurora RDS with v2 . Can you please provide any example ?

Currently we are using AWS CDK version - 2.115.0.

### Links

I can see there is some work done here - https://github.com/aws/aws-cdk/blob/main/packages/aws-cdk-lib/aws-rds/adr/aurora-serverless-v2.md but I don't know if its available in aws cdk aurora code.

Start with packages/aws-cdk-lib/aws-rds/adr/aurora-serverless-v2.md and the Aurora implementation available in AWS CDK 2.115.0. Determine whether migration from Aurora Serverless v1 to Serverless v2 or provisioned Aurora is supported, then document the supported path and provide an example if one exists.

Written by the indexing model from the issue text.