in reply to RFC - A multi table SQL Builder

I've got a SQL generator module named DBIx::SQLEngine that could benefit from this capability. It can currently generate select join queries but only if the caller specifies the join; it'd be nice to be able to determine that on the fly.

Perhaps rather than first creating a user-facing module, you could separate out the abstract table mapping engine into a separate module that could be used behind the scenes by other modules like Class::DBI, DBIx::SQLEngine, and some future SQL::Abstract extension?

Replies are listed 'Best First'.
Re^2: RFC - A multi table SQL Builder
by dragonchild (Archbishop) on Oct 18, 2004 at 17:49 UTC
    Ok. As one of the potential clients, I offer you a challenge - what sort of API do you want to have in this behind-the-scenes module? What requirements do you, the maintainer of DBIx::SQLEngine need in order to make this work for you?

    In fact, I offer this challenge up to anyone who might want to use this type of functionality. What specifications are needed? What API? What features? What type of performance? One thing to note is that this is completely PurePerl, if that makes a difference.

    Being right, does not endow the right to be rude; politeness costs nothing.
    Being unknowing, is not the same as being stupid.
    Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
    Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.

[reply]

In Section Meditations