Using laravel DB queries but returned as a Eloquent Model [duplicate]

Question

I was wondering if it is possible to query using DB facade but returned as an Eloquent Model.

For example i have this query using db query builder

\DB::table('users')->first();

But after the query I want all results to be an Eloquent model from App\User

same results of this

\App\User::first()

my goal for this question is what if I have complex query that returns a sets of users. Using eloquent model is not really efficient i think that's why I use the query builder for raw querying but I also want the results to be a Eloquent model instance.

@TsaiKoga I don't think it is duplicated. I want to return it as a eloquent model like App\User not as a collection — KevDev
– KevDev, Commented Nov 22, 2019 at 6:31
It will have the same efficiency. The slowness added on Eloquent when you do a query is almost from some data processing when you instantiate the model. If you are going to instantiate it, so you will have the same efficiency. — Elias Soares
– Elias Soares, Commented Nov 22, 2019 at 9:48
@EliasSoares I thought of that also but maybe there are some small differences i'll have to check it my self — KevDev
– KevDev, Commented Nov 22, 2019 at 12:19

Adrian Edy Pratama · Accepted Answer · 2019-11-22 04:06:35Z

-2

Maybe you can use the collect function, It can help you to have many methods like what eloquent return to you. You can see all the methods here.

The code would look like :

use Illuminate\Support\Facades\DB;

collect(DB::table('users')->first())

answered Nov 22, 2019 at 4:06

Adrian Edy Pratama

4,1012 gold badges12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

KevDev Over a year ago

unfortunately collect function is not what I am looking for. collect function convert an array into collection. What I want is to return the query into a eloquent model

Don't Panic Over a year ago

collect() makes a collection, it does not magically convert an array to a Model instance.

Adrian Edy Pratama Over a year ago

Yeah, I said it just like, but of course it's not a model instance

Elias Soares Over a year ago

DB already returns a collection

Collectives™ on Stack Overflow

Using laravel DB queries but returned as a Eloquent Model [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related