I often see DB::raw being used for subselects, but you can do them in query builder using a closure as the 2nd argument on the where clause.