When you are interested in not obtaining the concatenated text nodes but getting the readable text from a page, you can use our TEXT keyword.
FROM https://example.com |> SELECT TEXT
If you would like the alias to be something other than “TEXT” you can use the AS keyword like so:
FROM https://example.com |> SELECT TEXT AS example_text