Amazon Redshift announces support of the CONNECT BY SQL construct
Amazon Redshift, a fully-managed cloud data warehouse, now supports the CONNECT BY SQL construct enabling users to author queries to process hierarchical data in their warehouse. Starting today, you can recursively query the hierarchical data based on parent-child relationship within that data set using the CONNECT BY construct.