OData to SQL query compiler
npm install odata-v4-sqljavascript
import { createFilter } from 'odata-v4-sql'
//example request: GET /api/Users?$filter=Id eq 42
app.get("/api/Users", (req: Request, res: Response) => {
const filter = createFilter(req.query.$filter);
// request instance from mssql module
request.query(SELECT * FROM Users WHERE ${filter.where}, function(err, data){
res.json({
'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',
value: data
});
});
});
`
Advanced TypeScript example available here.
Usage ES5
`javascript
var createFilter = require('odata-v4-sql').createFilter;
app.get("/api/Users", function(req, res) {
var filter = createFilter(req.query.$filter);
// request instance from mssql module
request.query(filter.from("Users"), function(err, data){
res.json({
'@odata.context': req.protocol + '://' + req.get('host') + '/api/$metadata#Users',
value: data
});
});
})
``