This question was originally asked on Hacker News, and to provide this information to the PartiQL community, I am duplicating it here, lightly edited.
I wonder how this deals with nested parquet data, and whether it’s able to optimise on the things parquet provides.
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/examples/src/java/org/partiql/examples/CSVJavaExample.java#L36.. Integrating with Parquet would of course be more complex then that.
AWS Redshift Spectrum supports PartiQL on parquet since last year. Except that the language had not had a name yet and was referred to as “SQL extensions for nested data.”