Read documents from index (all or with filter)

Returns documents from an index (or alias) by using the index name as the table name. For server-side filtering use the Query parameter in the WITH clause; WHERE runs client-side and is slower.

SELECT * FROM MyIndexOrAliasName --WITH(Query='{"match": { "PartNumber" : "P50" } }')