Alan Cai

@slim-patchy I saw your [post](https://community.partiql.org/t/contributing-to-a-python-implementation-of-partiql/90) on the PartiQL community page. Feel free to followup with any questions you may have there.

Marking as a medium-sized task since it's not part of the SQL standard and may need some initial spec work.

Hi @mustafaakin, Sorry for the delay. The primary steps for implementing `ORDER BY` in the evaluator would involve: 1. Implementing and testing the `ORDER BY` semantics on values specified in...

To followup on the caveats, >We are in the process of deprecating ExprNode in the evaluator (PR https://github.com/partiql/partiql-lang-kotlin/pull/528) in favor of the PIG-generated PartiqlAst. That work should be merged to...

@onurkuruu Thanks for the contribution! We'll start taking a look. It may be easier for us to provide feedback through a PR. If you don't mind, could you create a...

Hi @mustafaakin, Could you elaborate what you mean by comparing "complex data structures without expanding them"? Also in your above query, couldn't you use the path expression in the `WHERE`...

Also: https://github.com/partiql/partiql-lang-kotlin/blob/e2b007ad2093e662c751c9a54ce35431a2eb6adf/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L2080-L2094 and https://github.com/partiql/partiql-lang-kotlin/blob/e2b007ad2093e662c751c9a54ce35431a2eb6adf/lang/test/org/partiql/lang/syntax/SqlParserTest.kt#L2488-L2507

#517 should upgrade the Kotlin version to 1.4, which will allow us to use the explicit API mode. We still need to investigate if our customers are ready to upgrade...

Thanks for bringing this up. Some of the DML `ParseNode`s are missing the associated tokens (e.g. '[REMOVE](https://github.com/partiql/partiql-lang-kotlin/blob/c6e3fc651b/lang/src/org/partiql/lang/syntax/SqlParser.kt#L1506)'), which leads to the "null" in the error message. I also found some...

By the way, for the first example you had using `INSERT INTO`, I'm not getting the `IllegalStateException` that you experienced. I'm getting a parser exception like the other 3 cases:...