Get list items with filter
Gets items from a list using a filter. This mimics a SharePoint view. Use HonorNonIndexedQueriesWarningMayFailRandomly in ExtraHeaders if filtering on non-indexed fields.
SELECT * FROM MyList
WITH(Filter='MyField eq ''Something'' ')
--In order to search on non-indexed fields set following value for ExtraHeaders property on connection UI
--Prefer: HonorNonIndexedQueriesWarningMayFailRandomly