Honestly I've never found a programming language where SQL didn't have some tedious tasks. There are always lots of little edge cases and error handling etc that never seems to be fully covered by the libraries. That said, for a CRUD type app, I usually default to node.js unless the requirements would exclude it for some reason, then I'd move to Go, but generally I avoid writing new Java anymore, not that I think Java is bad or evil, I just prefer other languages.
For node we use the pg-format package to format most of our queries and then the standard pg package to execute queries. It is honestly one of the easier and cleaner ways methods I've used. I am not a big fan of ORM's and find a lot of them add way to much complexity for too little benefit, so I am a big fan of either stored procedures/functions or straight (but safe) query building.
I have written code in node.js, Go, C & C++, Java and Python to manipulate data in different sql databases and they all have some form of tedious tasks in relation to the SQL integration.
For node we use the pg-format package to format most of our queries and then the standard pg package to execute queries. It is honestly one of the easier and cleaner ways methods I've used. I am not a big fan of ORM's and find a lot of them add way to much complexity for too little benefit, so I am a big fan of either stored procedures/functions or straight (but safe) query building.
I have written code in node.js, Go, C & C++, Java and Python to manipulate data in different sql databases and they all have some form of tedious tasks in relation to the SQL integration.