[Dbix-class] retrieve_from_sql

[Emanuele Zeppieri]

> -----Original Message-----
> From: dbix-class-bounces at lists.rawmode.org 
> [mailto:dbix-class-bounces at lists.rawmode.org] On Behalf Of 
> Matt S Trout
> Sent: Monday, August 01, 2005 2:18 AM
> To: dbix-class at lists.rawmode.org
> Subject: [Dbix-class] retrieve_from_sql
> 
> 
> Does anybody use this? More importantly, is anybody using it 
> out of choice
> or is it purely being used to get round Class::DBI (or 
> whatever ORM) having
> insufficient flexibility to let you construct the query in an asbtract
> fashion?
> 
> It's part of the Class::DBI API so we need to support it in 
> the compat layer
> at least, but if we're going to abstract away the database 
> layer entirely
> (which is necessary for e.g. Rosetta, let alone something like an LDAP
> backend) I think we should probably only support abstract 
> formats in core,
> primarily SQL::Abstract style as currently and perhaps 
> Tangram style later.

IMO entirely abstracting away the database layer is *NOT* a good idea at
all.
Nor SQL::Abstract can satisfy any need about SQL queries: it can become
extremely convoluted for complex queries.
Leave the user the opportunity to resort to raw SQL if she/he wants,
please.

Ciao,
Emanuele.