in my recent project i needed to query the database directly because of some heave datatables calculations that where too slow via $pages->find() operation in a foreach.
so far, so good - everything works fine now. but the query got quite complex, hard to setup and hard to read (maintain). the problem is that you have to join all the fields to get all fields of one template. and this join operations can get quite confusing when you have lots of fields.
any hints how i c