Hi,
I would need to put the results of dynamic SELECT queries into a single JSON.
Eg. if I have SELECT a, b, c FROM mytable, I want it to transform it to a single payload {"a": xxx, "b": xxx, "c": xxx}
As I don't know the query in advance, I can't create a Table to insert into.
I'm using the Table API (tableEnv.executeSql(selectQuery)).
Should I use the internal API as is done in the SQL gateway ?