my $sth = $dbh->prepare( $ctas_sql );
     $sth->execute();

  while( my $row = $sth->fetchrow_arrayref ) {
     # do whatever with $row
  }