Also, views are the essence of composability. As for testing in the Postgres sphere, there's pgTAP and pg_prove. https://pgtap.org/ https://pgtap.org/ Extensi

Also, views are the essence of composability. As for testing in the Postgres sphere, there's pgTAP and pg_prove. https://pgtap.org/ https://pgtap.org/ Extension development includes a built-in unit testing harness as well. For use with any database, a tool like Sqitch allows for DB-agnostic verification at each migration point. https://sqitch.org/docs/manual/sqitchtutorial/#trust-but-verify https://sqitch.org/docs/manual/sqitchtutorial/#trust-but-ver... Proprietary databases have their own solutions as well. https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creating-and-running-a-sql-server-unit-test?view=sql-server-ver16 https://learn.microsoft.com/en-us/sql/ssdt/walkthrough-creat... I think "utter lack" is grossly misrepresenting the state of the art. If you mean "widespread ignorance of existing techniques related to composability or testability," then we are in agreement.