When executing a JCR-SQL2 query there needs to be a way to specify a specific language (locale) for the query and have the comparison operations and sorting take account of the specified locale and compare or sort in a language specific manner.

This may require an extension to the javax.jcr.query.Query interface to add a setLocale() method which would be non-standard JCR functionality (perhaps to org.modeshape.jcr.api.query.Query?)