Hi community, I am thinking of adding the following support in Calcite to support named row construction, e.g.
SELECT (a as first_name, b as last_name, (c as zip code, d as street, e as state) as address) as record FROM example_table The output will be struct with field names specified in the SQL. The usage scenario is that say, in streaming SQL, the downstream sink's schema can not be changed, so we will need to use SQL to construct a struct with the proper naming according to the schema in order to write to the downstream sinks. Thanks a lot. Shuyi -- "So you have to trust that the dots will somehow connect in your future."
