Where do you draw the line when to use SP's or ORM? Considering not everyone understands database in depth and can write performant queries or SP's.
I know its very simple view and probably tons patterns (like CQRS) and infrastructure/serverless/geo-replicated architecture might be use behind the scene.
Have you ever worked on such systems where both ORM and SP's are used and how do they keep logic not fragmented at multiple places at scale?
TLDR; How highly scalable apps manage DB interactions in code vs handwritten SQL?
