No working a query on v2 Dune SQL

[mingji]

I have an issue for the following v2 dune sql.
Given correlated subquery is not supported
if I remove "where" statement, then no error.
But it's worked before for the deprecated queries.

select
            h.day
            ,(select evt_tx_hash from all_events where evt_block_time <=  h.day limit 1) as hash
from 
            unnest(SEQUENCE(timestamp '2022-05-20 00:00', CURRENT_DATE, interval '1' day) )  AS h(day)