Let t = ibis.memtable({'col0': [-2, -5, -1, 0, 1, 8, 7], 'col1': [0, -2, 4, 5, 6, 8, 7]}).
I want to find all of the rows where col0 is any value in col1.

In SQL, I might do:

SELECT
  *
FROM
  t
WHERE
  col0 = ANY(SELECT col1 FROM t)

(or ANY_VALUE)

Is there a column expression or ibis method for ANY or ANY_VALUE? or a workaround?

I tried looking in the docs but did not come up with an answer.