Merges and hoists SERVICE calls, so that as much of the plan as possible is evaluated by the endpoint
rather than around it.
Three rewrites: sibling SERVICE calls to one endpoint become a single call over the operation that
joined or united them; a SERVICE that is the sole input of a congruent operation swaps places with it;
and the VALUES clauses of a join over nothing but VALUES and SERVICE are pushed into each service,
where the endpoint can apply them as an early filter.
Merges and hoists SERVICE calls, so that as much of the plan as possible is evaluated by the endpoint rather than around it.
Three rewrites: sibling SERVICE calls to one endpoint become a single call over the operation that joined or united them; a SERVICE that is the sole input of a congruent operation swaps places with it; and the VALUES clauses of a join over nothing but VALUES and SERVICE are pushed into each service, where the endpoint can apply them as an early filter.