DuckDB url_encode

create_url_encode.sql

CREATE OR REPLACE MACRO url_encode(input_string) AS (
    replace(
        replace(
            replace(
                replace(
                    replace(
                        replace(
                            replace(
                                replace(
                                    replace(
                                        replace(
                                            replace(
                                                replace(
                                                    replace(
                                                        replace(
                                                            input_string,
                                                            ' ', '%20'
                                                        ),
                                                        '!', '%21'
                                                    ),
                                                    '"', '%22'
                                                ),
                                                '#', '%23'
                                            ),
                                            '$', '%24'
                                        ),
                                        '%', '%25'
                                    ),
                                    '&', '%26'
                                ),
                                '''', '%27' -- Corrected single-quote encoding
                            ),
                            '(', '%28'
                        ),
                        ')', '%29'
                    ),
                    '*', '%2A'
                ),
                '+', '%2B'
            ),
            ',', '%2C'
        ),
        '/', '%2F'
    )
);