JSQLParser/JSqlParser jsqlparser-4.5

on GitHub

• UnsupportedStatement support instead of throwing Exceptions
• support for RETURNING clause of a DELETE statement
• Add support for ... ALTER COLUMN ... DROP DEFAULT
• INSERT supports SetOperations (e. g. INSERT INTO ... SELECT ... FROM ... UNION SELECT ... FROM ...), those SetOperations are used both for SELECT and VALUES clauses (API change) in order to simplify the Grammar
• (WITH ... SELECT ...) statements within brackets are now supported
• Postgres NATURAL { INNER | LEFT | RIGHT } JOIN support
• 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) where field is 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 DEFAULT by @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

  New Contributors

  • @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

  Full Changelog: jsqlparser-4.4...jsqlparser-4.5