Re: Generating SQL statements in BL

Marcel van der Boom wrote:
> On Mon 12-Oct-2009 20:24
> "[email protected]" <[email protected]> wrote:
> 
>> The tableddl scenario goes a step in this direction, but it is
>> limited to the CREATE statements that create a Xaraya installation.
>> This idea would allow us to generalize the approach in that scenario.
> 
> That it does 'CREATE' statements (or 'ALTER' as we see fit) is more or
> less unrelated to the xml. The DTD describes a set of elements
> describing tables, columns and what have you; declarative in any case.
fair enough
> 
> The DDL code then takes its turn and transforms these declarations into
> other declarations specified not in XML but in SQL. They fit nicely
> because they both declare things (almost staticallly).
> 
> If you get into the /querying/ part of SQL, the distance increases from
> the declarative nature of XML, making it harder. 

Been thinking of this a bit, and I guess I don't quite understand it.
What are the specific consequence of being more or less "declarative"?
If I can characterize a result set through a SELECT statement, even 
without actually executing the operation, is that not declarative? After 
all it's not like we're specifying how to get the data. Or am I missing 
something here?

Thanks,
Marc