azure-odata-sql
Advanced tools
Readme
This library contains functionality to convert OData queries into SQL statements.
The library uses types from the mssql npm package to represent parameter types.
The query object is in the format produced by
azure-query-js.
npm i azure-odata-sql
The library currently exports a single function:
require('azure-odata-sql').format(query, tableConfig)
The query parameter is an object with any of the following properties:
| Property | Description |
|---|---|
| skip | Number of rows to skip |
| take | Number of rows to take |
| inlineCount | Set to allpages to include a total count query |
| resultLimit | Number of rows to limit the query to |
| selections | Columns to select |
| filters | Filters to apply |
| ordering | Columns to sort by |
| id | Record identifier |
| includeDeleted | Include soft deleted columns |
The tableConfig is an object with any of the following properties:
| Property | Description |
|---|---|
| name | The name of the table being queried |
| schema | The database schema name for the table |
| flavor | Either mssql or sqlite |
| softDelete | True if the table supports soft delete with a column called deleted |
FAQs
Convert OData queries into SQL statements
The npm package azure-odata-sql receives a total of 52 weekly downloads. As such, azure-odata-sql popularity was classified as not popular.
We found that azure-odata-sql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
Socket CEO Feross Aboukhadijeh joins a16z partners to discuss how modern, sophisticated supply chain attacks require AI-driven defenses and explore the challenges and solutions in leveraging AI for threat detection early in the development life cycle.
Security News
NIST's new AI Risk Management Framework aims to enhance the security and reliability of generative AI systems and address the unique challenges of malicious AI exploits.
Security News
This episode of the Risky Biz podcast discusses how the rise of small open source packages and the shift towards individual maintainers makes the ecosystem more vulnerable to supply chain attacks.