$sql =~ s/((?<=select)|(?<=,))\s*[^,]*?\s+as//gi ;