The biggest pain of unit testing of database code is setup and cleanup of data fo tests.
That could be made easy if we use/recommend using something like table-api-generator

I've raised few requests on that project. Once accepted and implemented, we could start doing demos and recommending that library for common data setup/cleanup.