I've been reading. Scheming. And I stumpled upon SchemeUnit and SchemeQL: Two Little Languages. I liked the paper. Especially the SchemeQL part. It does state my (intellectual) motivation behind writing relations/sqlgen.

• SQL statements are not checked until execution time. That is error prone.
• SQL statements are not host language statements. They can't be used in the same way or manipulated as the host language statements. Except by using crude text processing, one cannot programatically compose, abstract and refine embedded SQL statements. Code quality and productivity suffers.

The downside is that the SQL produced code, at least initially, will be sub-optimal. But hey, do you write in Assembler? If yes, in what cases?