Use case
Conditions that are not related to JOIN:
t1 JOIN t2 ON t1.k = t2.k AND t1.hello = 'world'
should be transformed to:
t1 JOIN t2 ON t1.k = t2.k WHERE t1.hello = 'world'
otherwise it does not work.