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)