While this has been requested as part of other requests, I wanted to ask for this feature specifically. It would be a game-changer for me.

SELECT * FROM mytable
WHERE foreignKeyColumn in (SELECT _id FROM lookupTable)