Pull from Redshift and Postgres steps now support the use of common table expressions! Use CTEs to make your queries more manageable and easier to read.
Learn more about CTEs in the Postgres documentation here.
Source: https://parabola.io/updates/cte-support-in-redshift-postgres-steps