v2.0-rc1

• Breaking Changes

  • Function $IMPORT_UNSAFE has been renamed to $IMPORT_SAFE
  • Renamed functions CURTIME, CURDATE, and CUREPOCH to CURRENT_TIME, CURRENT_DATE, and CURRENT_EPOCH respectively.
  • Recommended to change db-inconsistent CONCAT functions to CONCAT_NN for null-ignoring concatenation.

• New database supports

  • MariaDB #28
  • H2 #33

• Features & Enhancements

  • Syntactic sugar for upsert and insertOrLoad queries #18
  • Simulate FULL OUTER JOIN in unsupported databases #24
  • Ability to recompile a script without having to restart JVM #29
  • Provide loading scripts from multiple directories #36
  • Convert given list of values to a table #34
  • Provide syntactic sugar to create temp tables on the fly with selected data from another table #25
  • Application level pagination for SELECT queries #46
  • Application level transaction handling #47
  • Raw query parts can be written with parameters #49
  • Query level logging enhancements #35
  • Insert syntax supports for SET {} instead of DATA([]) clause
  • Ability to specify length when casting #41
  • Support statistical functions #21
  • Simulate java's lastIndexOf functionality in SQL queries #20
  • Dev mode new script addition should be able to detect automatically #10
  • Change the model to support execution of multiple parsed queries at once in executor #19
  • Database version aware translators #27

• Bug fixes

  • Inconsistency behavior of CONCAT functions in difference databases #30
  • Should not have alias when already aliased column is used inside a CASE statement #31
  • PARAM() is missing when it is inside LCASE() #38
  • PARAM() is missing when it is inside a THEN clause #39
  • Cannot use $IMPORT_UNSAFE outside queries #37