CREATE TABLE IF NOT EXISTS people (
    id            INTEGER PRIMARY KEY,
    name          TEXT,
    phone         TEXT,
    email         TEXT
);

INSERT INTO people (name, phone, email)
SELECT :Name, :Phone, :Email  
WHERE :Name IS NOT NULL AND $edit IS NULL;

UPDATE people 
SET name = :Name, phone = :Phone, email = :Email 
WHERE id = $edit AND :Name IS NOT NULL;

DELETE FROM people WHERE id = $delete;

SELECT 'table' AS component,
    'Edit' AS markdown, 'Remove' AS markdown, TRUE AS sort, TRUE AS search;
SELECT  
    id     AS ID, 
    name   AS Name, 
    phone  AS Phone, 
    email  AS Email,
    '[Edit](?edit=' || id || ')' AS Edit,
    '[🗑️](?delete=' || id || ')' AS Remove
FROM people;

SELECT 'button' as component, 'center' as justify;
SELECT '?add=1' as link, 'Add New' as title;

SELECT 'form' AS component;
SELECT (SELECT name FROM people WHERE id = $edit)  AS value, 'Name'  AS name;
SELECT (SELECT phone FROM people WHERE id = $edit) AS value, 'Phone' AS name;
SELECT (SELECT email FROM people WHERE id = $edit) AS value, 'Email' AS name;