7 Sep
2009
7 Sep
'09
9:57 p.m.
Joel Falcou wrote:
Jean-Louis Leroy wrote: How do you deal with columns that have the same name but different types in different tables ? And with table aliases (e.g. when dealing with self-joins) ?
Currently I don't as I wasn't even aware of this kind of use-case. As I said, it was a mere proof of concept. DB are not my main domain of expertise, so if anyone know what's wrog/right with this design, feel free to tell me and I'll see.
An interesting DSL for SQL queries was presented in an IBM event in 2007: http://www.haifa.ibm.com/Workshops/ple2007/present/Simple_and_safe_SQL.pdf Best regards Jorge