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


in reply to Marpa::XS for SQL INSERTs?

You could try using ANTLR which is generally recommended for parsing SQL mainly because of SQL's peculiar syntax rules

There are example sql grammars online

Then have a look at Using ANTLR and PerlXS to Generate a Parser on how to integrate the resulting parser into Perl

But,I don't know if it is worth the trouble for just parsing an INSERT