Interesting. I also was very cautious with respect to stored procedures and triggers. but simple procedures are the best means for data integrity.

Domain model penetrates database layer anyway, so pure clean architecture is just not possible - abstractions leak.

Controlled and moderate introduction of stored procedures is ok.