node-pg-query-native
node-pg-query-native copied to clipboard
zhm
PostgreSQL Query Parser for Node.js
Steps to repoduce: 1. Use a mac with an M1 chip 2. run `npm install` 3. run `npm test` 4. Get an error: ``` ➜ node-pg-query-native git:(master) ✗ npm t...
Hello, Facing issue in Windows, here is the error, can you please help me on this issue. Error: gyp ERR! stack Error: C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\MSBuild\Current\Bin\MSBuild.exe failed with exit...
Thanks for your work on this library! I needed some features that were missing — namely, access to the libpg_query parsing for Pl/PgSQL functions, and the ability to do parsing...
the version of pg_query is old and cannot parse quite a few statements now that are valid. I'm happy to help and make a PR, are can somebody provide some...
`console.log(JSON.stringify(parser.parse('SELECT (x.cv).void,(x.cv).vonum,c.cegkod FROM x_function(12,56,hstore(\'alma\',5)) x (cv::voucher) JOIN ceg c ON c.cegkod=(x.cv).invpartnerid').query));` return: `[]` but if a function has a known return type then returns the expected value `console.log(JSON.stringify(parser.parse('SELECT (x.cv).void,(x.cv).vonum,c.cegkod FROM...
This is the query: ``` CREATE SEQUENCE public.user_permissions_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; ``` This was generated from pg_dump, so there...
This will throw error: ```sql select row_number() over( partition by id order by create_time ) row from sometable ``` as ```json { "error": { "fileName": "scan.l", "lineNumber": 1116, "cursorPosition": 89,...
This will be nice if above can be added as well. Thanks in advance!
Hi, this library is great but looking at the date, it has been awhile since the last update. Can we add a script to pull and compile from https://github.com/lfittl/libpg_query and...