Re: parsing SQL statement

On Fri, 2008-05-30 at 19:24 +0700, beast wrote:
> Anyone having suggestion parsing SQL statement?
> 
> It should able to parse:
> 
> BLA BALA BALA...
> 
> VALUES(
>   'abcd efg',,999, 'some \"STRING\" and \'STR2\' STR3',,,, 'abcd, def, fghi'
> )
> 
> I'm using tr and then split by "," but it will fall when seeing comma
> inside the single quote.
> 

I'm actually about to look into a SQL parsing solution myself.  There
appear to be several modules on CPAN which should be at least a good
place to start.  

> Thanks.
> 
> --budhi
>