why SQLDelight's

generate[SourceSet]DatabaseSchema

deletes existing

CURRENT_VERSION.db

file before generating a new

CURRENT_VERSION + 1.db

file? I have

1.db

file and when I write

1.sqm

file and run

generate[SourceSet]DatabaseSchema

again, I get

2.db

but the

1.db

gets deleted. I want them side by side, am I missing something here?

I don't know specifically, but I believe the idea is that you don't need the old one because you've already tested it historically. As long as you don't change anything, there's no point in testing it again. If there is a point in testing it again, you only want to keep the lower version and not have both.