[Dbix-class] PATCH: Support for arbitrary SQL in relationship definition

[Daniel Ruoso]

Em Dom, 2009-06-21 às 13:57 +0200, Peter Rabbitson escreveu:
> Daniel Ruoso wrote:
> > Using scalar ref to allow arbitrary SQL is consistent with SQLA, since
> > you can use it in regular SQLA where data structures, so I think it's
> > not really weak or incomplete...
> As I say in [1], as soon as a viable general solution is proposed, it will
> be written. If not - the 09 dev cycle will come up with a new syntax which
> will solve this shortcoming once and for all. (this btw seems more likely,
> as any time a discussion to solve this within 08 is solicited, everyone
> goes silent)

Hmm... At the risk of overlooking a lot of already settled issues, I'm
not sure I agree that the declaration of the schema is at the same level
as the query. I mean, the impact of a change in the schema declaration
is considerably smaller than a change in the query syntax.

I agree with you that a change in the query syntax needs to be generic
to the level you express, but the schema declaration is much less
fragile, imho, and thus it wouldn't be so problematic to make a cheap
choice.

I'm pushing this a bit because I'm already using this in production, in
a software that is going public this week... I wouldn't like to have it
as a monkey patch...

daniel