This allows information to be retrieved, inserted, and updated in your database with minimal scripting. In some cases only one or two lines of code are necessary to perform a database action. It provides a more simplified interface.
By means of this you not have to write long long sql query.
Thais will improve your coding speed, code readability
In sort, write beautifull code with minimum effort
$query = $this->db->get('mytable', 10, 20);
// Produces: SELECT * FROM mytable LIMIT 20, 10
Note: Please take back up of system/library/db.php before installing this
Contact for support