local $/="\ngo\n";
while(<IN>) {
    chomp;
    # now the entire statement is in $_...
    ... execute the SQL statement, with error checking, etc.
}