{"library":"puresql","type":"library","category":null,"description":"puresql is a Node.js SQL library inspired by Clojure's yesql that lets you define SQL queries in .sql files with named parameters and modifiers, then loads them as async functions. The current stable version is 1.10.0. It supports MySQL, MariaDB, PostgreSQL, MS SQL Server, and SQLite via adapters. Unlike ORMs or query builders, puresql keeps SQL raw and separate from JS logic, and supports parameter modifiers for safe interpolation, object insertion/update, dynamic conditions, and conditional clauses. Ships TypeScript definitions. Requires Node >= 6.0.0. Maintained but infrequent releases.","language":"javascript","status":"active","version":"1.10.0","tags":["javascript","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install puresql","imports":["const puresql = require('puresql')","const adapter = puresql.adapters.mysql(connection)","const queries = puresql.loadQueries('path/to/queries.sql')","const query = puresql.defineQuery('SELECT * FROM user WHERE id = :id')"]},{"cmd":"yarn add puresql","imports":[]},{"cmd":"pnpm add puresql","imports":[]}],"homepage":"https://github.com/neonerd/puresql#readme","github":"https://github.com/neonerd/puresql","docs":null,"changelog":null,"pypi":null,"npm":"puresql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}