{"library":"mssql-query-builder","type":"library","category":null,"description":"A JavaScript library for dynamically building Microsoft SQL Server queries using a fluent, chainable API. Version 1.0.3 (latest) generates parameterized SQL with automatic variable naming via `input()`, supports SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, OFFSET/FETCH for pagination, and conditionally constructs queries. The library integrates with `mssql` for execution but does not require it; queries can be built and output as strings. It contrasts with raw string concatenation by reducing injection risks and improving readability. No active maintenance since 2021; last commit over two years ago.","language":"javascript","status":"maintenance","version":"1.0.3","tags":["javascript","node","nodejs","sql","server"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install mssql-query-builder","imports":["import QueryBuilder from 'mssql-query-builder'","const QueryBuilder = require('mssql-query-builder').default","import type QueryBuilder from 'mssql-query-builder'"]},{"cmd":"yarn add mssql-query-builder","imports":[]},{"cmd":"pnpm add mssql-query-builder","imports":[]}],"homepage":"https://github.com/CharlesStover/mssql-query-builder#readme","github":"https://github.com/CharlesStover/mssql-query-builder","docs":null,"changelog":null,"pypi":null,"npm":"mssql-query-builder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}