EXPLAIN query with TYPE IO should also return columns used.

[jan119]

When you run a explain query and set type to IO, it returns the input tables, but doesn't return the columns used per table.

Expected Behavior or Use Case

CREATE TABLE user (
    name VARCHAR,
    age INT
);

EXPLAIN (TYPE IO) SELECT name FROM user;

You get the following result:

           Query Plan
---------------------------------
 {
   "inputTableColumnInfos" : [ {
     "table" : {
       "catalog" : "hive",
       "schemaTable" : {
         "schema" : "test_schema",
         "table" : "user"
       }
     },
     "columnConstraints" : [ ]
   } ]
 }

The expected result:

           Query Plan
---------------------------------
 {
   "inputTableColumnInfos" : [ {
     "table" : {
       "catalog" : "hive",
       "schemaTable" : {
         "schema" : "test_schema",
         "table" : "user"
       }
     },
     "columnConstraints" : [ ],
     "columns" : [ {
       "columnName" : "name",
       "type" : "varchar",
       "domain" : {
          ...
       }
     } ]
   } ]
 }

Presto Component, Service, or Connector

query plan

Possible Implementation

I think the query plan already does this computation since the other formats expose the columns but hard to parse and varies for connectors.

Example Screenshots (if appropriate):

Context

We are proving audit logs for our customers to find which scientists in their group are querying for sensitive data which are stored at the column level. Based on the column names we would provide logs which then they'd need to submit for compliance.