test(sqlite): use context managers for sqlite connections to avoid `R…

test(sqlite): use context managers for sqlite connections to avoid `R… #7626