How do I prevent double quotes around date/timestamp values when downloading the API results as CSV?

[cyyeh]

Environment

• Version:

  cli version: 0.6.0
  core version: 0.6.0
  build version: 0.6.0
  serve version: 0.6.0
  

• OS: macOS

What's wrong?

There are double quotes in date related fields.

In plain text, this is what the CSV file looks like

col1,col2,col3,col4,col5
"TEMP","ANALYST","""2019-09-11 15:47:29.823 -0400""","""2022-08-15 05:24:06.726 -0400""",null

The values are stored as TIMESTAMP_TZ in Snowflake, and date values are stored as DATE. No transformation is done in how they are used within VulcanSQL

What's the correct behavior?

There should be no triple double-quotes around the date fields.

Note: this issue is raised by our user armaan in Discord.

Reproducing steps