What is an outer apply? 🙃

it's a lateral join (??) that gives visibility to outer tables and to the result set in the where clause

select *
from foo
outer apply ( select count(*) c from other_table where other_table.id = foo.id) as v
--                                                                      ^^^ visible
where v.c > 3
      ^^^ visible

joinRaw