I've been using PHPLIB's DB abstraction layer for more than a year, and I like it.
However, I think that there is more future in PEAR (PHP's equivalent to CPAN), although PEAR still needs a lot of documentation.
If I were starting a new project from scratch now, I'd probably go for PEAR's DB-abstraction, due to the potential integration with the other parts of PEAR.