I find that a language as Go feels really tedious working with SQL, Java on the other end of the spectrum has many options but they feel pretty bulky. Whats your language of choice for a relatively simple CRUD app which uses SQL?
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.<p>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.<p>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.
I've never encountered great database mapping. I like .NET's type-safe query builder, but it's still very limited once you get beyond the absolute basics.<p>You may be interested in <a href="https://hasura.io" rel="nofollow">https://hasura.io</a>
Great question. General-purpose programming languages and query languages have entirely different objectives and don't mix well. In practice, SQL is a high-level messaging protocol used to communicate between two processes (client <-> server) or two modules within a single process (client <-> embedded DBMS).<p>I worked with several operating systems that included a native programming language and a built-in DBMS: DEC-MUMPS (MUMPS) and IBM OS/400 (RPG). The facilities for database queries in these languages were much better than embedded SQL.