Pseudo-columns were introduced in MODE-934, but as initially implemented they were not automatically included in the SELECT clause when the query engine expands "SELECT *" for each selector. However, it is possible to defined "marker" mixin node types that have no property definitions (because they don't extend 'nt:base'), which means they'd have no columns returned from a "SELECT *" query and thus none of these would ever be queryable through JCR-SQL2.

Therefore, I think we should include the "jcr:path", "jcr:name", "jcr:score", "mode:localName", and "mode:depth" pseudo-columns when the SELECT * clause is expanded, so that all node types can be queried though JCR-SQL2, JCR-SQL, and XPath.