WIP

[webmention-receiver] / src / db / postgres / sql / channel-insert.sql

-- 
WITH new_id AS (
        SELECT uuid_generate_v1() AS id
)
INSERT INTO channel (account_id, channel_id, name, uid) VALUES (
        $(accountId),
        (SELECT id FROM new_id),
        $(name),
        COALESCE($(uid), (SELECT id FROM new_id)::text)
)
RETURNING *