sqlpage--sqlpage/examples/user-authentication/logout.sql

DELETE FROM login_session WHERE id = sqlpage.cookie('session');
SELECT 'cookie' AS component, 'session' AS name, TRUE AS remove;

SELECT 'redirect' AS component, '/' AS location;