jQuery based data table plugin is quite useful in term of no. of function it has. With our script, if you want to use the sql and still want search/sorting/pagination etc functions, you can use this plugin. You will have most of the grid/table functionality using this.
$pdocrud = new PDOCrud();
$pdocrud->addPlugin("datatable");//to add plugin
$pdocrud->setQuery("select * from orders");
echo $pdocrud->render("SQL");
echo $pdocrud->loadPluginJsCode("datatable",".pdocrud-table");//to add plugin call on input[type=text] elements