DanTMan schreef:
We've got multiple options on how to fix this:
- Find a better way to make complex queries using the Database class
that doesn't involve building complex queries, and then trying to shove them into the simple handlers. This would greatly improve cross-db compatibility if done.
That should definitely happen. More specifically, we should have support for LEFT/RIGHT JOINs in the Database class. I think this kind of obsoletes 2, 3 and 4, because the only occasion on which the API sends full-blown SQL to Database::select() is to do LEFT JOINs.
Roan Kattouw (Catrope)