[Dbix-class] SQL::Abstract 1.x subqueries patch

[Zbigniew Lukasiak]

One thing that I am really missing from SQL::A is a way to specify an
arbitrary SQL fragment together with bindings and have it interpolated
into the rest of the query and bindings.  In DBIC with
'search_literal' method and 'where' attribute you can add arbitrary
SQL - but only at the beginning or the end of the query and frequently
it gets the bindings in the wrong order.  In standard SQL::A there are
many tricks you can do - but for example clause like:

? REGEXP keyword

cannot be normally represented in SQL::A ( you can try tricks like {
$value => { '' => '' },...  } - but there is always something wrong in
the resulting query).

Long time ago I've patched my SQL::A version and added a rule that
double reference to array was resulting in $array[0] being
interpolated into the query and the rest into the bindings array.
This is in a way extending the convention that reference to a scalar
is interpolated as literary SQL.  I did not used it for long - and it
is lost now - but I can recreate it if such a hack could be accepted
into the main SQL::A tree.



On Tue, Nov 4, 2008 at 12:03 AM, BUCHMULLER Norbert <norbi.lists at nix.hu> wrote:
> On Mon, 3 Nov 2008 12:28:40 +0000 Ash Berlin <ash_cpan at firemirror.com>
> wrote:
>
>> Yeah, I think the best plan of attack is to move as much out of
>> DBIC::SQL::A as possible, and then bump the dep on DBIC to SQL::A
>> 1.50.
>
> Matters got bit more complicated: some bits should be merged into
> SQL::Abstract::Limit instead. I'll try to contact the
> SQL::Abstract::Limit maintainer (Dave Baird) and ask if he has the time
> to review/apply patches to SQL::A::L and coordinate a public release with
> us.
>
> norbi
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>



-- 
Zbigniew Lukasiak
http://brudnopis.blogspot.com/
http://perlalchemy.blogspot.com/