I totally agree. There has been some progress here recently. Have you checked out DBT and their testing features?

https://docs.getdbt.com/docs/testing