For programming, the use-case for EF or expression-tree queries is the specification pattern. Although you are correct that it doesn't handle complex queries v

For programming, the use-case for EF or expression-tree queries is the specification pattern. Although you are correct that it doesn't handle complex queries very fast ( the ORM), there is definitely a valid motivation to use/enforce it. Complex queries are mostly handled through something like elastic search or search engine ( azure), the goal is to keep queries simple and if the code is loosely coupled, it's easier to do this.