BlockTrackerexternal function
    Updated 2023-09-26

    EXECUTE IMMEDIATE $$
    DECLARE
    i INTEGER;
    result STRING;
    BEGIN
    result := '';
    i := 1;
    WHILE (i < 10) DO
    result := result || i || ' , ';
    i := i + 1;
    END WHILE;
    result := LEFT(result, LENGTH(result) - 2); -- Remove the trailing comma and space
    RETURN result;
    END;
    $$;


    /*
    create or replace function js_hextoint (s string)
    returns double language JAVASCRIPT
    as
    'if (S !== null)
    {
    yourNumber = parseInt(S, 16);
    }
    return yourNumber';

    select js_hextoint(SUBSTR(md5('testsaltexample' || 123456789),-2,2));

    */

    -- WITH RECURSIVE dates AS (
    -- SELECT TO_DATE('2023-01-01') AS date
    -- UNION ALL
    -- SELECT date + 1
    Run a query to Download Data