Subquery error when filtering columns

Hey all. I'm looking for some help with an error I'm receiving. Here is some additional context:

I have a Redshift data warehouse. I have a table materialized in Redshift. When I create a new question and use the raw data lookup to find and query said table, and include all fields, Metabase executes successfully.

However, when I filter out some of the columns, I get an error message when visualizing:

ERROR: This type of correlated subquery pattern is not supported due to internal error

It seems like this error only appears when certain fields are included or excluded. Have you ever seen this before?