LISTAGG is not directly supported. The equivalent is to use
STRINGAGG(last_name, ';') ORDER BY hire_date, last_name
Pushdown support for STRINGAGG is currently limited. If needed an
enhancement can be logged to be mapped to LISTAGG.
Just to double check, the engine support would still be for stringagg and the JIRA would cover mapping that to LISTAGG for oracle pushdown correct?
The ideal scenario would be to support the Oracle LISTAGG syntax in the Teiid connector. However, if that's not possible at this time, we can go with pushdown of stringagg. This will require us to dynamically modify an oracle query to convert the listagg to stringagg before we deploy to Teiid.