Comments (10)
anyone interested in upgrading to 12 please thumbs up the conversation here pganalyze/libpg_query#67. ;)
my attempts at upgrading to 12
pyramation/node-pg-query-native@e9e2d03
from pgsql-parser.
Thank you! Appreciate the kind words :)
We're currently dependent on https://github.com/lfittl/libpg_query to upgrade to 12. Lucky for us, it's in the works here https://github.com/lfittl/libpg_query/tree/12-latest-develop
The only problem is that I did try it out, while I got it to somewhat "work" locally, it didn't work with npm install because the build tests fail (the C/C++ ones) causing the npm install process to fail.
I will keep this issue up to date for when we do get a 12 version, and if I can hack something together, a 12 branch that could potentially work even if I get it to only work experimentally.
from pgsql-parser.
were there specific commands you wanted to parse by chance @Impavidity ? Like generated columns? it is potentially possible that we simply update the deparser, and hack the tests to ignore the fact that the parser cannot parse them, and we can get ahead on a few features for when 12/13 comes
from pgsql-parser.
I am going to use the RANGE + interval (RANGE BETWEEN '10 days' PRECEDING AND CURRENT ROW).
from pgsql-parser.
Thanks @Impavidity can you provide a full, complete query/statement example I can use for testing?
from pgsql-parser.
sure. Here is one example
WITH timestamp_measurement AS (SELECT count(t1.id) AS count_num
, date_trunc('month', t1.start_date) AS timestamp
FROM trip AS t1
GROUP BY timestamp)
SELECT t2.timestamp AS timestamp
, avg(t2.count_num) OVER (ORDER BY t2.timestamp ASC RANGE BETWEEN '3 months' PRECEDING AND CURRENT ROW) AS moving_count_num
FROM timestamp_measurement AS t2
from pgsql-parser.
Hi @pyramation - so happy somebody is keeping this project moving forward. Regarding versions, given the dependence on libpg_query, would it be possible to support various versions of postgresql?
from pgsql-parser.
@ReinsBrain thank you! Very passionate about ASTs and Postgres, it's the least I can do :)
yes! we're working to support PG 12/13 when this merges: pganalyze/libpg_query#87
from pgsql-parser.
latest work for parser for PG 13 https://github.com/pyramation/node-pg-query-native/tree/13-latest-develop
from pgsql-parser.
Just released the PG 13 port! Please test it out and let me know if you find anything. There are a few differences between the old and new parser, which are due to the major change, and also the libpg_query changes.
Likely there are a few test cases still needed, I'm happy to add them as we add specific issues for each one. Currently I've implemented generated columns in the deparser as well as index include fields.
from pgsql-parser.
Related Issues (20)
- PRs from postgres-ast-deparser for reference
- Use in client side HOT 1
- supabase artifact not found HOT 6
- Queries with CTEs (WITH clause) that have column aliases cause syntax error HOT 6
- Question: why not async? HOT 2
- New release of pgsql-parser for macOS SDK Issue HOT 3
- PG 14 upgrade HOT 5
- PG 15 upgrade HOT 7
- Error installing the package on Windows 10 HOT 1
- CREATE INDEX with expression missing extra parenthesis
- transformArrays slow for large queries HOT 2
- Error: List is not implemented: HOT 2
- Bug - Column names with a only capital letters are not surrounded by quotes on deparse.
- Reliably identify table names?
- new node 20 version for pre-builds HOT 1
- logo
- PG 16 upgrade HOT 4
- Segmentation fault
- Incorrect parsing of quotes in create aggregate
- deparser bug: Incorrect string escaping
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgsql-parser.