{"library":"odata-v4-pg","title":"odata-v4-pg","description":"OData V4 to PostgreSQL query compiler that converts OData query segments ($filter, $select, $orderby, $expand, $skip, $top) into SQL statements for PostgreSQL. Version 0.1.1 is the latest, with sporadic releases. It differs from alternatives like odata-v4-mysql by targeting PostgreSQL, supporting all standard OData query options, and providing a simple createFilter function that returns { where, parameters } for direct use with the pg driver.","language":"javascript","status":"active","last_verified":"Fri May 01","install":{"commands":["npm install odata-v4-pg"],"cli":null},"imports":["import { createFilter } from 'odata-v4-pg'","import { createQuery } from 'odata-v4-pg'","import { ODataServer } from 'odata-v4-pg'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import { createFilter } from 'odata-v4-pg';\nimport { Client } from 'pg';\n\nconst client = new Client({ connectionString: process.env.DATABASE_URL ?? '' });\nawait client.connect();\n\nconst filter = createFilter(\"Id eq 42\");\nconst res = await client.query(`SELECT * FROM Users WHERE ${filter.where}`, filter.parameters);\nconsole.log(res.rows);\nawait client.end();","lang":"typescript","description":"Demonstrates parsing an OData $filter expression and executing the resulting SQL query against PostgreSQL.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}