Making A Laravel Model Use Complex Query As Table

I am developing a web app that interfaces with an ERP production database and the data is being retrieved by a complex SQL query with many joins and aliases before being passed to

Solution 1:

You can turn SQL command into VIEW (CREATE VIEW) then use it just like ordinary table in your model.