Andrew Lamb

Thank you for the report @nataliezeller1 Do you know of another system that supports this type of syntax?

Sounds like it would be a good improvement to add to the parser

I agree this would be a good addition to the crate

Note https://github.com/sqlparser-rs/sqlparser-rs/pull/907 adds support for mysql syntax -- it would likely be nice to support posgres syntax too

Converting to draft as CI is failing. Please mark as ready for review when it is

Thanks for the report @jesse-shopify -- any contributions to add such support are most welcome

Postgres does not seem to support this either: ```sql postgres=# select array [1,2,3][-1:1]; ERROR: syntax error at or near "[" LINE 1: select array [1,2,3][-1:1]; ^ postgres=# ```

```sql postgres=# select (array [1,2,3])[-1:1]; array ------- {1} (1 row) ``` 👍

> I would like to be able to parse the create sequence options in any particular order instead of just what postgreslq/duckdb support. Afaik oracle for example allows any permutation...

> My concern is that it would create false positives, and potentially allow bad code compilation, eg parsing bad postgresql code and then compiling that back in the wrong order....