[Dbix-class] retrieve_from_sql

Darren Duncan darren at DarrenDuncan.net
Sun Aug 7 22:39:24 CEST 2005

At 1:28 PM +0200 8/4/05, Krzysztof Krzyzaniak wrote:
>Matt S Trout wrote:
>>In that direction you might be better off looking at Darren Duncan's
>>Rosetta + SQL::Routine code; he's already gone the formal grammar approach
>>so we're likely to use that for an implementation at some stage.
>Fix me if am I wrong. I wonder if any of abstract sql modules 
>support functions (builded or defined by user) - I mean something 
>like "SELECT function1(field), function2(field) WHERE 
>function3(field) = NULL;

SQL::Routine has native support for invoking both built-in and user 
defined functions, and you can use them in queries as easily as table 
columns.  Moreover, to aid in readability and reduce programmer 
errors, all arguments to these functions are defined in named format. 
-- Darren Duncan

More information about the Dbix-class mailing list