RDS Api to_sql error when inserting to uuid type column

[jethroguce]

Describe the bug

There's an issue with awswrangler when attempting to insert UUID values into a PostgreSQL table’s UUID column using the to_sql method with the AWS Data API.

:ERROR: column "id" is of type uuid but expression is of type text
:HINT: You will need to rewrite or cast the expression.

How to Reproduce

CREATE TABLE users (
    id UUID PRIMARY KEY,
    name VARCHAR(50)
);

import awswrangler as wr
import pandas as pd
import uuid

# Number of records to insert
num_records = 10

# Generate a list of random UUIDs for the 'id' column
id_list = [uuid.uuid4() for _ in range(num_records)]

# Sample DataFrame with random UUIDs for 'id' and names
df = pd.DataFrame({
    'id': id_list,  # Generated UUIDs
    'name': [f'User{i}' for i in range(1, num_records + 1)]  # Generate names as User1, User2, etc.
})

# AWS RDS connection parameters
db_cluster_arn = "your-cluster-arn"
db_credentials_secrets_store_arn = "your-secret-arn"
database = "your-database-name"
table_name = "users"

conn =  wr.data_api.rds.connect(
                resource_arn= db_cluster_arn,
                database= database,
                secret_arn= db_credentials_secrets_store_arn,
            )

# Attempt to insert data into a PostgreSQL table with a UUID column using awswrangler
try:
    wr.data_api.rds.to_sql(
        df=df,
        conn=conn,
        table=table_name,
        database=database,
        use_column_names=True,
        mode="append",
        sql_mode="ansi",
        index=False
    )
except Exception as e:
    print("An error occurred:", e)

Expected behavior

No response

Your project

No response

Screenshots

No response

OS

Mac

Python version

3.11.6

AWS SDK for pandas version

3.9.1

Additional context

No response

[jethroguce]

@jaidisido can you take a look at this, I have already created a PR request