jsqlparser-4.5
- UnsupportedStatement support instead of throwing Exceptions
- support for RETURNING clause of a DELETE statement
- Add support for ... ALTER COLUMN ... DROP DEFAULT
- INSERTsupports- SetOperations(e. g.- INSERT INTO ... SELECT ... FROM ... UNION SELECT ... FROM ...), those- SetOperationsare used both for- SELECTand- VALUESclauses (API change) in order to simplify the Grammar
- (WITH ... SELECT ...)statements within brackets are now supported
- Postgres NATURAL { INNER | LEFT | RIGHT } JOINsupport
- extended support for Hive dialect GROUPING SETS
- support for Postgresql drop function
- support table option character set and index options
- support Postgresql optional TABLE in TRUNCATE
- support for ANALYZE mytable
- PostgreSQL INSERT INTO ... ON CONFLICT ... DO ...statements
- implement Parser Timeout Feature, e. g. CCJSqlParserUtil.parse(sqlStr, parser -> parser.withTimeOut(60000));
- extended support Postgres' Extract( field FROM source)wherefieldis a String instead of a Keyword
- support for DROP column IF EXISTS
What's Changed
Changes and new Features
- Performance Improvements by @manticore-projects in #1439
- Update bug_report.md by @manticore-projects in #1512
- Unsupported statement by @manticore-projects in #1519
- fixs #1520 by @chiangcho in #1521
- #1527 DELETE ... RETURNING ... by @manticore-projects in #1528
- Add support for ... ALTER COLUMN ... DROP DEFAULTby @manticore-projects in #1532
- #1516 rename without column keyword by @manticore-projects in #1533
- INSERT with SetOperations by @manticore-projects in #1531
- Allow isolation keywords as column name and aliases by @tomershay in #1534
- compound statement tests by @rathboma in #1545
- Postgres NATURAL LEFT/RIGHT joins by @manticore-projects in #1560
- Add support for Hive dialect GROUPING SETS. by @qzchenwl in #1539
- add support for postgres drop function statement by @rrrship in #1557
- Add test for LikeExpression.setEscape and LikeExpression.getStringExpression by @lacinoire in #1568
- Support table option character set and index options by @luoffei in #1586
- Closes #1583:: Implement Postgresql optional TABLE in TRUNCATE by @d2a-raudenaerde in #1585
- Closes #1579. Added ANALYZE support. by @d2a-raudenaerde in #1587
- Extended support Postgres' Extract( field FROM source) by @manticore-projects in #1591
- Configurable Parser Timeout via Feature by @manticore-projects in #1592
- PostgreSQL INSERT ... ON CONFLICT Issue #1551 by @manticore-projects in #1552
- add support for drop column if exists by @rrrship in #1594
- @rathboma made their first contribution in #1545
- @qzchenwl made their first contribution in #1539
- @rrrship made their first contribution in #1557
- @lacinoire made their first contribution in #1568
- @luoffei made their first contribution in #1586
- @d2a-raudenaerde made their first contribution in #1585
New Contributors
Full Changelog: jsqlparser-4.4...jsqlparser-4.5