将SQL转换为Laravel 5.1 - Converting SQL to Laravel 5.1

我正在将一些项目从纯PHP转换为Laravel 5.1，在转换此查询时遇到问题：

'DB::select( "SELECT TABLE_NAME as nombre, FORMAT(TABLE_ROWS, 0) as cantidad 
              FROM information_schema.tables 
              WHERE table_type = 'BASE TABLE' AND table_schema = '".env('DB_DATABASE')."' " );

Eloquent ORM。你能帮我吗？

这是编写的另一种方法

'DB::table('tables')
    ->where('table_type', 'BASE TABLE')
    ->where('table_schema', env('DB_DATABASE'))
    ->select(
        'TABLE_NAME as nombre',
        'DB::raw('FORMAT(TABLE_ROWS, 0) as cantidad')
    )
    ->get();