Doesn't seem to be doing much 'filtering' so the module name is somewhat misleading.
(Not to mention the fact that ($a,$b) =~ ... won't do what you seem to be expecting.
I suggest that you get something working then discuss it on dbi-users.)
Tim.
On Mon, Jul 30, 2001 at 11:12:09PM +0200, Perl Authors Upload Server wrote:
>
> The following module was proposed for inclusion in the Module List:
>
> modid: Filter::SQL
> DSLIP: idpfp
> description: Gives a regex style interface to SQL queries
> userid: JSMITH (James G Smith)
> chapterid: 7 (Database_Interfaces)
> communities:
> [EMAIL PROTECTED]
>
> similar:
>
> rationale:
>
> Some people are scared by the `complex' interface the DBI presents.
> By making a simpler syntax, people might be more likely to consider
> Perl for SQL work.
>
> For example, given proper setup (yet to be determined), the
> statement
>
> my(@results) = ($table, $user) =~ sql{SELECT * FROM ? WHERE
> username=?};
>
> will result in @results possibly being a tied array with access to
> the results of the SQL query. The bound elements are substituted in
> as usual, with $_ or @_ being the default argument(s) (yet to be
> determined).
>
> enteredby: JSMITH (James G Smith)
> enteredon: Mon Jul 30 21:12:09 2001 GMT
>
> The resulting entry would be:
>
> Filter::
> ::SQL idpfp Gives a regex style interface to SQL queries JSMITH
>
>
> Thanks for registering,
> The Pause Team
>
> PS: The following links are only valid for module list maintainers:
>
> Registration form with editing capabilities:
>
>https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=b5000000_4a255b870734d401&SUBMIT_pause99_add_mod_preview=1
> Immediate (one click) registration:
>
>https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=b5000000_4a255b870734d401&SUBMIT_pause99_add_mod_insertit=1
