Another important aspect is the use of SQL code modules as a means for code modularisation, nudging the SDLC more towards SOLID so to speak, something that is immensely beneficial to any TDD environment. Obviously a stored procedure as a unit/module/interface/what ever has then to call another regardless of the level/depth.
😎