Disable check for correlated subqueries, basically those types of queries transforms to join (aggr(table2), table1), table2) and post join scalar filter.
