[felipetrz]

You can test them very easily by using database containers.

[tracker1]

The setup/teardown, and even working with schema migrations can get complex, and potentially excessively so for the benefit of doing everything in SPs. Also, the developer experience and discoverability are definitely less than ideal.