If you have a GET method (url) for that page, due to a filter function of a form, then they are messed up and no result. Especially if you have also a
where clause within this query.
The point is, the thing I can easily do with pure PHP cannot be easily done with our framework. For an easy and consistent CodeIgniter way of query, the method in the model should end with a classsical CI way, for example, $query->getResult(); However, now we have to start our statement with a "return" which is "a solution" and in the end it is not working properly. This is not a framework design kenjis. We are not trying something exraordinary or we do not need anything which is required only for one project.
As I said, when I try it with pure php it works well but with CI it doesn't. And I don't want to mess up my project working with two different sql styles.