Creating custom 'order_by' string

[eluser]MABUS[/eluser]
Hi,

Is there a way to ORDER BY a specified CASE or IF in CodeIgniter? Right now, I am having to write my entire query in SQL. I'm curious to find out if there is a CI way to do this.

In addition to this, I also want to know if active record class methods is able to handle additional query strings.