A pro can be a con, and vice versa. The reason why you move to a SPA might be the reason why you move away from it. The reason why you use sqlite early on might be the reason you move away from it later.

A black & white view of development and technology is easy but not quite correct. Technology decisions aren't "one size fits all".