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

[Zbigniew Lukasiak]

I was confused by the title (interpreted 'subqueries' as 'SQL
subqueries' not 'SQL::A subqueries').

I am sorry for the noise I've generated.

Z.

On Tue, Nov 4, 2008 at 10:02 AM, Dami Laurent (PJ)
<laurent.dami at justice.ge.ch> wrote:
>
>
>>-----Message d'origine-----
>>De : Zbigniew Lukasiak [mailto:zzbbyy at gmail.com]
>>Envoyé : mardi, 4. novembre 2008 09:25
>>À : DBIx::Class user and developer list
>>Objet : Re: [Dbix-class] SQL::Abstract 1.x subqueries patch
>>
>>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).
>>
>
> Same problem with many other clauses like 'MATCH .. AGAINST ..', etc.
>
>
>>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.
>>
>
>
> SQLA1.50 implements that convention : \[$sql, @bind] is interpreted
> as literal SQL. There are a couple of other extensions -- have a look
> at the L<CHANGES> section.
>
> Laurent Dami
>
> _______________________________________________
> 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/