Has anyone looked at Nemerle's design for this? They have an SQL macro which allows to write SQL such as:
var employName = "FooBar" SQL (DBconn, "select * from employees where name = $employName"); what that supposed to do is bind the variable(s) and it also validates the sql query with the database. This is all done at compile-time. My understanding is that D's compile-time features are powerful enough to implement this.