Can flux support in clause

Can flux support in clause?
Such as: select value from measurement1 where host in (select host from meausurement2);

We have included the in operator as part of the specification for Flux, but it is not implemented yet. You can follow this issue for when support will be added https://github.com/influxdata/platform/issues/256