@typed-query-builder/sql-mssql
v0.7.1
Published
A SQL dialect for SQL Server
Downloads
21
Readme
@typed-query-builder/sql-mssql
See typed-query-builder README for more details.
Features: functions, operations, clauses, data types, etc.
The following query builder features are non-natively supported through this library:
DISTINCT
,NOT DISTINCT
predicates<<
,>>
operatorsIS TRUE
,IS FALSE
predicatesBOOLEAN
data typeCIRCLE
,BOX
geometric data typesgreatest, least, factorial, truncate, div, startsWith, dateWithTime, dateAddDays, dateSubDays, daysBetween, createTimestamp, currentDate, timestampToSeconds, timestampFromSeconds, datesoverlap, timestampsOverlap, padLeft, padRight
functionsboolAnd, boolOr, countIf
aggregate functions
The following query builder features are added to support more SQL Server functionality.
SMALLMONEY
,NCHAR
,NTEXT
,NVARCHAR
data typestop
,option
clauses for INSERT, SELECT, UPDATEsquare, choose, nchar, soundexDifference, soundex, split, jsonTest, jsonValue, jsonQuery, jsonModify, dateName, day, month, year, geomArea, geomText, geomBoundary, geomWithBuffer, geomConvexHull, geomCrosses, geomDimension, geomDisjoint, geomEnd, geomStart, geomBoundingBox, geomEquals, geomClosed geomEmpty, geomRing, geomSimple, geomValid, geomOverlaps, geomSrid, geomRandomPoint, geomSymmetricDifference, geomWithin
functions.
The following query builder features are not supported on SQL Server:
UNSIGNED
data typesFILTER
clause in aggregate functionsDISTINCT ON
clause in SELECTROW
constructor, comparison, and updatingINSERT
priorityINSERT
on duplicate ignore or setBITS
data typeLINE
data type (not to be confused with SEGMENT)CBRT, GCD, LCM, REGEX_REPLACE, REGEX_GET
functionsBIT_AND, BIT_OR, NTHVALUE
aggregate functions