Query documents (default container)

Runs a Cosmos DB SQL query against the default container from the connection settings. Use the #DirectSQL prefix so the query is sent as-is; root refers to the container. Filter and order as needed (e.g. by root._ts for last-updated).

For query syntax see Cosmos DB SQL query reference.

#DirectSQL SELECT * FROM root where root.id !=null order by root._ts desc