sqlpage.url_encode()

sqlpage.url_encode(text TEXT) -> TEXT

SET search = :user_search;
SET url = 'https://example.com/search?q=' || sqlpage.url_encode($search);

SELECT 'text' as component,
    '<a href="' || $url || '">Search Results</a>' as html;

SELECT 'list' as component;
SELECT 
    title,
    'article.sql?title=' || sqlpage.url_encode(title) as link
FROM articles;