http://www.perlmonks.org?node_id=960484


in reply to Parse and change an SQL statement

I've played with Percona's Maatkit which has an SQLParser and it did an excellent job with the sql that I pushed through( Granted that my set wasn't extremely large). Have a look at http://code.google.com/p/maatkit/source/browse/trunk/common/SQLParser.pm.