alibaba / alibaba/nquery

Trying to run a basic query and its not working

Open
#15 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
385
Forks
117
PR merge metrics
No merged PRs in 30d

Description

`SELECT MONTH(endTime) FROM table`

results in:

```
/Users/maltepeter/Documents/repos/node-query-api/node_modules/node-sql-parser/pegjs-parser.js:9800
throw peg$buildException(
^
SyntaxError: Expected [A-Za-z0-9_] but end of input found.

Is there a way to get it to support this functionality?

Contributor guide

No contributing guide indexed for this repository

Research direction

Reproduce `SELECT MONTH(endTime) FROM table` through the SQL parser and inspect the reported `node_modules/node-sql-parser/pegjs-parser.js` failure near the indicated parser entry point. Confirm how function expressions are parsed and add coverage for this query; done means the query parses without the shown SyntaxError.

Written by the indexing model from the issue text.

Assessment

Tech stack
javascript, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.