add join-lateral && case-when clauses

[newmen]

Sometimes we need to use the JOIN LATERAL construction to optimize our queries. But such clause not so useful without CASE WHEN THEN expression, so I've added both ones.

[kitallis]

Thanks for the PR @newmen. Apologies for the late response. I'll take a look at it this week.