sqlite-parser

sqlite-parser copied to clipboard

Confusion about parsing of "not" operator

1

Hi! In the following example I'd expect "not" to be a first-class member of the AST. But it appears to just be concatenated with the operator after it. This would...

eatonphil

You can reproduce it in your demo: http://codeschool.github.io/sqlite-parser/demo/ The query `CREATE VIRTUAL TABLE txt1 USING fts4(tokenize=unicode61);` is parsed well. The same but with tokenizer arguments e.g. `CREATE VIRTUAL TABLE txt2...

lana-k

The following query is failing to validate. `SELECT x, y, row_number() OVER (ORDER BY y) AS row_number FROM t0 ORDER BY x;` See [sqllite window function](https://www.sqlite.org/windowfunctions.html) official documentation.

vmasalov

Do you have the AST definition document?

1

I'm learning this project and I want a document about how AST defined just like [https://esprima.readthedocs.io/en/latest/syntax-tree-format.html](https://esprima.readthedocs.io/en/latest/syntax-tree-format.html)

lunexnocty

Is it possible to use this lib to split a multiple-part statement into an array of statements. example: sqliteParser(` INSERT INTO storage WHERE id=1; INSERT INTO storage WHERE id=2; `)

joue-quroi

with no dereq this package cannot be included as a library in other browserify-processed packages

pkit

In this example there are two named constaints: ```sql CREATE TABLE Bees ( wings integer PRIMARY KEY CONSTRAINT has_enough_wings CHECK (wings >= 2), legs integer CONSTRAINT too_many_legs CHECK (legs

lingo

Feature Request: Add location data to AST

1

Adding location data to nodes in the AST would allow for 'possibly' new languages to be built using the AST as a target (stage 2 of my master plan, think...

jdrew1303

Incorrect AST when using "LIKE" expression

2

When parsing a query like: ``` SELECT * FROM Bees b WHERE wings LIKE '1' AND limbs = 'blah' ``` The AST generated is incorrect. ``` { "type": "statement", "variant":...

malolans-r7

Create index.d.ts

4

Declaration file for use sqlite-parser from Typescript code https://basarat.gitbooks.io/typescript/docs/types/ambient/d.ts.html

euginio