manticore-projects

Greetings. Sorry to ask: why would people write queries like that and far away from any standard or convention?! My point is: `pro - ject` == `pro-ject` for the parser....

Greetings. Thank you for your report. It is not unexpected since JSQLParser has evolved a lot and now is able to parse very complex nested structures -- at a performance...

Btw, an alternative route was to lower the `Timeout` to maybe 200 ms while enabling complex parsing. It would try complex parsing first, then timeout and try simple parsing after....

yes of course: you wont be able to parse complex, nested expression. Examples are Sub-Selects, CAST/IN with sub-selects, functions with sub-selects as parameters.

Did my advise work for you? Can we close this issue?

Greetings. You will have to provide much more information please: 1) What RDBMS (I assume, you talk Apache Spark?) 2) A complete SQL statement illustrating your requested feature 3) Optionally:...

Greetings, The problem is about `SAFE_CAST(x AS y)`, which is not a regular function but a special expression. We will need to extend the `CAST()` expression accordingly.

> 1. `ARRAY_AGG(x LMIT 10)` > 2. `ARRAY_AGG( x IGNORE NULLS ORDER BY x)` > 3. `ARRAY_AGG( DISTINCT x)` > Google ARRAY_AGG references: https://cloud.google.com/bigquery/docs/reference/standard-sql/aggregate_functions#array_agg Certainly, because all of those are...

Greetings, MySQL [MEMBER OF Operator](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of) is not supported yet. Syntax is: [value MEMBER OF(json_array)](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of) Example: ```sql SELECT 17 MEMBER OF('[23, "abc", 17, "ab", 10]'); ``` OP's Sample is: ```sql SELECT...

> @manticore-projects cxr_post_id is `{"name": "主管", "scope": "1", "value": "106"}` But the query is wrong Thank you for the clarification. As I have stated, the MySQL specific `MEMBER OF` operator...