Using LATERAL for pivoting table

I'm still playing with LATERAL, and having some great results for
simplifying what used to be complicated looking queries. I had a thought
about using them to pivot data in a table, and what I'm doing here seems to
work great, but it looks kind of funny to join the table on 1=1, because
"left outer join" requires something. Whenever I have to do something
strange like that, it usually means I'm doing it wrong. Should I be
writing it another way?


CIC is a table with part and facility, named ICPROD and ICFAC respectively:


select ICPROD, t1.ICFAC, t2.icfac
from (select distinct ICPROD from CIC) CIC
left outer join
lateral(select ICFAC from CIC b
where ICPROD=CIC.ICPROD
fetch first row only) t1
on 1=1
left outer join
lateral(select ICFAC from CIC b
where ICPROD=CIC.ICPROD
and ICFAC not in (t1.icfac)
fetch first row only) t2
on 1=1