Snowflake sqlify issue

[AvivVegh]

Using function sqlify for Snowflake
...
const sql = 'select NAME as "a\b" from schmea.table'
const ast = parser.astify(sql, { database: 'Snowflake' })
const parsedSql = parser.sqlify(sql, { database: 'Snowflake' })
console.log(parsedSql)

expected: select "NAME" as "a\b" from "schmea"."table"
actual: select "NAME" as `a\b` from "schmea"."table"

`a\b` is not valid in Snowflake

also in adding quotes you are losing the "Letter case"
the column/schema/table should be the exact name (with letter case) as it is in the warehouse.

can we do something with that ?

[taozhi8833998]

two issues here:

1. the alias is not identified by "
2. losing the "letter case" when sqlify back

[taozhi8833998]

@AvivVegh the first issue has been fixed. working on the second one now.

[taozhi8833998]

@AvivVegh for the second issue, can you give me some cases to make it more clearly?

[AvivVegh]

case sensitive example:

warehouse state:
table name: SRC_HOST
column name: name

const sql = 'select NAME from dev.src_host'

if Im running this query directly in the warehouse or in some db client
there is no case sensitive, but when the parser is adding quotes, we are losing this functionality

parser result:
select "NAME" from "dev"."src_host"

can we might add a flag to parser remove quotes ?

[taozhi8833998]

@AvivVegh OK, I got it, the second issue may be the same with #1607 , which I am working on. Since the first issue has been fixed, I will add future progress in #1607 for the second issue, and I close this issue.