About SQB

SQB is an extensible, multi-dialect SQL query builder and Database connection wrapper for NodeJS.

About @sqb/mssql-dialect

This package registers the mssql SQL serialization dialect (a SerializerExtension for @sqb/builder) used by @sqb/mssql. It is loaded automatically when @sqb/mssql is imported, so you normally don't need to depend on it directly.

It adapts query output to T-SQL: @name parameter placeholders instead of :name, OFFSET ... ROWS [FETCH NEXT ... ROWS ONLY] instead of LIMIT/OFFSET (SQL Server requires an ORDER BY before OFFSET, which the dialect adds automatically when a query needs pagination but has none), and SQL Server's own reserved-word list. RETURNING is rewritten into SQL Server's native OUTPUT INSERTED.col / OUTPUT DELETED.col clause rather than being stripped, since SQL Server has no RETURNING keyword but its OUTPUT clause achieves the same thing without a follow-up SELECT.

Installation

$ npm install @sqb/mssql-dialect --save

Node Compatibility

• node >= 20.x

License

SQB is available under MIT license.