{"library":"odata-v4-mysql","title":"odata-v4-mysql","description":"OData V4 MySQL Connector (v0.1.1) converts OData V4 query segments like $filter, $select, $skip, $top, $orderby, and $expand into MySQL SQL statements. Provides functions createFilter, createQuery, and createDelete. Supports TypeScript types, can be used with any MySQL driver. No major updates since 2016; considered stable but low activity. Differentiator: direct mapping of OData to MySQL SQL, lightweight, no ORM needed.","language":"javascript","status":"maintenance","last_verified":"Fri May 01","install":{"commands":["npm install odata-v4-mysql"],"cli":null},"imports":["import { createFilter } from 'odata-v4-mysql'","import { createQuery } from 'odata-v4-mysql'","import { createDelete } from 'odata-v4-mysql'"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import { createFilter } from 'odata-v4-mysql';\nimport * as mysql from 'mysql';\n\nconst connection = mysql.createConnection({\n  host: 'localhost',\n  user: 'root',\n  password: process.env.DB_PASSWORD ?? '',\n  database: 'test'\n});\n\n// Example OData filter: $filter=Id eq 42\nconst filter = createFilter('Id eq 42');\nconnection.query(`SELECT * FROM Users WHERE ${filter.where}`, filter.parameters, (err, rows) => {\n  if (err) throw err;\n  console.log(rows);\n});\nconnection.end();","lang":"typescript","description":"Create a MySQL connection, build an OData $filter, and execute the query with parameters.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}