The following significant changes were made to the Invantive UniversalSQL grammar: - Release 17.29 (BETA) adds: - 20181031: allow named expressions as table function parameters, using => as association operator. - 20181123: add WHEN EXCEPTION to PSQL BEGIN..END block, with exception being WHEN OTHER or WHEN exception name. - 20181123: extend SYNCHRONIZE statement. - 20181224: extend SYNCHRONZIE statement with IGNORE NULLS clause. - Release 17.30 (Production): All changes sofar. - Release 17.31 (BETA) adds: - 20190116: addition of language code parameter to TRANSLATE_RESOURCE. - 20190117: addition of IS_NUMBER function. - 20190124: addition of TO_BOOLEAN, IS_BOOLEAN, IS_DATE, IS_GUID functions. - Release 17.32 (Production): All changes sofar. - Release 17.33 (BETA) adds: - 20190131: texts as partition names . - 20190310: expression as billing id and reference. - 20190322: select all columns 'except' syntax. - 20190401: months_between SQL function. - 20190401: excel_day SQL function. - 20190403: sqlrowcount, sqlerrm and sqlcode functions. - 20190410: 'exists' expression. - 20190601: 'when obsolete within' variant of 'alter persistent cache refresh'. - 20190605: gzip and ungzip functions. - 20190624: 'alter session set roles' syntax for connectors with row-level security. - 20190701: ascii_to_blob and unicode_to_blob functions. - 20190706: 'alter session set iuid source' syntax. - 20190821: add htmltable. - 20191007: add 'except' to synchronize statement for insert and update. - 20191008: add 'ignore changes to' to synchronize statement for update. - 20191209: multiple PSQL batches in one statement. - 20200102: add internettable. - Release 17.34 (Production): All changes sofar.