A good PHP SQL abstraction class?

[ZaBlanc]

I'm not new to PHP, but new to actually using it practically. :-) Does anyone know of a good SQL library that can encapsulate queries and make constructing them in general much easier?

I don't need something as serious as Propel, what I need is something ala:

$query = new Query();

$query->addField("first_name");
$query->addField("last_name");

$query->addTable("user");

$query->addCondition("id = ?", 43);

Anything?

[Shrike]

There is a nifty module in the Zend Framework which encapsulates SQL queries. It is database agnostic meaning queries are written dependent on the db driver selected. However it is based around the underlying data access object in the framework, which is itself based on PDO. Might be of some help though.

[ZaBlanc]

I plan on using PHP on Trax. And by the way, where is the best place to search for modules? I've used PEAR to download remotely and locally...but where's a good list. I searched at PEAR's site but didn't see anything too hot concerning SQL.