Add a way to show non-tabular results from queries

Hello team,

As a follow up to the topic Show create table does not work in Redash @jesse advised me to create a feature request

I would like to be able to display non-tabular results like showing Athena DDL:

The query: SHOW CREATE TABLE db.table
The result in Athena:

CREATE EXTERNAL TABLE `db.table`(
  `col1` string, 
  `col2` date, 
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'
LOCATION
  's3://prefix/db/table'
TBLPROPERTIES (
  'classification'='parquet', 
  'spark.sql.create.version'='3.0.0-amzn-0', 
  'spark.sql.sources.schema.numParts'='1'
)