Re: feature request for SQL::Statement::Structure

Jens Rehsack wrote:
> Am 11.04.2012 04:58, schrieb Darren Duncan:
>> That's what I would do if I were making a SQL parser.  Oh wait, I am!
> 
> Just another SQL Parser? Why not taking/improving one of the
> existing ones? Or is it, because they're not invented "here"?

No, not "just another"; I don't do that kind of thing.

I'm creating a new general purpose but database savvy programming language, 
first implemented in Perl 5 but that ultimately would self-host, which one can 
either use to write an application in or write a DBMS in.  I am also writing a 
module in this language which provides all the API and semantics of SQL. 
Thereby, one can "write SQL" using either the native syntax of the language, 
which looks loosely like Perl, but I would also provide a parser for actual SQL 
syntax that maps to the SQL-semantics module, so one can take existing SQL code 
and run it in Perl.  The initial Perl 5 implementation would implement a DBMS 
natively, but subsequently there is the option to farm out to or map to existing 
DBMSs, which can be quite direct for code mapped to the SQL-semantics module.

I expect that I will try to utilize existing SQL parsing modules on CPAN for my 
project where they are capable enough or are designed in a manner that they can 
be made capable enough without a rewrite.  My reason to exist isn't SQL parsing 
for its own sake, but SQL parsing would support the other things.

Do you know any SQL parsing modules that can actually *run* the SQL in Perl or 
that generate Perl code from SQL that does the same thing with Perl data?

-- Darren Duncan