flatten.sql

select
	*
from
    BIRD_DEMO.TO_TABLE.GET_OBJECT_REFERENCES_TEMP
    , lateral flatten ( input => REFERENCE)