manticore-projects

> See http://www.sphinx-doc.org/en/stable/theming.html#distribute-your-theme-as-a-python-package for the details on that. Apologies for asking, but this site does not seem to exist. https://www.sphinx-doc.org/en/master/development/theming.html?highlight=distribute#distribute-your-theme-as-a-python-package seems to work.

Greetings. Unfortunately you do not provide a Sample SQL statement. I think, the challenge is not about `JSONB_ARRAY_ELEMENTS()` but rather about `WITH ORDINALITY ARR()` which is not supported by JSQLParser...

If I understand it correctly, it is about unnesting of functions, which produce many result rows: _"When a function in the FROM clause is suffixed by WITH ORDINALITY, a bigint...

Thanks for the clarification. As suspected it is about the `WITH ORDINALITY`, you can [try it online here.](http://jsqlformatter.manticore-projects.com/jsqlformatter/demo.html?args=-c%20MoUQMiDCAqAEsEEBKSB0BJaICyBaAfPgOQBmAhgK4A2ALsAJ4DONApgLbT0AOLRiwsctRqMmrNjW4sAUPDlyANIhQYseQqUq0GzdpAD2AE179BWkWPYBjIzIBiSAPLZYAOxY0A+kNqeAlq4k+rKKsABSwI4AcgBCnshICACanuA4IFHQwAAU2AjoUZ52CACqYNCeBXaOAJTSAPQAVADqmAASsI5IACIFCGCYScpI2dKYOArSAAqOwNI1jfXSzW0gSCCwfoawALywAFxcANbohtIA3EA+) It's not supported yet and seems to come in two flavors: Standard...

Solved by PR #1382 (which properly allows token for certain use.)

Just for clarification, any UPDATE of an ARRAY fails even with a simple index: ```sql -- SELECT works SELECT listes[(SELECT cardinality(listes))] FROM dual ; -- UPDATE fails update utilisateur set...

This PR is quite old and seems to be abandoned although I spotted some very good additions about MS SQL specific Statements and Server Hints. Is there anyone taking responsibility...

Simply not supported and far away from any SQL standard compliance.

> Do you mean it will never be implemented because it is considered far from SQL Standard ? > If somebody was interested in extending SQLParser, it shoud be possible...

> @abourakba Is this something like SqlServer hints (**with (index)** )? From what I read, its a syntax for a CTE with/ or without data insertion. Standard Compliant rewrite was...