burnbright/silverstripe-sqlquerylist

Wraps a SilverStripe SQLQuery in a SS_List

SilverStripe SQLQueryList

Create DB-driven SS_Lists based directly off a SQLQuery. Particularly useful for reporting., _(*1)

composer require silvershop/silverstripe-sqlquerylist

But why?

The SilverStripe ORM doesn't allow you to work with advanced SQLQueries. You could pass the output of a SQLQuery to an ArrayList, but this approach will always retrieve all records, which can mean memory gets used up., _(*2)

Records can only be displayed, ordered and filtered. Adding / removing and manipulating records does not work., _(*3)