A continuación se muestra el udf de sql que debe convertirse a udf de javascript con el mismo resultado tabular.

 CREATE OR REPLACE FUNCTION "TEST_UDF"() RETURNS TABLE ("TOTAL_CUSTOMERS" NUMBER(38,0), "COUNTRIES" NUMBER(38,0), "US_STATES" NUMBER(38,0), "CITIES" NUMBER(38,0), "MIN_AGE" VARCHAR(16777216), "MAX_AGE" VARCHAR(16777216), "WOMEN" NUMBER(38,0), "MEN" NUMBER(38,0), "OTHER" NUMBER(38,0)) LANGUAGE SQL AS $$ select COUNT(DISTINCT(HUX_ID)) AS TOTAL_CUSTOMERS, COUNT(DISTINCT(COUNTRY)) AS COUNTRIES, COUNT(DISTINCT(STATE)) AS US_STATES, COUNT(DISTINCT(CITY)) AS CITIES, MIN(AGE) AS MIN_AGE, MAX(AGE) AS MAX_AGE, ROUND(COUNT(CASE WHEN GENDER = 'F' THEN 1 END)* 100 / COUNT(GENDER),8) AS WOMEN, ROUND(COUNT(CASE WHEN GENDER = 'M' THEN 1 END)* 100 / COUNT(GENDER),8) AS MEN, ROUND(COUNT(CASE WHEN GENDER = 'U' THEN 1 END)* 100 / COUNT(GENDER),8) AS OTHER from DETAIL_CUSTOMER order by total_CUSTOMERS desc $$;