Warning - opinions ahead. I've use a bunch of ORMs (in various languages) over the last two decades. Imho, one stands distinctly above the others - Microsoft's Entity Framework (EF). EF does something fundamentally different, while the rest are all some version of Hibernate with a different API or Programming Language.

EF converts your code into SQL with the help of the compiler, and is not purely a runtime affair. This is what makes it relatively more usable.

To illustrate, if JS/TS were to approach the problem in a similar way, you'd do this:

1. Allow queries to be written like this:

  const bangaloreanStudents = await db.users.filter(x => x.city === "Bangalore" && x.age <= 20);

2. Use acorn/espree to parse this into an AST

3. Convert the AST into SQL, hand over to runtime helpers.

Doing so will allow queries to be written in the most natural way possible.