Port akka-persistence-r2dbc 1.0.0 and 1.0.1 changes

These releases are now Apache licensed - more than 3 years since release. akka-persistence-r2dbc 1.1.0 is not yet available to us but will be after April 28, 2026. * https://github.com/akka/akka-persistence-r2dbc/releases/tag/v1.0.0 * https://github.com/akka/akka-persistence-r2dbc/releases/tag/v1.0.1 Within the Pekko community, these R2DBC components are not among our most used libs. If you feel like you want to help port some of these changes, only do so if you think they are useful to you.