"Typed raw SQL" is the best we could think of to name this approach. Perhaps hackernews can do better? The common criteria are that SQL must be be validated in situ, and strong typing should be continuous from the database into the application code.
Typed raw SQL for data access now exists for typescript/postgres (pgtyped), Go (sqlc), Scala (scala-slick) and perhaps others. QueryFirst, Visual Studio extension since 2016, now has a VS Code version, and multiplatform .net 5 command line. (github)