Using Parquet format with AWS Athena

[bean]

Hi there

Is there a way I can use the (hopefully) better performing parquet format when querying AWS Athena?

So far I have configured Athena such it produces parquet result sets instead of CSV.

Now I would like to querry from my load script using e.g.

UNLOAD (SELECT * FROM "sydt"."pdi_mv")
TO 's3://XXXXi-athena-20240YYY094842531700000001/parquet/'
WITH (format='PARQUET');

but the Qlik SQL does not allow using other statements than select.

Any ideas how to query Athena and retrieving results in the parquet format?

Thanks so much!