CREATE TABLE Customer (id INTEGER PRIMARY KEY, name TEXT); CREATE TABLE Purchase (id INTEGER PRIMARY KEY, customer_id INTEGER); INSERT INTO Customer VALUES (2, 'Ana'); INSERT INTO Purchase VALUES (8, 2); SELECT c.name FROM Purchase AS p JOIN Customer AS c ON c.id = p.customer_id; SELECT json_extract('{"name":"Maps","pages":80}', '$.name');