Scan should support secondary indexes but it doesn't. AWS best practices on specifying if a record is active/deleted is to use a local index and scan together.
I copied the function over from the query but wondering if this package can be updated before i have to public fork.