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) <[EMAIL PROTECTED]> wrote: > > >>-----Message d'origine----- >>De : Zbigniew Lukasiak [mailto:[EMAIL PROTECTED] >>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/
_______________________________________________ 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
