The CData JDBC Driver for Salesforce Chatter models the Salesforce Chatter API as relational Views and Stored Procedures. These are defined in schema files, which are simple, text-based configuration files.
Collaborative Query Processing
API limitations and requirements are documented in this section. The driver offloads as much of the SELECT statement processing as possible to Salesforce Chatter and then processes the rest of the query in memory.
See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.