public function getExample5()
{
$query = \DB::getDoctrineConnection()->createQueryBuilder();
$query->select(['id', 'name', 'email', 'country', 'posts_count'])->from('users')->where('posts_count > 40');
$cfg = (new GridConfig())->setDataProvider(new DbalDataProvider($query))->setPageSize(5)->setColumns([new FieldConfig('id'), new FieldConfig('name'), new FieldConfig('email'), new FieldConfig('country'), new FieldConfig('posts_count')]);
$grid = new Grid($cfg);
$text = '<h1>Grid with DbalDataProvider</h1>';
return view('demo.default', compact('grid', 'text'));
}