JSQLParser / JSqlParser Public

- Add the EMIT CHANGES syntax used in KSQL.

Since Postgre 8.4, RESTART in ALTER SEQUENCE can be set without value.

Co-authored-by: LeiJun <02280245@yto.net.cn>

* Fix issue in parsing TRY_CAST() function

* Fix issue in parsing TRY_CAST() function

* Add parser, deparser, validator and vistior implementation for try_cast function

* Update toString() method of TryCastExpression class

…ions (#1413)

Co-authored-by: EverSQL <tomer@eversql.com>

Co-authored-by: EverSQL <tomer@eversql.com>

…gs that are allowed in Snowflake SQL (#1409)

Co-authored-by: Richard Kooijman <richard.kooijman@inergy.nl>

* Issue #420 Like Expression with Escape Expression

Fixes issue #420

* CheckStyle compliance

* Add Delete / Update modifiers for MySQL #1254

* fix codacy issues + pr return

* simplify low_priority

Allow Complex Expressions as SelectItem

Fixes #1375

Co-authored-by: Tobias <t.warneke@gmx.net>

* IN() with Complex Expressions

Fixes #905
Allow Complex Expressions and multiple SubSelects for the IN() Expression

* Tune the Test Coverage

* Remove unused import

* Reset TEST status

Add another Alias() Keyword related LOOKAHEAD
Fix a Keyword Spelling Error in the Deparser
Remove UNPIVOT from the PARENTHESIS Deparser, as it was an ugly workaround made obsolete by PR #1380

* Issue1369

* Add test

* Fixes #1371

Postgres specific JSON_OBJECT syntax supporting:
SELECT json_object('{a, 1, b, 2}');
SELECT json_object('{{a, 1}, {b, 2}}');
SELECT json_object('{a, b}', '{1,2 }');

* Improve Test Coverage

Fixes #933

Fixes #1363

- Changed JSqlParserCC.jjt file to add the alias to the UnPivot lexical entity.
- Added Alias to the UnPivot object.
- Improved SelectDeParser to correctly deparse SubSelect's UnPivot component.

* Fixes #1352

Allow SYSTEM as table- or column- name

* Fixes #1352

Allow SYSTEM as tablename

* Fixes #1352

Allow SYSTEM as tablename and columnname

* Fixes #1352

Allow QUERY as tablename and columnname

* Fixes #1352

Allow FULLTEXT as tablename and columnname

Co-authored-by: Tobias <t.warneke@gmx.net>

* Enhance ALTER TABLE ... DROP CONSTRAINTS ...

Add support for DROP PRIMARY KEY, DROP UNIQUE(...)
Add support for DROP FOREIGN KEY(...)

Fixes #1342

* Remove one useless PMD rule
Add more tests
Adjust Test Coverage

* Fix a trivial MERGE error from Commit 4797a8d

* Function use AllColumns or AllTableColumns

Fixes #1346

* Remove one useless PMD rule

* Fix a trivial MERGE error from Commit 4797a8d

* Fixes #1333

Postgres compliant ALTER TABLE ... RENAME TO ...

* Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...

* Postgres compliant ALTER TABLE IF EXISTS ... RENAME TO ...