Support non-tuple expression for in-subquery to join

[ygf11]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
This sql works in datafusion:

> select * from t1 where t1_id in (select t2_id from t2);

but following sql does not works:

> select * from t1 where t1_id + 11 in (select t2_id from t2);
NotImplemented("Physical plan does not support logical expression CAST(t1.t1_id AS Int64) + Int64(11) IN (<subquery>)")

Describe the solution you'd like
We can rewrite these subquery to join.

Describe alternatives you've considered

Additional context

[ygf11]

I am working on it.