[Feature] Support Redshift Destinations

### Is there an existing feature request for this?

- [X] I have searched the existing issues

### Describe the Feature

Currently Redshift destinations are not supported due to the strict character limitations within the string datatype. At the moment, this package requires heavy use of large string datatypes. Ultimately we chunk the strings so we have more manageable data. However, we experienced Redshift destinations continuously through errors before the chunking, making the package impossible on Redshift destinations. We could explore supporting this more rigorously by leveraging the SUPER datatype. However, we would like to gauge interest in if there is a desire for the community to have this support before developing this enhancement.

### How would you implement this feature?

Most likely we would leverage the SUPER datatype to take advantage of the datatype which allows nearly unbounded limits.

### Describe alternatives you've considered

_No response_

### Are you interested in contributing this feature?

- [ ] Yes.
- [ ] Yes, but I will need assistance.
- [ ] No.

### Anything else?

_No response_