On 10/14/11 6:08 AM, Jacob Carlborg wrote:
On 2011-10-14 12:19, foobar wrote:
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.
You cannot connect to a database in D at compile time. You could some
form of validation and escape the query without connecting to the database.
A little SQL interpreter can be written that figures out e.g. the names
of the columns involved.
Andrei
