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.aws.amazon.com/qldb/latest/developerguide/ql-re...
So maybe that can give some more context around "what the hell is this, why does it exist, how would you use it?"