I’ve never worked on a project that was scaled out that didn’t require at least moderate DB maintenance, such as a large migration or sharding.

A migration is all but expected. Might as well make things easy on yourself for the first year and start with SQLite.