[FEATURE]: Support AWS Data API v2

[ari-becker]

Describe what you want

The AWS Data API was redesigned for Aurora Serverless v2 and for provisioned Aurora, with no rate limit: https://aws.amazon.com/about-aws/whats-new/2023/12/amazon-aurora-postgresql-rds-data-api/

Will Drizzle support it as a driver?

[AlexBlokh]

we already have a data api https://orm.drizzle.team/docs/get-started-postgresql#aws-data-api, but we did not check it with v2 yet

[jakeleventhal]

Related issue: https://github.com/drizzle-team/drizzle-orm/pull/1172/files

[AndriiSherman]

Aurora Serverless v2 is compatible with the previous version, and after a few tests, it worked the same with drizzle.

https://github.com/drizzle-team/drizzle-orm/pull/1172/files -> this PR will be reviewed and merged, but it's not related to this feature request, so we are closing this one

[jakeleventhal]

#1823 plugging this issue here

[jakeleventhal]

#1911 also this one!