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')); }