🪲 List columns and functions

[joocer]

Customer has a query which they cannot share.

It generally follows this pattern:

SELECT
     CASE WHEN col IS NULL THEN [] ELSE col END as COL
FROM
     table

What appears to be happening is table spreads across multiple files, the first file has nulls for col later files do not. [] is being interpreted as one type but this isn't the type of the ARRAY column in the subsequent files.