Re: RFC: SQL::Preprocessor - a SQL filter for Perl

[Jeff Zucker]

[redirected to dbi-users]
Dean Arnold wrote:
use SQL::Preprocessor;
EXEC SQL CONNECT TO 'mydsn' USER userid IDENTIFIED BY password;
EXEC SQL SELECT * FROM mytable;
foreach my $row (@$_) {
    print join(', ', @$row), "\n";
}
EXEC SQL DISCONNECT;
__END__
It seems to me, that wouldn't be a gain over
   dbish run("SELECT * FROM mytable") mydsn userid password
And that DBI::Shell can be tweaked to do most of what you're proposing 
(as far as I've understood it).

--
Jeff