partiql-lang-kotlin

I think that talking about Ion, without talking about PartiQL, is not setting people up with proper context. PartiQL is AWS's specification for a parser/query language that is compatible with standard SQL, but can query semi-structured or unstructured data (think JSON, Parquet, CSV/TSV etc) https://aws.amazon.com/blogs/opensource/announcing-partiql-o... PartiQL uses Ion as it's backbone and data format: https://partiql.org/faqs.html#why-do-you-choose-ion-to-exten... https://github.com/partiql/partiql-lang-kotlin/blob/master/e... I looked pretty deeply into this, but failed a bit short of understanding what they meant when "if your query engine supports PartiQL." Does that mean writing a new DB that delegates incoming queries to PartiQL? Not sure. Anyways, they use it in Quantum Ledger DB, and a few other internal projects: https://docs.aw

ORDER BY is still in the works: https://github.com/partiql/partiql-lang-kotlin/issues/47

It would be possible to integrate parquet data with PartiQL. Here is an example of integrating PartiQL with CSV files. https://github.com/partiql/partiql-lang-kotlin/blob/master/e.... Integrating with Parquet would of course be more complex then that.