[BUG]: Error: Region is missing - Unable to use aws-data-api wuth drizzle-kit

### What version of `drizzle-orm` are you using?

?

### What version of `drizzle-kit` are you using?

?

### Describe the Bug

From drizzle-kit-mirror repo: https://github.com/drizzle-team/drizzle-kit-mirror/issues/535.

> I'm unable to use any of the drizzle commands when using the aws data api as the driver. The error is the same for all commands which is that it cannot find the region and there's no way to specify the region in the drizzle config file. The database connection in the ORM is working thanks to the region specification in the RDSClient.
>
> [Bug Report.zip](https://github.com/user-attachments/files/16551777/Bug.Report.zip)

### Expected behavior

_No response_

### Environment & setup

_No response_

Start with drizzle-kit-mirror issue 535 and the attached Bug Report.zip; compare the AWS Data API connection's RDSClient region handling with the drizzle config used by drizzle commands. Done means the reported commands can obtain a configured region and the existing ORM connection remains working, with a regression check for the missing-region error.

Written by the indexing model from the issue text.