Problems with Active Record

[eluser]TheFuzzy0ne[/eluser]
Check out the active record source. Ot my knowledge, it just uses regular expressions to escape fields (which sometimes it gets wrong so we have pass in FALSE as the second paramter). The active record class doesn't "need" to know about aliases, as it's the database that figures it out when the query is executed.

For example, there should be nothing stopping you doing something like this:

Code:

$this->db->order_by('something');
$this->db->limit(10);
$this->db->from('some_table');
$this->db->select('field1, field2, field3');

The statement is declared backwards (which you wouldn't get away with using pure SQL). The query is only compiled when you call $this->db->get(). As I said, check out the source and you'll see what I mean.