Better AR with Yii - 1

FooController.php

<?php
class FooController extends Controller {
    public function actionIndex()
    {
        // showing newer Foo models.
        $this->render('index',array(
            'dataProvider' => new CActiveDataProvider(
                'Foo', array(
                    'criteria'=>array(
                        'order'=>'created_on DESC',
                        // Bad MVC because SQL semantic is in controller.
                    ),
                )
            ),
        ));
    }
}