Most complete implementation of HQL

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Most complete implementation of HQL

Post by alex.barylski »

I'm in need of an robust, comprehensive SQL OO builder/interface, but that is it. No ORM, no access layer, etc. Just the classes used to construct any imaginable SQL, apparently HQL supports aggregates, sub-queries, etc which should meet all of my searching requirements.

I'm in the process of implementing my own but i only have the CRUD-S functionality done and it's a daunting task trying to think of every condition, etc. I'd rather use someone else's or have something to go on.

I'd prefer to stay away from those that use extensive amounts of arrays, such as:

Code: Select all

$where = new Where('field', '=', $value);
Prefering a fluent interface, something like:

Code: Select all

$where->field->equals($value);
If possible. Does anyone know fo a project like this or has any experiences you'd care to share with moi?

Cheers,
Alex
Post Reply