Hello Everyone, I wanted to know how one can leverage existing dialects to add new functions or rename the occurrence of a specific function (or an operator).
For example, a query in Spark SQL - "SELECT EXPLODE(ARRAY['1', '2'])" will only work in Postgres if it is rewritten as "SELECT UNNEST(ARRAY['1', '2'])". If I need to emulate this kind of substitution how should I approach it? Another example that I was thinking of is, implementing functions that don't exist in the current dialect like ARRAY_AGG in Snowflake. How can I implement this in Calcite? Any suggestions would be much appreciated. Thank you for your time! :) With best regards, Soumydeep.
