In redshift you unnest the super array into rows in order to search them
https://docs.aws.amazon.com/redshift/latest/dg/query-super.html