Odata - Enabling Native query - Native queries aren't supported by this value. Details: [Table]

GermanAravena  - are you trying to connect to an SQL server that is managed by your DBA?  If so, why are you using an OData connection to a public source like "services.odata.org".  Please note, the OData will not support query folding or the advance API connection that Miguel is describing.  In this scenario, you will be copying the entire table from the northwind database before applying the filter date.  If you are testing this example, I would suggest using a SQL database source, or set up a basic SharePoint example like Miguel's. 

Note Miguel's example is not technically query folding, it is just a lazy evaluation example.  The Range Start and End are turned into a filter to reduce the number of files retrieved from SharePoint files.  He is taking advantage of the SharePoint's API to create a url string with additional filter.  The first time he runs this issues 3 URL requests from SharePoint, when the incremental load is enabled, only one URL request is issued (a lazy evaluation).