bigquery javascript UDF to extract URL components and query parameters with URI.js

bq.sql

-- gsutil mb -p project-id gs://my-udf-bukkit/
-- wget https://cdn.jsdelivr.net/uri.js/1.18.10/URI.min.js
-- gsutil cp URI.min.js gs://my-udf-bukkit/
-- open https://medialize.github.io/URI.js/docs.html

CREATE TEMP FUNCTION myFunc(b STRING)
  RETURNS STRING
  LANGUAGE js AS
"""
    return URI(b).query(true)['my-param'];
"""
OPTIONS (
  library="gs://my-bigquery-udfs/URI.min.js"
);

SELECT myFunc('http://www.example.com/my-path.txt?my-param=a%20b%21c');