Right, but it effectively solves it (even if not theoretically). Most applications won't come close to encountering the N+1 problem on Sqlite, whereas it comes

Right, but it effectively solves it (even if not theoretically). Most applications won't come close to encountering the N+1 problem on Sqlite, whereas it comes early on in server-based databases.