I encounter an issue when using dremio’s external_query functionality.
for example, if I run the following query
select * from table(pg.external_query('select 123 as "UPPER_CASE"'))
The result’s column name will be “upper_case”.
But if I run the following SQL in Dremio directly, (without using external_query)
select 123 as "UPPER_CASE"
the result’s column name will be correctly one: “UPPER_CASE”
Since the correct column name is very important, is this a bug for Dremio’s external_query?