Judging by the first documentation page I found, I wouldn’t even recognize the syntax as the LINQ I’m used to.
Personally, I hate the expression syntax. I would stick with the method syntax. (That you know and use and that ZLINQ is compatible to.)
The good thing about method syntax is that you have a clearly scoped context and state flow. You type .Where, add a condition that is limited to the Where precondition parameter expression body, and afterwards have a clear state/result again.
That is not the case in expression syntax. You can have variables, the operator order and aliasing is confusing, it's SQL but worse.
I agree that in the context of gamedev you could generalize and call it such, but even then, saying "LINQ produces garbage" is over-generalized and missing context. It's the wrong tool for the job/gamedev. Doesn't mean it produces garbage/junk. In my eyes anyway. I feel like that context is important.
For me, garbage implies no use. What it allocates it makes use of. It's just the wrong approach alltogether for gamedev.