Indeed, there are many factors to consider here. In a sense that is what makes discussions like this interesting!

I suspect that in some respects that we already optimize for this as an industry, we might have application logic in python, but the database is presumably written in a systems programming language.