Read documents from alias (all or with filter)

Returns documents from an alias. Use the alias name as the table name. For server-side filtering pass a query in the WITH clause.

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