The SQL language has a syntax that is human-oriented, rather than user-oriented -- designed for entering statements into an SQL client and reading the results. Database programs whose SQL statements are determined at runtime generate SQL statements by concatenating substrings. I find this approach ugly, clumsy and error-prone.
Of course, I could write my own wrapper around the SQL string generation process, but that would take work. Are there any freely available APIs for building SQL command strings programmatically?
Since the relational database already exists, I'd prefer something lightweight, rather than, say, a comprehensive persistence framework such as container-managed EJBs or Hibernate.