# react-native-azure-odata-sql

> Convert OData queries into SQL statements

Latest version **0.2.2** (published 2019-01-24) · MIT license · 0 weekly downloads

## Install

```sh
npm install react-native-azure-odata-sql
pnpm add react-native-azure-odata-sql
yarn add react-native-azure-odata-sql
bun add react-native-azure-odata-sql
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support; pre 1.0.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 0.2.2 |
| Published | 2019-01-24 |
| First published | 2019-01-23 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 1 |
| Unpacked size | 75.8 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| GitHub stars | 0 |
| Author | Minh Nguyen |
| Maintainers | shadowminhja |

## Links

- npm: https://www.npmjs.com/package/react-native-azure-odata-sql
- Repository: https://github.com/ShadowMinhja/react-native-azure-odata-sql
- Homepage: https://github.com/ShadowMinhja/react-native-azure-odata-sql#readme
- Issues: https://github.com/ShadowMinhja/react-native-azure-odata-sql/issues
- npm.io page: https://npm.io/package/react-native-azure-odata-sql

## Dependencies (1)

- [react-native-util](https://npm.io/package/react-native-util.md) 1.0.2

## Recent versions

- 0.2.2 (latest) — 2019-01-24
- 0.2.1 — 2019-01-23

## README

# azure-odata-sql

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](https://github.com/Azure/queryjs).

## Installation

    npm i azure-odata-sql

## Usage

The library currently exports a single function:

    require('react-native-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`|

---
_Source: https://npm.io/package/react-native-azure-odata-sql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._