Comment by slotrans

where exists (select 1...) is completely standard and normal.

We should write our code to be readable, but it is reasonable to expect that the reader knows the language.