Skip to content

Snowflake quoting error #2476

@symbill

Description

@symbill

Describe the bug
Given a Snowflake input to astify such as:

SELECT COUNT(*) FROM customers

And then using the sqlify to get back the query, customers table gets incorrectly quoted as in:

SELECT COUNT(*) FROM "customers"

This is a problem since snowflake interprets double-quoted identifiers as case-sensitive (but insensitive if unquoted), changing the meaning of the SQL query.

Database Engine
Snowflake

To Reproduce

const query = "SELECT COUNT(*) FROM customers"
const parserOpts = {database:'snowflake'};
const parser = new SqlParse.Parser();
const ast = parser.astify(query, parserOpts);

console.log(parser.sqlify(ast, parserOpts));
-the node-sql-parser: 5.3.10
-the node version: v20.19.1

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions