They can be with provisioned concurrency.

If provisioned concurrency is used, then fetching the database at startup would be a valid strategy given you could still achieve flat response times.

That's true. I prefer this approach because it removes that additional thing (the request to S3) that can be slow or fail at runtime. Or "initialization" time, I guess, depending on how you look at it.