Hello David,
Fabian - To be sure I understand what you are describing. You would do
> something like create a logical table with many different implementations,
> one for each database vendor. These would be distinguished by having
> different SQL version strings. Then at runtime, based on the type of the
> database being accessed, the appropriate logical table implementation would
> be used.
>
One more time, you say exactly what I was trying to say :-)
> My first thought is that this is something to be done on top of R2RML
> rather than in R2RML. Meaning that something outside of R2RML would know
> about the set of available logical table resources and at runtime would
> produce an R2RML mapping with the logical table appropriate for the database
> being accessed.
>
I agree with that, so the best solution is certainly that SQL (and not
R2RML) adds such a feature (every vendor implements the feature, why not SQL
itself ?).
Have a nice day !
Fabian Pijcke