iPhoneのメッセージアプリのメッセージを保存する

$ sqlite3 3d0d7e5fb2ce288813306e4d4636395e047a3d28
sqlite> .output ./sms.csv
sqlite> .separator ,
sqlite> SELECT
  '"' || T2.text || '"'
  , T2.subject
  , datetime(T2.date + 978307200, 'unixepoch', 'localtime') AS date
  , CASE T2.is_from_me WHEN 0 THEN 'Received' WHEN 1 THEN 'Sent' ELSE 'Unknown' END AS is_from_me
  , T3.id
FROM
  chat_message_join T0
  INNER JOIN
    chat T1
  ON
    T0.chat_id = T1.ROWID
  INNER JOIN
    message T2
  ON
    T0.message_id = T2.ROWID
  INNER JOIN
    handle T3
  ON
    T2.handle_id = T3.ROWID
ORDER BY
  T2.date DESC;

const sqlite3 = require('sqlite3').verbose();
const db = new sqlite3.Database('./3d0d7e5fb2ce288813306e4d4636395e047a3d28')
const Iconv = require('iconv').Iconv;
const sjis = new Iconv('UTF-8', 'Shift_JIS//TRANSLIT//IGNORE');
const fs = require('fs');

const filename = './sms.csv';
db.serialize(() => {
  const sql = [];
  sql.push('SELECT');
  sql.push('  T2.text');
  sql.push('  , T2.subject');
  sql.push('  , datetime(T2.date + 978307200, \'unixepoch\', \'localtime\') AS date');
  sql.push('  , CASE T2.is_from_me WHEN 0 THEN \'Received\' WHEN 1 THEN \'Sent\' ELSE \'Unknown\' END AS is_from_me');
  sql.push('  , T3.id');
  sql.push('FROM');
  sql.push('  chat_message_join T0');
  sql.push('  INNER JOIN');
  sql.push('    chat T1');
  sql.push('  ON');
  sql.push('    T0.chat_id = T1.ROWID');
  sql.push('  INNER JOIN');
  sql.push('    message T2');
  sql.push('  ON');
  sql.push('    T0.message_id = T2.ROWID');
  sql.push('  INNER JOIN');
  sql.push('    handle T3');
  sql.push('  ON');
  sql.push('    T2.handle_id = T3.ROWID');
  sql.push('ORDER BY');
  sql.push('  T2.date DESC');
  db.each(sql.join(' '), (err, row) => {
    if (err) {
      console.log(JSON.stringify(err));
      return;
    }
    fs.appendFile(filename, sjis.convert(`${row.date}, ${row.id}, ${row.is_from_me}, ${row.subject}, \"${row.text}\"\r\n`));
  });
});

db.close();