Laravel Complex query in Eloquent

Select date,count from ( Select * from A Union Select * from B) As C group by date order by date

How to convert this to laravel .

"Select * from A Union Select * from B" this part is done.

Self::select()->union("Select * from B");

Level 39

When you have your sql the easiest way is to use db facade

$res=DB::select("your_sq"l);

Converting it to Eloquent will make you lost two times (coding & cpu because eloquent reconvert it to sql)

Please or to participate in this conversation.