What is the best practice for managing database views?
I can see a Migration with a raw SQL statement() to create the view, and then creating a Model to read that data.
I can also see writing the view SQL as a Query Builder statement, and executing that as needed.
I found an old StackOverflow question (with almost recent answers). Is there a good answer in there? https://stackoverflow.com/questions/36287364/how-to-create-the-migrations-for-database-views-using-php-artisan-in-laravel/46199457#46199457
#Best practice for Database View?
modern river
odd dragon
Just out of curiosity, why use views? Couldn't you achieve the same with scopes?