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 <[EMAIL PROTECTED]> wrote: > On Mon, 3 Nov 2008 12:28:40 +0000 Ash Berlin <[EMAIL PROTECTED]> > 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/ _______________________________________________ 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