laravel - Laravel查询生成器-如何为子查询添加别名？

Question

如果我有以下代码:
DB::table('A')->join(DB::table('B'), ...)
这导致此SQL:
select * from "A" inner join (select * from "B") on ...
如何为该子查询添加别名？如select * from "A" inner join (select * from "B") as "Boron" on ...
我宁愿不必使用原始sql。

Answer 1

子查询的简单解决方案是DB::raw，它也可以解决别名。

        $items = DB::table('A as Amy')
            ->select('*')
            ->join(
                DB::raw("(select * from B) as Boron"),
                'Amy.keyA', '=', 'Boron.keyB')
            ->get();