Support array / list types in postgresql.to_sql

[m1hawkgsm]

Is your idea related to a problem? Please describe.
I frequently use AWS SDK for Pandas in moving data between Postgres RDS instances. Recently, I had an issue where, reading a table from a source database with a varchar[] column, I could not write it using postgresql.to_sql()

Upon checking the code, I see that in here, you don't support arrays, even though apparently dictionaries (I guess JSON?) types are fine?

Any reason why that's the case?

Describe the solution you'd like
Ideally, arrays are handled normally (it's a valid PyArrow Type).

P.S. Please do not attach files as it's considered a security risk. Add code snippets directly in the message body as much as possible.