Hello Mihai, Thank you for your quick response! I tried redirecting the _pg_expandarray operator to UNNEST WITH ORDINALITY, but it didn’t work—particularly when used with the dot operator.
Here’s what I attempted: - Creating a custom parsing rule: didn’t work because Calcite’s default parser handles it first - Manually rewriting the query to replace _pg_expandarray with UNNEST - Implementing a custom SqlUserDefinedTableFunction _pg_expandarray whose implementation is UNNEST At the moment, I can’t think of any other solutions. Best regards, Maxime >
