Re: Generating SQL statements in BL

Marcel van der Boom wrote:
....
> 
> For me the main difference is I think what gets stored as a definition
> (tables, columns, views etc.) vs things that are used during runtime.
Thanks for this detailed comment
> 
> But, having said the above, isn't the main point that SQL as
> such does not belong in templates? If I found myself doing an SQL
> statement in XML in a template I'd probably define a tag or a method to
> do the work for me and gain a bit of semantics over SQL.

Actually you are right in that I was being a bit too sloppy
in my description of this issue. Although obviously the markup should 
transform to an SQL statement, what I am looking for is a way of 
characterizing a dataobject in terms of its properties - not the 
underlying datasource fields - that would be more expressive than what 
we have at present in the getitem and getitems tags.