> Also be aware that if one of the inputs to ARRAY_AGG is NULL, the entire output will be NULL and thus none of the non-NULL attribute values will be shown in t

> Also be aware that if one of the inputs to ARRAY_AGG is NULL, the entire output will be NULL and thus none of the non-NULL attribute values will be shown in the output! So extra logic is re-quired to avoid these cases. Good luck with that one! that's how null works in 3VL, use isnull or coalesce accordingly. > We present a backward compatible SQL extension (SELECT RESULTDB) to allow SQL SELECT statements to return a clearly defined subset of a database rather than just a single table. just use sql/json it's standardized and supported. you guys are way out of touch from modern sql. please go and read modern-sql.com