On Tue, 2002-03-12 at 13:24, Jeff Zucker wrote: > "Randal L. Schwartz" wrote: > > > > Wait! Don't we already have a SQL::Statement or something? Why are > > we reinventing things? > > As I understand it, the pre-parser that will be part of DBI will be very > limited in scope and will not parse SQL. Essentially it will just > handle things like comments, escaping of quotes within quoted values, > and placeholders but won't know anything about SQL syntax itself. Those > also seem like the kinds of things the other Jeff is talking about for > DBD::Pg. > > SQL::Parser and SQL::Statement do actual SQL parsing, a different kettle > of fish. > > If I'm wrong and DBD::Pg needs some kind of SQL parsing on its own > (though I can't see why it should since Pg can do that by itself), then, > by all means, let's talk about what SQL::Statement already does.
Other Jeff is correct. The only requirement is to find placeholders not in quoted sections and not in comments. -jwb
