Laravel自定义字符串作为字段

Question

How would I convert the following statement into laravel's eloquent or Query builder:

Select *, 'admin' as type from users.

its the 'admin' as type is where im having problem in converting it on laravel. Thanks

Answer 1

I would rather figure out why MSSQL is handling it that way, or the adapter but since that raw SELECT directly on the connection works, you can do that with Eloquent as well:

App\User::fromQuery("select *, 'admin' as type from users");

You will have a Collection of models hydrated from that result.