const maps = sqlite.prepare(`SELECT map FROM maps`)
const finishes = sqlite.prepare(`SELECT * FROM race WHERE map = ? ORDER BY date`)
for (const map of maps.iterate()) {
    let currentFinish
    let currentBest = 0

    for (const record of finishes.iterate(map.map)) {
        currentFinish = record.time
        if (currentFinish <= currentBest || currentBest == 0) {
            currentBest = currentFinish

            sqlite.prepare(`
                    INSERT INTO "timeImprovements"
                    (
                        map, player, time, date, server
                    ) VALUES (?, ?, ?, ?, ?)
                `).run(
                map.map,
                record.player,
                record.time,
                record.date,
                record.server
            )
        }
    }
}