we truly agree with you - the proof of that is that we have decided to change the DAL completely. With Sitefinity 4.0 we will integrate Telerik OpenAccess as the ORM tool which is incomparably more powerful and supports OQL and LINQ query among many other features.
With this capabilities we will also be able to improve the API (at first only the GenericContent API) to be much simpler and at the same time more powerful - and everything will perform much better due to reduced database trips.
This transition is at the heart of Sitefinity 4.0 and it will surely be included.
Thank you for your understanding.
the Telerik team
Check out Telerik Trainer
, the state of the art learning tool for Telerik products.