The primary need for this feature comes from MODE-933.

ModeShape's support for JCR-SQL2 (and perhaps JCR-SQL) should include using pseudo-columns for the path, name, local name, depth and score of a selector. Support should include using these pseudo-columns in the SELECT clause (just as regular properties, and thus would appear in the QueryResult's row values) and in the WHERE clause (where they can be rewritten to use the existing PATH, NAME, LOCALNAME, DEPTH, and SCORE functions). However, they should not be automatically included in the SELECT clause if the query uses "SELECT *"; they must explicitly be specified in order to appear in the results.