The URL keyword provides a convenient way of obtaining the resolved URL of a page
FROM https://example.com |> SELECT URL
If you’d like the returned value to be provided under a different alias simply use the AS keyword like so:
FROM https://example.com |> SELECT URL AS resolved_url