entire repo could be a single sql query

[chee]

sqlite3 ~/Library/Messages/chat.db <<-'EOF'
.mode json
SELECT
  text,
  CASE is_from_me WHEN 1 THEN 'me' ELSE 'lb' END AS "from",
  CASE is_from_me WHEN 1 THEN 'friend' ELSE 'me' END AS "to",
  datetime(unixepoch("2001-01-01") + (date / 1000000000), "unixepoch") as date,
  service
FROM message
WHERE handle_id IN (
  SELECT ROWID FROM handle WHERE id = 'abc@icloud.xyz'
)
ORDER BY date ASC;
EOF