Ask HN: How does big apps/platform manage between ORM vs. Stored procedures?

I wanted to ask how does big app like (Uber/slack) or any other for that matter or platforms like github who use Ruby/Python/C#/Java handle CRUD operations at scale with ORM or Stored procedures.

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?