Deliver database query results to a web UI, 1 line

SELECT 'list' AS component, 'Items:' AS title; SELECT column AS title FROM table;

Display database query results as a chart, 1 line

SELECT 'chart' AS component, 'Pets' AS title; SELECT pet AS label, val AS value FROM pets;

Deliver markdown code in a list component, 1 line

SELECT 'list' AS component, 'Blog' AS title; SELECT t AS title, d AS description, m AS description_md FROM blog;

Layout page and menu items, 1 line

SELECT 'shell' AS component, 'Home' AS title, ' ' AS footer, '{"title":"Go","submenu":[{"icon":"car","link":"m.htm"},{"title":"X"}]}' AS menu_item;

Markdown editor, 3 lines

SELECT 'text' AS component, 'Markdown' AS title, 'Enter code:' AS contents;
SELECT 'form' AS component; SELECT 'Code' AS name, 'textarea' AS type, :Code  AS value;
SELECT 'text' AS component, 'Output:' AS title, :Code AS contents_md;

Complete database application with interactive UI, 4 lines

CREATE TABLE IF NOT EXISTS things (items TEXT NOT NULL);
INSERT INTO things(items) SELECT :Item WHERE :Item IS NOT NULL;
SELECT 'form' AS component, 'Add item:' AS title; SELECT 'Item' AS name;
SELECT 'list' AS component, 'Items:' AS title; SELECT items AS title FROM things;

Full CRUD app with sortable data table UI, 8 lines

CREATE TABLE IF NOT EXISTS t (i INTEGER PRIMARY KEY, a TEXT);
INSERT INTO t (a) SELECT :A WHERE $e IS NULL AND :A IS NOT NULL;
UPDATE t SET a = :A WHERE i = $e AND :A IS NOT NULL;
DELETE FROM t WHERE i = $d;
SELECT "button" AS component; SELECT "?" AS link, "New" AS title;
SELECT "form" AS component; SELECT (SELECT a FROM t WHERE i = $e) AS value, "A" AS name;
SELECT "table" AS component, "" AS markdown, "X" AS markdown, TRUE AS sort;
  SELECT a AS A, i AS I, "[edit](?e="||i||")" AS "", "[x](?d="||i||")" AS X FROM t;

Integrate a 3rd party web API endpoint, 1 line

SELECT "code" AS component; sqlpage.fetch("https://tinyurl.com/y2mhwbtp") AS contents;

Integrate a 3rd party map search API with a map component, 4 lines

SELECT 'form' AS component; SELECT 'Location' AS name;
SET l=COALESCE(:Location, '');
SET x=sqlpage.fetch('https://tinyurl.com/3crabx94?format=json&q='||sqlpage.url_encode($l));
SELECT 'map' AS component; SELECT $x->>0->>'lat' AS latitude, $x->>0->>'lon' AS longitude;

Deliver database query results to a web API endpoint, 1 line

SELECT'json'AS component,JSON_OBJECT('messages',(SELECT JSON_GROUP_ARRAY(JSON_OBJECT('author',author,'message',message))FROM messages))AS contents;

Integrate Python code, 3 lines (+1 line Python)

SELECT 'form' AS component; SELECT 'Text' AS name, 'textarea' AS type, :Text AS value;
SET w=COALESCE(:Text, '');
SELECT 'text' AS component, 'Count: '||sqlpage.exec('python3', 'count.py', $w) AS contents;

CREATE TABLE IF NOT EXISTS things (items TEXT NOT NULL);
INSERT INTO things(items) SELECT :Item WHERE :Item IS NOT NULL;
SELECT 'form' AS component, 'Add item:' AS title; SELECT 'Item' AS name;
SELECT 'list' AS component, 'Items:' AS title; SELECT items AS title FROM things;