It would be interesting to expose Nuxeo-specific properties in CMISQL (with different names):
- ecm:isCheckedInVersion: useful to get only the last version
- ecm:mixinType: filter documents according to the facets, for instance documents hidden in navigation
- ecm:currentLifeCycleState: life cycle state
- main file digest