[go_prodev]

As someone who always prefers native SQL over ORM queries, I'll add a couple of counterpoints.

Most IDEs provide intellisense/validation of ORM entities, vs treating SQL like a raw string.

ORM entities also make refactoring and impact analysis slightly easier.

Despite those benefits, I generally find ORMs a pain for anything besides the most basic queries.

[gryn]

For typescript I've found pgtyped to be my perfect middle ground. I write SQL queries, it auto generate typing for the query and the response.