(redshift-serverless): Create table in serverless db

### Describe the feature

I would like to be able to create a table in a serverless redshift db through CDK

### Use Case

Currently not supported by CDK, it would be great to set up the infrastructure all through CDK.

### Proposed Solution

Will likely require a custom resource

### 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.56.0

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

mac

Start by reviewing the AWS CDK support for Redshift Serverless and how existing custom resources are handled. The request does not name specific files or tests; done means CDK can provision a table in a serverless Redshift database, with the required custom-resource behavior covered by appropriate tests.

Written by the indexing model from the issue text.