Hey All, New to Calcite, trying to express a select statement in SQL where i build a map. The thing is i want to conditionally add items to it, so for example have key 'c' with value from column 'c' only if the value is not null
SELECT a,b, map['c',c, 'd', d] as my_map FROM... Is there a way to conditionally have key/values in the map? Thanks! Shahar