Skip to content

jsqlparser-4.1

Compare
Choose a tag to compare
@wumpz wumpz released this 30 Jun 22:10
· 696 commits to master since this release
  • RESET statement
  • SET LOCAL|SESSION
  • support for nested WITH CTEs
  • support for with (cte) for delete, update and merge
  • introduce a max depth to allow parsing complex expression lists without performance loss (thx to @manticore-projects)
  • allow all functions to have complex expressions as parameters (thx to @manticore-projects)
  • API change FunctionWithCondParams production removed
  • API change in ValuesStatement: the expression list is now hold as a ItemList and not as a List
  • support for parser modification within parseExpression and parseCondExpression
  • support for table schema for foreign keys
  • support for Oracle hints on insert, update and merge
  • support for merge insert where clause
  • allow in as schema name
  • allow skip, algorithm as column name
  • support for functions in an interval expression
  • subArray support arr[1:3]
  • first support for tuples as simple expression SELECT myfunc((f1, f2))
  • support for array constructors array[[1, 2], [id1, id2]]
  • added support for NOT in MySqls REGEXP clause
  • added support for WITH mytble as ( .. ) INSERT INTO ...
  • added support for H2 casewhen function with conditional parameters