Is there a way to map a raw query to a Model

Question

I have a complex raw SQL query that I don't want to retro-convert to query builder. Is there a way to map the result of the query to a model?

In short, I have this kind of query:

SELECT users.* FROM users
WHERE exists (super_long_raw_query)
AND many_more_raw_where_clauses
ORDER BY something_complex
etc;

It only returns columns from one Model (from a table corresponding to a model).

It would be terrible and not readable to convert it to a "Laravel Query Builder" query:

User::where(/* ... */)
    ->whereExists(function() { /* super complex callback */ } )
    ->etc(/* ... */)

The raw query is easier (in this specific case) to read.

Is there a way to map a raw query to a model? (assuming it only returns the columns of a specific model)

Side note: It's a raw query that uses query parameters (?, :something) because I don't want injections.

Answer 1

Use fromQuery()

$query = \Illuminate\Support\Facades\DB::raw('select * from users');
$users = \App\User::fromQuery($query, []);

Answer 2

You could use hydrate method:

$users = User::hydrate(
    DB::select('super_complex_query_with_params', [$params])
);

See: https://laravel.com/api/5.6/Illuminate/Database/Eloquent/Builder.html#method_hydrate