Phil Factor (10/27/2010)
I'm all in favor of relieving the need for repetitive coding in SQL, and I've published some articles on the subject, but I'm convinced, after many years of using these sorts of techniques, that there are limits to what can be achieved this way.
I'll be bold enough, and not for the first time, to predict that SSD will finally be understood to be the tool which supports BCNF/5NF (and not just a tool to speed boot). With such "complete" schemas, code generation from same is fully feasible. After all, as Date and Pascal have asserted, "a row *is* a business rule". Celko has also published "Thinking in Sets", which explains the use of auxiliary tables. Again, with such on SSD, performance is no longer an issue (modulo that one could get similar performance on rust with hundreds of short stroked parts).