[eluser]northpole[/eluser]
i'm currently designing the models for my project.
the idea is to use only CI’s built-in methods instead of direct sql to make up queries.
that way, should the management decide not to use mysql anymore (and there’s possibility for that), my team will not be needed to modify the code (because there might be differences about how we select something from a table in mysql and, say, postgres).
but apparently there are some reports whose structures require complex queries.
so complex to the point using db->join and friends will only make the code confusing and hard to read.
is there a way to solve the problem?
