In database retrieves you can access a subset of data by multiple filter statements at once.
This is not possible with lists objects.
If you want to filter down a list based on 2 or more attributes, you need to do multiple filters sequentially.
This is unnecessary and bad for performance of large lists.