pgsql-ast-parser
pgsql-ast-parser copied to clipboard
oguimbal
Yet another simple Postgres SQL parser
Fixes: https://github.com/oguimbal/pgsql-ast-parser/issues/109
Our team has started adopting this library for client-side query validation. We noticed that in Safari browser using this library causes our React application to crash before it has a...
This library looks fantastic - looking at using it in a Deno project I'm currently working on. One of my first queries failed though - simplified version is: `SELECT nspname...
I noticed that if you pass an `ParseOptions` argument with an `entry` to `parse()`, it will return a single AST node, not an array of them: ```ts // always return...
For me (and for your CI :) ) the `npm run test` task does not execute the tests in `src/*.spec.ts` (files directly in the `src` folder), only those in its...
A query like `SELECT 5 as "foo ""bar"" baz"` works in `psql` and interprets the inner `""` as one double-quote character, escaped: ``` foo "bar" baz --------------- 5 (1 row)...
Parsing: ```sql ALTER TABLE foo DROP bar CASCADE; ``` Fails with: ```js Error: Syntax error at line 1 col 26: ALTER TABLE foo DROP bar CASCADE ^ Unexpected word token:...
Parsing: ```sql ALTER INDEX foo_idx RENAME TO bar_idx; ``` Fails with: ```js Error: Syntax error at line 1 col 13: ALTER INDEX foo_idx ^ Unexpected word token: "foo_idx". I did...
Parsing: ```sql DROP TRIGGER bar on foo; ``` Fails with: ```js Error: Syntax error at line 1 col 14: DROP TRIGGER bar ^ Unexpected word token: "bar". I did not...
Parsing: ```sql ALTER TABLE foo ADD bar_id BIGINT NOT NULL UNIQUE REFERENCES bar; ``` Fails with: ```js Error: Syntax error at line 1 col 65: ALTER TABLE foo ADD bar_id...