Re: SQL in R2RML mappings

>
>
>  5) Support for database vendor specific SQL statements.
>>
>> For example, this is needed if a mapping needs to use an Oracle specific
>> statement that cannot be parsed as standard SQL.
>>
>> A possible solution is to allow SQL statements to be flagged as "opaque".
>> This would indicate that the statements are not to be parsed by the mapping
>> tool, but simply passed down to the underlying database.
>>
> It is already assumed to be opaque.


Souri-  I interpreted this statement in section 1.3 of the R2RML spec to
preclude the use of vendor specific SQL:

"In places where SQL expressions are allowed, these *MUST* conform to Core
SQL 2008."

-David

Received on Tuesday, 25 January 2011 16:46:09 UTC