Add instrumentation for AWS Redshift databases

I followed the basic steps described on the documentation to connect my Flask application. My application connects with a MySql database and with Redshift database. On Kibana web page, when analyzing the data I can see the query statement for the MySql querys, but I can't see the Redshift query statement. On my application, both database connection are made with SQLAlchemy. So is just a question, does it work with Redshift? Maybe I have to check some of my settings, read some advanced topics.

I tried to create a span (`@elasticapm.capture_span()`) on the Redshift method that execute the query to be more specific and visualize what was happening, but still on kibana it show my Redshift span but no query statement.

**Environment **
- OS: Ubuntu 22.04
- Python version: 3.11
- Framework and version: Flask 2.2
- APM Server version:
- Agent version: 6.16.2

Beginne damit, das gemeldete Setup mit Flask, SQLAlchemy und der Redshift-Verbindung zu reproduzieren, und vergleiche dann seine Spans mit den MySQL-Spans, die Abfrageanweisungen in Kibana bereits anzeigen. Das Issue ist abgeschlossen, wenn Redshift-Abfrageanweisungen in Kibana sichtbar sind und das Verhalten durch einen Regressionstest abgedeckt ist.

Vom Indexierungsmodell aus dem Issue-Text verfasst.