Its query builder is super transparent, consistent and flexible, thanks to LINQ, but still generates very performant queries.