There is room for improvement.
SQL is backwards. "SELECT ..." at this point I'd like to get some code insight. But the editor does not know what table(s) I'm working with. I have to put in something, add "FROM myTable", go back to the first line and finally get the list of available fields.
With Entity Framework:
" myTable.Select(t => t.<ctrl+space>" and the list of available fields appear instantly. No fuzz.
EF has its share of pitfalls, but I have strong types from the database backend all the way to my JSON DTOs. It is a valuable tool to have around.