Obtain parameters in a URL by using a URL function

Use the url_extract_parameter function to extract the value of the k0 parameter from a URL.

* |
select
  url_extract_parameter('/path9?k0=v9&k1=v8&', 'k0') as k0