Laravel支持与AS的表和列上的别名。尝试
$users = DB::table('really_long_table_name AS t')
->select('t.id AS uid')
->get();
让我们看看它在行动与一个真棒修补匠工具
$ php artisan tinker
[1] > Schema::create('really_long_table_name', function($table) {$table->increments('id');});
// NULL
[2] > DB::table('really_long_table_name')->insert(['id' => null]);
// true
[3] > DB::table('really_long_table_name AS t')->select('t.id AS uid')->get();
// array(
// 0 => object(stdClass)(
// 'uid' => '1'
// )
// )