{"library":"psqljs","type":"library","category":null,"description":"A minimal SQL generator for Node.js and PostgreSQL that builds parameterized queries with support for SELECT, INSERT, UPDATE, DELETE, WHERE, ORDER BY, LIMIT/OFFSET, and RETURNING clauses. Version 0.0.6 is the current release; the library has a low release cadence and is not actively developed. It generates query objects with 'text' and 'values' properties compatible with the 'pg' module. Compared to alternatives like Squel or Knex, psqljs is extremely minimal with no dependencies but lacks TypeScript support, join building, raw SQL escape hatches, and advanced features.","language":"javascript","status":"active","version":"0.0.6","tags":["javascript","psqljs","psql","sql"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install psqljs","imports":["import sql from 'psqljs'","const sql = require('psqljs')\nsql.select().from('users').toQuery()","sql.select().from('users').toQuery()"]},{"cmd":"yarn add psqljs","imports":[]},{"cmd":"pnpm add psqljs","imports":[]}],"homepage":"https://github.com/swlkr/psqljs","github":"git://github.com/swlkr/psqljs","docs":null,"changelog":null,"pypi":null,"npm":"psqljs","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}