Skip to content

sqlify() generates incorrect identifier quotes for Athena #2367

Closed
@axtavt

Description

@axtavt

Describe the bug
sqlify() generates SQL with backticks as identifier quotes whereas Athena requires double quotes.

Database Engine
Athena

To Reproduce

import { Parser } from 'node-sql-parser/build/athena';

const ast = parser.astify("select * from foo")
const sql = parser.sqlify(ast) // returns 'select * from `foo`'

Expected behavior
Double quotes should be used for identifier: select * from "foo"

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions