Package version:

Interface SqlQuerySpec

Represents a SQL query in the Azure Cosmos DB service.

Queries with inputs should be parameterized to protect against SQL injection.

const query: SqlQuerySpec = {
query: "SELECT * FROM Families f where f.lastName = @lastName",
parameters: [
{name: "@lastName", value: "Wakefield"}
]
};
interface SqlQuerySpec {
    parameters?: SqlParameter[];
    query: string;
}

Properties

Properties

parameters?: SqlParameter[]

The parameters you provide in the query

query: string

The text of the SQL query