Page 1 of 1

Most complete implementation of HQL

Posted: Thu Jul 16, 2009 3:04 pm
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