{"library":"odata-v4-sql","title":"odata-v4-sql","description":"An OData V4 request to SQL query compiler, converting OData query segments ($filter, $select, $skip, $top, $orderby, $expand) into SQL WHERE clauses or full SELECT statements. Version 0.1.2 is current, with basic support for $filter, $select, $skip, $top, $orderby, and $expand. It differs from alternatives by focusing solely on SQL generation, not full OData server implementations. Ships TypeScript types.","language":"javascript","status":"active","last_verified":"Fri May 01","install":{"commands":["npm install odata-v4-sql"],"cli":null},"imports":["import { createFilter } from 'odata-v4-sql'","import { createQuery } from 'odata-v4-sql'","import { OData2Filter } from 'odata-v4-sql'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import { createFilter } from 'odata-v4-sql';\n\n// Example OData $filter from request: \"Id eq 42 and Status eq 'active'\"\nconst filter = createFilter(\"Id eq 42 and Status eq 'active'\");\nconsole.log(filter.where); // WHERE clause: \"[Id] = 42 AND [Status] = 'active'\"\n// Use with your SQL driver:\n// db.query(`SELECT * FROM Users WHERE ${filter.where}`);","lang":"typescript","description":"Shows how to convert an OData $filter string into a SQL WHERE clause using the createFilter function.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}