This new Pipe syntax seems a reasonable proposal for complex analytical queries. The new syntax probably does not change most simple transactional queries though. The syntax matches the execution semantic more closely, which means you less likely need to formulate query in a weird form to make query planner work as expected.