On 15/09/2010 16:11, Dave Abrahams wrote:
Here's a thread that might be interesting for anyone thinking of implementing a DSEL for SQL: http://markmail.org/message/rzcdlkquko2htvjp
I notice that most of this thread is going in the direction of trying to replicate SQL syntax instead of doing something closer to normal logic. I'd be much happier to use a syntax that just specifies "what I want" rather than "how to get there." In some cases the library could be responsible for conjuring up JOINs, for example, when that's the most efficient approach.
Relational algebra is the way databases work, and SQL is the standard language to express relational operations. Are you suggesting to create a language to query objects trees rather than work with relations, like Object-Relational mapping does? I think that's a terrible idea.