How to use lookups in a WHERE expression?

Is there a way to use lookups result to filter an output?
For instance I'm using this query:
"SELECT DISTINCT device_id, LOOKUP(device_id, 'devices') as date_created FROM "my_table" WHERE LOOKUP(device_id, 'devices') != 1"
But this query causes runtime error
Is it working with expessions?

The report only identifies a SQL query using LOOKUP in a WHERE clause and says it produces a runtime error; no source file or test is named. Start by reproducing the query and capturing the full error, then trace the relevant Druid lookup and expression entry points. Done means the supported behavior is clarified or the failure is covered by a regression test.

Written by the indexing model from the issue text.