SQL array flattening: Why doesn’t CROSS JOIN UNNEST join every nested value with every row? April 29, 2023 by Tarik