ISSUE-70 (SELECT EMP.JOB): Behaviour of fully qualified column names in rr:sqlQuery

ISSUE-70 (SELECT EMP.JOB): Behaviour of fully qualified column names in rr:sqlQuery

http://www.w3.org/2001/sw/rdb2rdf/track/issues/70

Raised by: Richard Cyganiak
On product: 

This was raised by David as part of his LC feedback:
http://lists.w3.org/Archives/Public/public-rdb2rdf-comments/2011Oct/0022.html

Section 6 of R2RML states:

[[
The referenced columns of all term maps of a triples map (subject map, predicate maps, object maps, graph maps) MUST be column names that exist in the term map's logical table.
]]

Per the previous definition of "column name" this implies that the values cannot be qualified. And the intent is indeed that in rr:column, rr:template etc, "JOB" would be used and "EMP.JOB" would be illegal.

But does this mean that writing "SELECT EMP.JOB FROM JOB" in rr:sqlQuery should be considered illegal? Or does it make sense to write such a query and then access the result set column with just an unqualified "JOB"?

Received on Monday, 7 November 2011 16:06:04 UTC