Redshift should work as it is PostgreSQL based - under the hood we use simple DML, DDL and COPY commands. We haven't yet tested it, but worth giving it a shot! We have user testing PeerDB for a redshift like database and it works.

Not as trivial as some data types are different (jsonb, array, uuid etc) but will give it a try

Gotcha, worth giving it a shot! If any data-type behaves finicky let us know (via github issue), we should be able to add support quickly.