Eloquent Power Joins
The Laravel magic you know, now applied to joins.
Joins are very useful in a lot of ways. If you are here, you most likely know about and use them. Eloquent is very powerful, but it lacks a bit of the "Laravel way" when using joins. This package make your joins in a more Laravel way, with more readable with less code while hiding implementation details from places they don't need to be exposed.
A few things we consider is missing when using joins which are very powerful Eloquent features:
- Ability to use relationship definitions to make joins;
- Ability to use model scopes inside different contexts;
- Ability to query relationship existence using joins instead of where exists;
- Ability to easily sort results based on columns or aggregations from related tables;
You can read a more detailed explanation on the problems this package solves on this blog post.