foo.js

async function foo() {
  try {
    const { pointer_id } = await db('pointer')
      .where({ report: 'foo-report' })
      .first();

    const data = await db('data').where('id', '>', pointer_id);

    const report = makeReport(data);

    await db('foo_report').insert(report);

    await db('pointer')
      .where({ report: 'foo-report' })
      .update({ pointer_id: data.at(-1).id });
  } catch (e) {
    console.trace(e);
  }

  setTimeout(foo, 1000);
}

foo();