DBIx::Class - Related Tables

[Dave Hodgkinson]

On 7 Oct 2008, at 08:42, Andy Wardley wrote:

> Dave Cross wrote:
>> This is probably simple,
>
> This is the general problem that I have with ORMs.  You have something
> which is a fairly straightforward SQL query but can't figure out how  
> to
> make the ORM generate the query that you already know you want.
>
> It's a bit like using a phrasebook to speak a foreign language.   
> They're
> great for ordering a croissant in a cafe, but are ultimately limited  
> and
> in some cases, can be counter-productive.


Then what's the benefit of an ORM? (general question, not just to you :)


I'm a big fan of an application-specific wrapper over the d/b that
does what you need, so in Dave's case a get_highest_version() sub
with the SQL inside. Is that now passé?

-- 
Dave Hodgkinson                                MSN: davehodg at hotmail.com
Site: http://www.davehodgkinson.com                   UK: +44 7768 49020
Blog: http://davehodg.blogspot.com                    NL: +31 654 982906
Photos: http://www.flickr.com/photos/davehodg