How to use Laravel Eloquent Relationships with complex queries?

Question

Laravel

Is it possible to create a model that does not have a table associated with it? For example, you often want to have a complex SQL query with group by, joins, etc. as a record source. As a partial solution, I used the Database View.

Sometimes you generally want to create records in PHP without accessing the database. I also want to use scopes to pass some parameters.

In other words, in the definition of the model, instead of a simple $this->hasMany(....), I want to cram some kind of complex SQL query with parameters, or not use a database call at all.

Of course, using save() on such related models is no longer possible, but I want to use such models in relay chains.

Answer 1

What is the question? For this, there is a Query Builder, in which you can do anything, relations have nothing to do with it and exist in parallel.