> In what application would you load all users into memory from database and then filter them with TypeScript functions?

You’d be surprised! I have worked on a legacy PHP service which did something very similar