@Dima K

The "This endpoint supports advanced query options" option on the Connect-REST rule and the "Allow querying any column (REST Connector based connections only)" option on the Data Page are designed to work with non-OData sources.

These options allow you to use more complex queries when retrieving data from a REST service or a database. When you select these options, you can use query parameters to filter, sort, and group the data that is returned from the service or database.

For Connect-REST, the advanced query options are specified in the URL that is used to retrieve the data. For example, you can use a URL like this to retrieve all orders that were placed after a certain date:

http://example.com/orders?filter=placedDate gt '2022-01-01'

For Data Pages, you can specify the query parameters in the Data Page configuration. For example, you can use a query like this to retrieve all customers who have a certain last name:

SELECT * FROM Customers 

WHERE LastName = 'Smith'

It's worth noting that the ability to use advanced query options depends on the capabilities of the REST service or database that you are using. Some services or databases may not support all of the query parameters that you want to use, so it's important to consult the documentation or API reference for the service or database to determine what is supported.