Is it possible to dynamically build and execute query using Trino's SQL features

[gurustron]

In the nutshell - is it possible to programmatically build a query and execute it in Trino without using outside scripting. Something along these lines:

exec (
SELECT 'select ' || array_join(array_agg(column_name), ', ') || ' from jmx.current."trino.memory:name=clustermemorymanager"'
FROM jmx.information_schema.columns
WHERE table_name = 'trino.memory:name=clustermemorymanager'
    and table_schema = 'current'
    and column_name like '%cluster%'
GROUP BY true;
)

Which would be equivalent of:

EXECUTE IMMEDIATE 'select clustermemorybytes, clustertotalmemoryreservation, clusterusermemoryreservation from jmx.current."trino.memory:name=clustermemorymanager"';

where the string was build dynamically.

[findepi]

currently there is no such functionality and i am not aware of any plans to build one