Make Cypher not introduce eagerness in some trivially decidable cases

In particular, we do not want the plan for:

```MATCH a, b CREATE (a)-[r:X]->(b)```

to contain an EagerPipe.
Remove isLazy from Pipe and replace it with Effects.NONE where applicable