Hi Aaron,
Thank you for reporting this issue. It should affect not only Redshift/PostgreSQL, but any other database connector. It seems to be an oversight on our end. We will try to fix it in one of the following releases.
As for the “Sanitize Text” action - it’s not intended to fix such issues. But we are thinking about creating an action like “Sanitize value for database” or something like that.