That's not the syntax supported by SQL::Statement (see SQL::Statement::Syntax). The columns for creating the table are specified in the SELECT part and created in the new table automatically. So change the create statement to:

$dbh->do("
    CREATE TABLE template
       AS SELECT IP, ServerName, Domain, DaysUptime, OS,
                 RAM, OSSP, InstallDate, CPUSpeed, CPUCount,
                 CPUType
            FROM hosts
       LEFT JOIN info
              ON hosts.IP = info.IP
");
[download]