I figured it out but there's almost certainly a better way to do this - open to suggestions. I used ChatGPT to figure it out (link to my chat: ChatGPT).
I created a transformer that makes the necessary modifications so that the array is formatted in a matter that PostgreSQL wants for arrays.
