pgsql-ast-parser

Yet another simple Postgres SQL parser

Downloads
465.7K
Stars
300
Committers
21

Bot releases are hidden (Show)

pgsql-ast-parser - Support SKIP LOCKED and NOWAIT Latest Release

Published by oguimbal over 1 year ago

  • Support SKIP LOCKED and NOWAIT #129
pgsql-ast-parser - 8.0.0

Published by oguimbal about 3 years ago

Breaking changes

  • This release has one major breaking change:

INSERT [...] statements were parsed as an InsertStatment having a values property when parsing an insert ... values ..., or a select property when parsing an insert ... select ....

Given that the VALUES (...) is now handled as a statement (yes, it is a valid pgsql statement...Try it !), the INSERT statement is now parsed with a single insert property, wether it is an insert ... values or an insert ... select (see ast diff)

  • "default" keyword is now handled as an expression

Other changes

  • Handle "restart identity" on trucation thanks to @RafaelGSS (see his PR)
pgsql-ast-parser - Multiple statements in alter tables

Published by oguimbal about 3 years ago

Thanks to @bchelli via his PR #60 and @clemens-smartparking via this PR

🚨🚨🚨 BREAKING CHANGE 🚨🚨🚨

This is breaking the AST interface for the alter table statement

  • change becomes changes (with a "s") and is an array of table alterations (TableAlteration[])

This is a PR to address the following issues: