manticore-projects

Can be parsed as `UnsupportedStatement` as shown in #1945 (unless you want to provide or sponsor a specific implementation).

Greetings! Thanks for reporting, I will look into it.

[This is the current implementation](https://jsqlparser.github.io/JSqlParser/syntax.html#jsonaggregatefunction).

At least in Oracle, this seem to have changed only recently: https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/JSON_OBJECTAGG.html

Definitely unsupported.

Greetings, your particular Index clause is unsupported. Please check the supported Syntax here: http://manticore-projects.com/jsqlformatter/JSQLFormatter/syntax.html#createindex [You can also test your statement online and interactively here.](http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20MIJQogggKmAEUQEIBk4AMDOBPDB9ArhgKYBOaAUABSzloCWAJmrAEZ0DmdAdgC6wByAeSgCAqsmQAaGmhIB7ADZFcjZm068xE6bS4BDALZFmANz0kAxgAtzsSgCYArI4CUWqTL3tjsbn37iHrQkRAbmANbMCnJc7DxEAB7+gTpo0RZ6Cqbm1rYOzm4B2p4MDCEYGNmWNiR2Tq7uOgAKIACSALIQIACasADSYL2U9ExuOqL8rQCKonDDqpJo+kZoi17GbqIAyq38AOKwiFDgcMCC7e1g-CIA5KJcdACO+ES+XAyJsHIAZr4M0ssiNJ1jcdABaMGwVrvT4WBR6QhEci7AAiYAAGn8EgBGWDbXYHYbpTJoNxHE6wM4XK63aEfBJfX7EhSgmgAMUE4Fae34-UGdlkimUqjc4DZYHA-GAYC2sEwOFw8iUzGGSuFoxobiAA)

Greetings. Those blocks exceed normal SQL Standard and can become very complex. See the example below. You will need to **provide** or **sponsor** an implementation to get those blocks supported....

Greetings. This syntax is far away from any SQL Standard (what RDBMS is this please?) You will need to provide or sponsor an implementation if you want to see it...

Please provide an SQL example of what exactly you will want to do.

Greetings All, apologies for showing up late. In my opinion The current implementation has 3 major shortcomings: 1) When traversing the AST from the root down to the leaves the...