Since the REST API is OData based, server-side filters are done using the OData standard. The driver does most of the server filtering by reading the metadata file and determing which filters can be done on the server.

NOTE: When executing "SELECT *" queries, the Microsoft SharePoint REST API response does not return all the available fields. To avoid too many null values, the provider selects all the columns explicitly using the $select filter. However, to avoid an error from Microsoft SharePoint REST API regarding the URL length, the provider only does this if the $select filter's length is 1500 or less. This is a limitation of the Microsoft SharePoint REST API. In this situation, the only way to see the actual value of some columns is to explicitly select them in your query.