@memberjunction/sql-dialect - npm Package Compare versions

Comparing version 5.32.0 to 5.33.0

dist/typeClassification.d.ts

+/**
+ * Cross-dialect SQL type-classification predicates.
+ *
+ * Single source of truth for "is this SQL type name a string / boolean / date
+ * / etc." across the MJ stack. Built by unioning each registered SQLDialect's
+ * type-name getters (see `SQLDialect.BooleanTypeNames`, `StringTypeNames`,
+ * etc.), so adding a new dialect requires zero changes here — just register
+ * its dialect class with the same getters and the predicates pick it up.
+ *
+ * Usage:
+ * ```typescript
+ * import { IsBooleanSQLType, IsStringSQLType } from '@memberjunction/sql-dialect';
+ *
+ * if (IsStringSQLType(field.Type)) {
+ *   // safe to LOWER() and string-compare
+ * }
+ * ```
+ *
+ * Why this exists: prior call sites hand-coded long switch/case lists of SQL
+ * type names in 5+ files (graphql_server_codegen.ts, MJCore util.ts,
+ * MetadataSync sync-engine.ts, PushService.ts, …). Each list was subtly
+ * different — some included `bpchar`, some forgot `character varying`, some
+ * had `citext` only after a PG bug — and adding a new column type required
+ * grepping every list. Now there is one place per category, owned by the
+ * dialect that defines the type.
+ */
+/** True if `typeName` is a boolean type in any registered dialect (`bit`, `boolean`, `bool`). */
+export declare function IsBooleanSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a variable / fixed-length character / text type. Excludes `uuid`. */
+export declare function IsStringSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a date / time / timestamp type. */
+export declare function IsDateSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is an integer type (any width, including auto-increment / rowversion). */
+export declare function IsIntegerSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a floating-point or fixed-precision decimal type. */
+export declare function IsFloatSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a UUID type (`uniqueidentifier`, `uuid`). */
+export declare function IsUuidSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a binary blob type (`varbinary`, `image`, `bytea`). */
+export declare function IsBinarySQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a JSON / XML structured-document type. */
+export declare function IsJsonSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a fixed-precision currency type (`money`, `smallmoney`). */
+export declare function IsCurrencySQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is an interval / duration type (`interval` — PG only currently). */
+export declare function IsIntervalSQLType(typeName: string | null | undefined): boolean;
+/** True if `typeName` is a network address type (`inet`, `cidr`, …). */
+export declare function IsNetworkSQLType(typeName: string | null | undefined): boolean;
+/**
+ * Convenience aggregate: any "numeric" type — integer, float, or currency.
+ * Use when the call site doesn't care about the precision/scale distinction.
+ */
+export declare function IsNumericSQLType(typeName: string | null | undefined): boolean;
+//# sourceMappingURL=typeClassification.d.ts.map

dist/typeClassification.d.ts.map

+{"version":3,"file":"typeClassification.d.ts","sourceRoot":"","sources":["../src/typeClassification.ts"],"names":[],"mappings":"AAAA;;;;;;;;;;;;;;;;;;;;;;;;;GAyBG;AA+CH,iGAAiG;AACjG,wBAAgB,gBAAgB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE7E;AAED,8FAA8F;AAC9F,wBAAgB,eAAe,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE5E;AAED,4DAA4D;AAC5D,wBAAgB,aAAa,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE1E;AAED,gGAAgG;AAChG,wBAAgB,gBAAgB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE7E;AAED,8EAA8E;AAC9E,wBAAgB,cAAc,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE3E;AAED,sEAAsE;AACtE,wBAAgB,aAAa,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE1E;AAED,gFAAgF;AAChF,wBAAgB,eAAe,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE5E;AAED,mEAAmE;AACnE,wBAAgB,aAAa,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE1E;AAED,qFAAqF;AACrF,wBAAgB,iBAAiB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE9E;AAED,0FAA0F;AAC1F,wBAAgB,iBAAiB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE9E;AAED,wEAAwE;AACxE,wBAAgB,gBAAgB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAE7E;AAED;;;GAGG;AACH,wBAAgB,gBAAgB,CAAC,QAAQ,EAAE,MAAM,GAAG,IAAI,GAAG,SAAS,GAAG,OAAO,CAG7E"}

dist/typeClassification.js

+/**
+ * Cross-dialect SQL type-classification predicates.
+ *
+ * Single source of truth for "is this SQL type name a string / boolean / date
+ * / etc." across the MJ stack. Built by unioning each registered SQLDialect's
+ * type-name getters (see `SQLDialect.BooleanTypeNames`, `StringTypeNames`,
+ * etc.), so adding a new dialect requires zero changes here — just register
+ * its dialect class with the same getters and the predicates pick it up.
+ *
+ * Usage:
+ * ```typescript
+ * import { IsBooleanSQLType, IsStringSQLType } from '@memberjunction/sql-dialect';
+ *
+ * if (IsStringSQLType(field.Type)) {
+ *   // safe to LOWER() and string-compare
+ * }
+ * ```
+ *
+ * Why this exists: prior call sites hand-coded long switch/case lists of SQL
+ * type names in 5+ files (graphql_server_codegen.ts, MJCore util.ts,
+ * MetadataSync sync-engine.ts, PushService.ts, …). Each list was subtly
+ * different — some included `bpchar`, some forgot `character varying`, some
+ * had `citext` only after a PG bug — and adding a new column type required
+ * grepping every list. Now there is one place per category, owned by the
+ * dialect that defines the type.
+ */
+import { SQLServerDialect } from './sqlServerDialect.js';
+import { PostgreSQLDialect } from './postgresqlDialect.js';
+const SS = new SQLServerDialect();
+const PG = new PostgreSQLDialect();
+/**
+ * Registered dialects whose type-name getters are unioned into the
+ * classification predicates below. Order is irrelevant — predicates are
+ * `Set.has()` lookups.
+ */
+const DIALECTS = [SS, PG];
+/**
+ * Build a Set from one accessor across every registered dialect, normalizing
+ * each name to lowercase + trimmed so call sites can pass raw `EntityField.Type`
+ * strings without pre-normalizing.
+ */
+function unionLowercase(getter) {
+    const out = new Set();
+    for (const dialect of DIALECTS) {
+        for (const name of getter(dialect)) {
+            out.add(name.trim().toLowerCase());
+        }
+    }
+    return out;
+}
+const BOOLEAN_TYPE_SET = unionLowercase(d => d.BooleanTypeNames);
+const STRING_TYPE_SET = unionLowercase(d => d.StringTypeNames);
+const DATE_TYPE_SET = unionLowercase(d => d.DateTypeNames);
+const INTEGER_TYPE_SET = unionLowercase(d => d.IntegerTypeNames);
+const FLOAT_TYPE_SET = unionLowercase(d => d.FloatTypeNames);
+const UUID_TYPE_SET = unionLowercase(d => d.UuidTypeNames);
+const BINARY_TYPE_SET = unionLowercase(d => d.BinaryTypeNames);
+const JSON_TYPE_SET = unionLowercase(d => d.JsonTypeNames);
+const CURRENCY_TYPE_SET = unionLowercase(d => d.CurrencyTypeNames);
+const INTERVAL_TYPE_SET = unionLowercase(d => d.IntervalTypeNames);
+const NETWORK_TYPE_SET = unionLowercase(d => d.NetworkTypeNames);
+function normalize(typeName) {
+    return (typeName ?? '').trim().toLowerCase();
+}
+/** True if `typeName` is a boolean type in any registered dialect (`bit`, `boolean`, `bool`). */
+export function IsBooleanSQLType(typeName) {
+    return BOOLEAN_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a variable / fixed-length character / text type. Excludes `uuid`. */
+export function IsStringSQLType(typeName) {
+    return STRING_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a date / time / timestamp type. */
+export function IsDateSQLType(typeName) {
+    return DATE_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is an integer type (any width, including auto-increment / rowversion). */
+export function IsIntegerSQLType(typeName) {
+    return INTEGER_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a floating-point or fixed-precision decimal type. */
+export function IsFloatSQLType(typeName) {
+    return FLOAT_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a UUID type (`uniqueidentifier`, `uuid`). */
+export function IsUuidSQLType(typeName) {
+    return UUID_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a binary blob type (`varbinary`, `image`, `bytea`). */
+export function IsBinarySQLType(typeName) {
+    return BINARY_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a JSON / XML structured-document type. */
+export function IsJsonSQLType(typeName) {
+    return JSON_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a fixed-precision currency type (`money`, `smallmoney`). */
+export function IsCurrencySQLType(typeName) {
+    return CURRENCY_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is an interval / duration type (`interval` — PG only currently). */
+export function IsIntervalSQLType(typeName) {
+    return INTERVAL_TYPE_SET.has(normalize(typeName));
+}
+/** True if `typeName` is a network address type (`inet`, `cidr`, …). */
+export function IsNetworkSQLType(typeName) {
+    return NETWORK_TYPE_SET.has(normalize(typeName));
+}
+/**
+ * Convenience aggregate: any "numeric" type — integer, float, or currency.
+ * Use when the call site doesn't care about the precision/scale distinction.
+ */
+export function IsNumericSQLType(typeName) {
+    const n = normalize(typeName);
+    return INTEGER_TYPE_SET.has(n) || FLOAT_TYPE_SET.has(n) || CURRENCY_TYPE_SET.has(n);
+}
+//# sourceMappingURL=typeClassification.js.map

dist/typeClassification.js.map

+{"version":3,"file":"typeClassification.js","sourceRoot":"","sources":["../src/typeClassification.ts"],"names":[],"mappings":"AAAA;;;;;;;;;;;;;;;;;;;;;;;;;GAyBG;AAGH,OAAO,EAAE,gBAAgB,EAAE,MAAM,uBAAuB,CAAC;AACzD,OAAO,EAAE,iBAAiB,EAAE,MAAM,wBAAwB,CAAC;AAE3D,MAAM,EAAE,GAAe,IAAI,gBAAgB,EAAE,CAAC;AAC9C,MAAM,EAAE,GAAe,IAAI,iBAAiB,EAAE,CAAC;AAE/C;;;;GAIG;AACH,MAAM,QAAQ,GAA0B,CAAC,EAAE,EAAE,EAAE,CAAC,CAAC;AAEjD;;;;GAIG;AACH,SAAS,cAAc,CAAC,MAA4C;IAChE,MAAM,GAAG,GAAG,IAAI,GAAG,EAAU,CAAC;IAC9B,KAAK,MAAM,OAAO,IAAI,QAAQ,EAAE,CAAC;QAC7B,KAAK,MAAM,IAAI,IAAI,MAAM,CAAC,OAAO,CAAC,EAAE,CAAC;YACjC,GAAG,CAAC,GAAG,CAAC,IAAI,CAAC,IAAI,EAAE,CAAC,WAAW,EAAE,CAAC,CAAC;QACvC,CAAC;IACL,CAAC;IACD,OAAO,GAAG,CAAC;AACf,CAAC;AAED,MAAM,gBAAgB,GAAK,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,gBAAgB,CAAC,CAAC;AACnE,MAAM,eAAe,GAAM,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC;AAClE,MAAM,aAAa,GAAQ,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,aAAa,CAAC,CAAC;AAChE,MAAM,gBAAgB,GAAK,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,gBAAgB,CAAC,CAAC;AACnE,MAAM,cAAc,GAAO,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,cAAc,CAAC,CAAC;AACjE,MAAM,aAAa,GAAQ,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,aAAa,CAAC,CAAC;AAChE,MAAM,eAAe,GAAM,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC;AAClE,MAAM,aAAa,GAAQ,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,aAAa,CAAC,CAAC;AAChE,MAAM,iBAAiB,GAAI,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,iBAAiB,CAAC,CAAC;AACpE,MAAM,iBAAiB,GAAI,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,iBAAiB,CAAC,CAAC;AACpE,MAAM,gBAAgB,GAAK,cAAc,CAAC,CAAC,CAAC,EAAE,CAAC,CAAC,CAAC,gBAAgB,CAAC,CAAC;AAEnE,SAAS,SAAS,CAAC,QAAmC;IAClD,OAAO,CAAC,QAAQ,IAAI,EAAE,CAAC,CAAC,IAAI,EAAE,CAAC,WAAW,EAAE,CAAC;AACjD,CAAC;AAED,iGAAiG;AACjG,MAAM,UAAU,gBAAgB,CAAC,QAAmC;IAChE,OAAO,gBAAgB,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACrD,CAAC;AAED,8FAA8F;AAC9F,MAAM,UAAU,eAAe,CAAC,QAAmC;IAC/D,OAAO,eAAe,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACpD,CAAC;AAED,4DAA4D;AAC5D,MAAM,UAAU,aAAa,CAAC,QAAmC;IAC7D,OAAO,aAAa,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AAClD,CAAC;AAED,gGAAgG;AAChG,MAAM,UAAU,gBAAgB,CAAC,QAAmC;IAChE,OAAO,gBAAgB,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACrD,CAAC;AAED,8EAA8E;AAC9E,MAAM,UAAU,cAAc,CAAC,QAAmC;IAC9D,OAAO,cAAc,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACnD,CAAC;AAED,sEAAsE;AACtE,MAAM,UAAU,aAAa,CAAC,QAAmC;IAC7D,OAAO,aAAa,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AAClD,CAAC;AAED,gFAAgF;AAChF,MAAM,UAAU,eAAe,CAAC,QAAmC;IAC/D,OAAO,eAAe,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACpD,CAAC;AAED,mEAAmE;AACnE,MAAM,UAAU,aAAa,CAAC,QAAmC;IAC7D,OAAO,aAAa,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AAClD,CAAC;AAED,qFAAqF;AACrF,MAAM,UAAU,iBAAiB,CAAC,QAAmC;IACjE,OAAO,iBAAiB,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACtD,CAAC;AAED,0FAA0F;AAC1F,MAAM,UAAU,iBAAiB,CAAC,QAAmC;IACjE,OAAO,iBAAiB,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACtD,CAAC;AAED,wEAAwE;AACxE,MAAM,UAAU,gBAAgB,CAAC,QAAmC;IAChE,OAAO,gBAAgB,CAAC,GAAG,CAAC,SAAS,CAAC,QAAQ,CAAC,CAAC,CAAC;AACrD,CAAC;AAED;;;GAGG;AACH,MAAM,UAAU,gBAAgB,CAAC,QAAmC;IAChE,MAAM,CAAC,GAAG,SAAS,CAAC,QAAQ,CAAC,CAAC;IAC9B,OAAO,gBAAgB,CAAC,GAAG,CAAC,CAAC,CAAC,IAAI,cAAc,CAAC,GAAG,CAAC,CAAC,CAAC,IAAI,iBAAiB,CAAC,GAAG,CAAC,CAAC,CAAC,CAAC;AACxF,CAAC"}

dist/index.d.ts

@@ -8,2 +8,3 @@ export { DataTypeMap, MappedType } from './dataTypeMap.js';
 export { GetDialect } from './dialectFactory.js';
+export { IsBooleanSQLType, IsStringSQLType, IsDateSQLType, IsIntegerSQLType, IsFloatSQLType, IsUuidSQLType, IsBinarySQLType, IsJsonSQLType, IsCurrencySQLType, IsIntervalSQLType, IsNetworkSQLType, IsNumericSQLType, } from './typeClassification.js';
 //# sourceMappingURL=index.d.ts.map

dist/index.d.ts.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"index.d.ts","sourceRoot":"","sources":["../src/index.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAE,UAAU,EAAE,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,GACrB,MAAM,iBAAiB,CAAC;AACzB,YAAY,EAAE,gBAAgB,EAAE,MAAM,iBAAiB,CAAC;AACxD,YAAY,EAAE,eAAe,EAAE,MAAM,iBAAiB,CAAC;AACvD,OAAO,EAAE,gBAAgB,EAAE,MAAM,uBAAuB,CAAC;AACzD,OAAO,EAAE,iBAAiB,EAAE,MAAM,wBAAwB,CAAC;AAC3D,OAAO,EAAE,UAAU,EAAE,MAAM,qBAAqB,CAAC"}
+{"version":3,"file":"index.d.ts","sourceRoot":"","sources":["../src/index.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAE,UAAU,EAAE,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,GACrB,MAAM,iBAAiB,CAAC;AACzB,YAAY,EAAE,gBAAgB,EAAE,MAAM,iBAAiB,CAAC;AACxD,YAAY,EAAE,eAAe,EAAE,MAAM,iBAAiB,CAAC;AACvD,OAAO,EAAE,gBAAgB,EAAE,MAAM,uBAAuB,CAAC;AACzD,OAAO,EAAE,iBAAiB,EAAE,MAAM,wBAAwB,CAAC;AAC3D,OAAO,EAAE,UAAU,EAAE,MAAM,qBAAqB,CAAC;AACjD,OAAO,EACH,gBAAgB,EAChB,eAAe,EACf,aAAa,EACb,gBAAgB,EAChB,cAAc,EACd,aAAa,EACb,eAAe,EACf,aAAa,EACb,iBAAiB,EACjB,iBAAiB,EACjB,gBAAgB,EAChB,gBAAgB,GACnB,MAAM,yBAAyB,CAAC"}

dist/index.js

@@ -5,2 +5,3 @@ export { SQLDialect, } from './sqlDialect.js';
 export { GetDialect } from './dialectFactory.js';
+export { IsBooleanSQLType, IsStringSQLType, IsDateSQLType, IsIntegerSQLType, IsFloatSQLType, IsUuidSQLType, IsBinarySQLType, IsJsonSQLType, IsCurrencySQLType, IsIntervalSQLType, IsNetworkSQLType, IsNumericSQLType, } from './typeClassification.js';
 //# sourceMappingURL=index.js.map

dist/index.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"index.js","sourceRoot":"","sources":["../src/index.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAGzB,OAAO,EAAE,gBAAgB,EAAE,MAAM,uBAAuB,CAAC;AACzD,OAAO,EAAE,iBAAiB,EAAE,MAAM,wBAAwB,CAAC;AAC3D,OAAO,EAAE,UAAU,EAAE,MAAM,qBAAqB,CAAC"}
+{"version":3,"file":"index.js","sourceRoot":"","sources":["../src/index.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAGzB,OAAO,EAAE,gBAAgB,EAAE,MAAM,uBAAuB,CAAC;AACzD,OAAO,EAAE,iBAAiB,EAAE,MAAM,wBAAwB,CAAC;AAC3D,OAAO,EAAE,UAAU,EAAE,MAAM,qBAAqB,CAAC;AACjD,OAAO,EACH,gBAAgB,EAChB,eAAe,EACf,aAAa,EACb,gBAAgB,EAChB,cAAc,EACd,aAAa,EACb,eAAe,EACf,aAAa,EACb,iBAAiB,EACjB,iBAAiB,EACjB,gBAAgB,EAChB,gBAAgB,GACnB,MAAM,yBAAyB,CAAC"}

dist/postgresqlDialect.d.ts

@@ -12,4 +12,13 @@ import { DataTypeMap } from './dataTypeMap.js';
     QuoteSchema(schema: string, object: string): string;
+    /**
+     * PostgreSQL folds unquoted identifiers to lowercase, which would turn
+     * `AS EntityName` into the result column `entityname`. Quoting the
+     * alias preserves the requested casing for callers that key off the
+     * column name (e.g. when consuming results into a TypeScript object
+     * with a PascalCase property).
+     */
+    QuoteColumnAlias(aliasName: string): string;
     LimitClause(limit: number, offset?: number): LimitClauseResult;
     BooleanLiteral(value: boolean): string;
+    BooleanParameterType(): string;
     /**
@@ -27,6 +36,11 @@ * PostgreSQL has no `ISNULL` keyword; the standard is `COALESCE` (which
     /**
-     * PostgreSQL function parameters use a `p_<snake_case_name>` convention
-     * (no `@`-prefix syntax in PG). The snake-case transform converts the
-     * canonical PascalCase identifier MJ uses everywhere into PG's preferred
-     * shape — e.g. `MyParam` → `p_my_param`.
+     * PostgreSQL function parameters use a `p_<flat lowercase>` convention
+     * (no `@`-prefix syntax in PG). This matches the baseline-ported SP names
+     * (which lowercased SQL Server's PascalCase parameter names without
+     * separators — e.g. `@CompanyID` → `p_companyid`) and the runtime
+     * PostgreSQLDataProvider, which calls procs with `p_${field.Name.toLowerCase()}`.
+     *
+     * Earlier this used a snake_case transform (`p_company_id`), which
+     * produced functions the runtime could never invoke. Underscores already
+     * in the input (e.g. the `_Clear` companion suffix) are preserved.
      */
@@ -39,4 +53,35 @@ ParameterRef(name: string): string;
     CurrentTimestampUTC(): string;
+    private static readonly _BooleanTypeNames;
+    private static readonly _StringTypeNames;
+    private static readonly _DateTypeNames;
+    private static readonly _IntegerTypeNames;
+    private static readonly _FloatTypeNames;
+    private static readonly _UuidTypeNames;
+    private static readonly _BinaryTypeNames;
+    private static readonly _JsonTypeNames;
+    private static readonly _CurrencyTypeNames;
+    private static readonly _IntervalTypeNames;
+    private static readonly _NetworkTypeNames;
+    get BooleanTypeNames(): readonly string[];
+    get StringTypeNames(): readonly string[];
+    get DateTypeNames(): readonly string[];
+    get IntegerTypeNames(): readonly string[];
+    get FloatTypeNames(): readonly string[];
+    get UuidTypeNames(): readonly string[];
+    get BinaryTypeNames(): readonly string[];
+    get JsonTypeNames(): readonly string[];
+    get CurrencyTypeNames(): readonly string[];
+    get IntervalTypeNames(): readonly string[];
+    get NetworkTypeNames(): readonly string[];
     NewUUID(): string;
     CastToText(expr: string): string;
+    /**
+     * PostgreSQL-specific Flyway escape. PostgreSQL string concatenation uses
+     * `||` (not `+`), and TEXT has no length cap — so a simple split with `||`
+     * suffices and no cast-to-MAX dance is needed (unlike SQL Server, which
+     * silently truncates `NVARCHAR(N) + NVARCHAR(M)` past 4,000 chars).
+     * PostgreSQL string literals don't take an `N` prefix either; everything
+     * is already Unicode.
+     */
+    EscapeFlywayStringInterpolation(sql: string): string;
     CastToUUID(expr: string): string;
@@ -43,0 +88,0 @@ /**

dist/postgresqlDialect.d.ts.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"postgresqlDialect.d.ts","sourceRoot":"","sources":["../src/postgresqlDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAc,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,EACrB,MAAM,iBAAiB,CAAC;AAwIzB;;;GAGG;AACH,qBAAa,iBAAkB,SAAQ,UAAU;IAC7C,IAAI,WAAW,IAAI,gBAAgB,CAElC;IAED,IAAI,aAAa,IAAI,MAAM,CAE1B;IAID,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIrC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAMnD,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAU9D,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAItC;;;;OAIG;IACH,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI9C;;;OAGG;IACH,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAIhD;;;;;OAKG;IACH,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IASlC;;OAEG;IACH,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAIvC,mBAAmB,IAAI,MAAM;IAI7B,OAAO,IAAI,MAAM;IAIjB,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC;;;;OAIG;IACH,gBAAgB,IAAI,MAAM;IAM1B,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAQhD,yBAAyB,IAAI,MAAM;IAInC,aAAa,IAAI,MAAM;IAIvB,uBAAuB,IAAI,MAAM;IAIjC,kBAAkB,IAAI,MAAM;IAO5B,cAAc,IAAI,MAAM;IAIxB,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAkB3E,wBAAwB,CAAC,UAAU,EAAE,MAAM,GAAG,OAAO;IAOrD,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAInE,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,QAAQ,CAAC,EAAE,MAAM,GAAG,MAAM;IAkC7E,kBAAkB,IAAI,MAAM;IAI5B,IAAI,kBAAkB,IAAI,OAAO,CAEhC;IAED,IAAI,oBAAoB,IAAI,MAAM,CAEjC;IAID,IAAI,OAAO,IAAI,WAAW,CAEzB;IAID,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAI3C,cAAc,IAAI,MAAM;IAMxB,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAI7D,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAOjD,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAO3E,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAM3C,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAK5F,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IASxF,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAgB9E,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAMvC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAM9C,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAQxE,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAKvF,YAAY,IAAI,MAAM;IAMtB,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAwB3C,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAavC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,WAAW,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI9G,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAQ1F,0BAA0B,IAAI,sBAAsB;IAgEpD,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAMjE,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IA+BxD,OAAO,CAAC,iBAAiB;IASzB,OAAO,CAAC,aAAa;IAMrB,OAAO,CAAC,WAAW;CAKtB"}
+{"version":3,"file":"postgresqlDialect.d.ts","sourceRoot":"","sources":["../src/postgresqlDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAc,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,EACrB,MAAM,iBAAiB,CAAC;AAwIzB;;;GAGG;AACH,qBAAa,iBAAkB,SAAQ,UAAU;IAC7C,IAAI,WAAW,IAAI,gBAAgB,CAElC;IAED,IAAI,aAAa,IAAI,MAAM,CAE1B;IAID,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIrC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAInD;;;;;;OAMG;IACH,gBAAgB,CAAC,SAAS,EAAE,MAAM,GAAG,MAAM;IAM3C,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAU9D,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAItC,oBAAoB,IAAI,MAAM;IAI9B;;;;OAIG;IACH,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI9C;;;OAGG;IACH,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAIhD;;;;;;;;;;OAUG;IACH,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIlC;;OAEG;IACH,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAIvC,mBAAmB,IAAI,MAAM;IAW7B,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAAgC;IACzE,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,gBAAgB,CAAsG;IAC9I,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAqK;IAC3M,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAA0H;IACnK,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,eAAe,CAAmF;IAC1H,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAqB;IAC3D,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,gBAAgB,CAAsB;IAC9D,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAqC;IAC3E,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,kBAAkB,CAAsB;IAChE,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,kBAAkB,CAAyB;IACnE,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAAoD;IAE7F,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAiD;IAC1F,IAAI,eAAe,IAAI,SAAS,MAAM,EAAE,CAAiD;IACzF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAiD;IACvF,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAiD;IAC1F,IAAI,cAAc,IAAI,SAAS,MAAM,EAAE,CAAiD;IACxF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAiD;IACvF,IAAI,eAAe,IAAI,SAAS,MAAM,EAAE,CAAiD;IACzF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAiD;IACvF,IAAI,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAiD;IAC3F,IAAI,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAiD;IAC3F,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAiD;IAE1F,OAAO,IAAI,MAAM;IAIjB,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC;;;;;;;OAOG;IACH,+BAA+B,CAAC,GAAG,EAAE,MAAM,GAAG,MAAM;IAIpD,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC;;;;OAIG;IACH,gBAAgB,IAAI,MAAM;IAM1B,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAQhD,yBAAyB,IAAI,MAAM;IAInC,aAAa,IAAI,MAAM;IAIvB,uBAAuB,IAAI,MAAM;IAIjC,kBAAkB,IAAI,MAAM;IAO5B,cAAc,IAAI,MAAM;IAIxB,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAkB3E,wBAAwB,CAAC,UAAU,EAAE,MAAM,GAAG,OAAO;IAOrD,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAInE,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,QAAQ,CAAC,EAAE,MAAM,GAAG,MAAM;IAkC7E,kBAAkB,IAAI,MAAM;IAI5B,IAAI,kBAAkB,IAAI,OAAO,CAEhC;IAED,IAAI,oBAAoB,IAAI,MAAM,CAEjC;IAID,IAAI,OAAO,IAAI,WAAW,CAEzB;IAID,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAI3C,cAAc,IAAI,MAAM;IAMxB,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAI7D,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAOjD,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAO3E,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAM3C,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAK5F,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IASxF,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAgB9E,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAMvC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAM9C,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAQxE,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAKvF,YAAY,IAAI,MAAM;IAMtB,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAwB3C,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAavC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,WAAW,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI9G,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAQ1F,0BAA0B,IAAI,sBAAsB;IAgEpD,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAMjE,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IA+BxD,OAAO,CAAC,iBAAiB;IASzB,OAAO,CAAC,aAAa;IAMrB,OAAO,CAAC,WAAW;CAKtB"}

dist/postgresqlDialect.js

@@ -147,2 +147,12 @@ import { SQLDialect, } from './sqlDialect.js';
     }
+    /**
+     * PostgreSQL folds unquoted identifiers to lowercase, which would turn
+     * `AS EntityName` into the result column `entityname`. Quoting the
+     * alias preserves the requested casing for callers that key off the
+     * column name (e.g. when consuming results into a TypeScript object
+     * with a PascalCase property).
+     */
+    QuoteColumnAlias(aliasName) {
+        return `"${aliasName}"`;
+    }
     // ─── Pagination ──────────────────────────────────────────────────
@@ -160,2 +170,5 @@ LimitClause(limit, offset) {
     }
+    BooleanParameterType() {
+        return 'boolean';
+    }
     /**
@@ -177,14 +190,14 @@ * PostgreSQL has no `ISNULL` keyword; the standard is `COALESCE` (which
     /**
-     * PostgreSQL function parameters use a `p_<snake_case_name>` convention
-     * (no `@`-prefix syntax in PG). The snake-case transform converts the
-     * canonical PascalCase identifier MJ uses everywhere into PG's preferred
-     * shape — e.g. `MyParam` → `p_my_param`.
+     * PostgreSQL function parameters use a `p_<flat lowercase>` convention
+     * (no `@`-prefix syntax in PG). This matches the baseline-ported SP names
+     * (which lowercased SQL Server's PascalCase parameter names without
+     * separators — e.g. `@CompanyID` → `p_companyid`) and the runtime
+     * PostgreSQLDataProvider, which calls procs with `p_${field.Name.toLowerCase()}`.
+     *
+     * Earlier this used a snake_case transform (`p_company_id`), which
+     * produced functions the runtime could never invoke. Underscores already
+     * in the input (e.g. the `_Clear` companion suffix) are preserved.
      */
     ParameterRef(name) {
-        const snake = name
-            .replace(/([a-z0-9])([A-Z])/g, '$1_$2')
-            .replace(/([A-Z]+)([A-Z][a-z])/g, '$1_$2')
-            .toLowerCase()
-            .replace(/__+/g, '_');
-        return `p_${snake}`;
+        return `p_${name.toLowerCase()}`;
     }
@@ -200,2 +213,30 @@ /**
     }
+    // ─── Type-Name Sets ──────────────────────────────────────────────
+    // PostgreSQL's column-type names as they appear in `pg_catalog` /
+    // `information_schema` / `EntityField.Type` for entities backed by PG.
+    // Includes both the formal name (`character varying`) and the internal
+    // / short alias (`varchar`, `bpchar`) since both surface depending on
+    // the metadata source.
+    static { this._BooleanTypeNames = ['bool', 'boolean']; }
+    static { this._StringTypeNames = ['text', 'varchar', 'char', 'character', 'character varying', 'bpchar', 'citext', 'name']; }
+    static { this._DateTypeNames = ['date', 'time', 'time without time zone', 'time with time zone', 'timestamp', 'timestamptz', 'timestamp with time zone', 'timestamp without time zone']; }
+    static { this._IntegerTypeNames = ['int', 'int2', 'int4', 'int8', 'integer', 'bigint', 'smallint', 'serial', 'bigserial', 'smallserial', 'oid']; }
+    static { this._FloatTypeNames = ['decimal', 'numeric', 'real', 'double precision', 'float4', 'float8']; }
+    static { this._UuidTypeNames = ['uuid']; }
+    static { this._BinaryTypeNames = ['bytea']; }
+    static { this._JsonTypeNames = ['json', 'jsonb', 'xml']; }
+    static { this._CurrencyTypeNames = ['money']; }
+    static { this._IntervalTypeNames = ['interval']; }
+    static { this._NetworkTypeNames = ['inet', 'cidr', 'macaddr', 'macaddr8']; }
+    get BooleanTypeNames() { return PostgreSQLDialect._BooleanTypeNames; }
+    get StringTypeNames() { return PostgreSQLDialect._StringTypeNames; }
+    get DateTypeNames() { return PostgreSQLDialect._DateTypeNames; }
+    get IntegerTypeNames() { return PostgreSQLDialect._IntegerTypeNames; }
+    get FloatTypeNames() { return PostgreSQLDialect._FloatTypeNames; }
+    get UuidTypeNames() { return PostgreSQLDialect._UuidTypeNames; }
+    get BinaryTypeNames() { return PostgreSQLDialect._BinaryTypeNames; }
+    get JsonTypeNames() { return PostgreSQLDialect._JsonTypeNames; }
+    get CurrencyTypeNames() { return PostgreSQLDialect._CurrencyTypeNames; }
+    get IntervalTypeNames() { return PostgreSQLDialect._IntervalTypeNames; }
+    get NetworkTypeNames() { return PostgreSQLDialect._NetworkTypeNames; }
     NewUUID() {
@@ -207,2 +248,13 @@ return 'gen_random_uuid()';
     }
+    /**
+     * PostgreSQL-specific Flyway escape. PostgreSQL string concatenation uses
+     * `||` (not `+`), and TEXT has no length cap — so a simple split with `||`
+     * suffices and no cast-to-MAX dance is needed (unlike SQL Server, which
+     * silently truncates `NVARCHAR(N) + NVARCHAR(M)` past 4,000 chars).
+     * PostgreSQL string literals don't take an `N` prefix either; everything
+     * is already Unicode.
+     */
+    EscapeFlywayStringInterpolation(sql) {
+        return sql.replaceAll(/\$\{/g, "$$'||'{");
+    }
     CastToUUID(expr) {
@@ -209,0 +261,0 @@ return `CAST(${expr} AS UUID)`;

dist/postgresqlDialect.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"postgresqlDialect.js","sourceRoot":"","sources":["../src/postgresqlDialect.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAEzB;;;GAGG;AACH,MAAM,qBAAqB;IACvB,OAAO,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QAC7F,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC,IAAI,EAAE,CAAC;QAEnD,QAAQ,UAAU,EAAE,CAAC;YACjB,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU;gBACX,OAAO,IAAI,CAAC,WAAW,CAAC,YAAY,CAAC,CAAC;YAC1C,KAAK,SAAS;gBACV,OAAO,IAAI,CAAC,UAAU,CAAC,YAAY,CAAC,CAAC;YACzC,KAAK,OAAO,CAAC;YACb,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YACvH,KAAK,KAAK,CAAC;YACX,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,SAAS,CAAC;YACf,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,IAAI,EAAE,CAAC;YACxF,KAAK,OAAO;gBACR,OAAO,IAAI,CAAC,QAAQ,CAAC,eAAe,CAAC,CAAC;YAC1C,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,YAAY;gBACb,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU,CAAC;YAChB,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,gBAAgB;gBACjB,OAAO,EAAE,QAAQ,EAAE,aAAa,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC7F,KAAK,eAAe;gBAChB,OAAO,EAAE,QAAQ,EAAE,cAAc,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC9F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,MAAM,CAAC;YACZ,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,yCAAyC;YACzC,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,aAAa;gBACd,OAAO,EAAE,QAAQ,EAAE,aAAa,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC7F,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAClG;gBACI,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;IACL,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QACrG,MAAM,MAAM,GAAG,IAAI,CAAC,OAAO,CAAC,UAAU,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;QACpF,OAAO,gBAAgB,CAAC,MAAM,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;IAChF,CAAC;IAEO,WAAW,CAAC,MAAe;QAC/B,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;IAEO,UAAU,CAAC,MAAe;QAC9B,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;IAEO,QAAQ,CAAC,SAAkB;QAC/B,iEAAiE;QACjE,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,IAAI,EAAE,EAAE,CAAC;YACvC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;IAClG,CAAC;CACJ;AAED;;GAEG;AACH,SAAS,gBAAgB,CAAC,MAAkB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;IAC7F,IAAI,MAAM,CAAC,sBAAsB,IAAI,SAAS,IAAI,IAAI,EAAE,CAAC;QACrD,OAAO,KAAK,IAAI,IAAI;YAChB,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,IAAI,KAAK,GAAG;YAC7C,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,GAAG,CAAC;IAC7C,CAAC;IACD,IAAI,MAAM,CAAC,cAAc,EAAE,CAAC;QACxB,MAAM,GAAG,GAAG,MAAM,IAAI,MAAM,CAAC,aAAa,CAAC;QAC3C,IAAI,GAAG,IAAI,IAAI,EAAE,CAAC;YACd,OAAO,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,GAAG,GAAG,CAAC;QAC9D,CAAC;IACL,CAAC;IACD,OAAO,MAAM,CAAC,QAAQ,CAAC;AAC3B,CAAC;AAED;;;GAGG;AACH,MAAM,OAAO,iBAAkB,SAAQ,UAAU;IAC7C,IAAI,WAAW;QACX,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,IAAI,aAAa;QACb,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,IAAY;QACxB,OAAO,IAAI,IAAI,GAAG,CAAC;IACvB,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,MAAc;QACtC,OAAO,GAAG,MAAM,KAAK,MAAM,GAAG,CAAC;IACnC,CAAC;IAED,oEAAoE;IAEpE,WAAW,CAAC,KAAa,EAAE,MAAe;QACtC,MAAM,KAAK,GAAG,CAAC,SAAS,KAAK,EAAE,CAAC,CAAC;QACjC,IAAI,MAAM,IAAI,IAAI,EAAE,CAAC;YACjB,KAAK,CAAC,IAAI,CAAC,UAAU,MAAM,EAAE,CAAC,CAAC;QACnC,CAAC;QACD,OAAO,EAAE,MAAM,EAAE,EAAE,EAAE,MAAM,EAAE,KAAK,CAAC,IAAI,CAAC,GAAG,CAAC,EAAE,CAAC;IACnD,CAAC;IAED,oEAAoE;IAEpE,cAAc,CAAC,KAAc;QACzB,OAAO,KAAK,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,OAAO,CAAC;IACpC,CAAC;IAED;;;;OAIG;IACH,MAAM,CAAC,IAAY,EAAE,QAAgB;QACjC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED;;;OAGG;IACH,QAAQ,CAAC,IAAY,EAAE,QAAgB;QACnC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED;;;;;OAKG;IACH,YAAY,CAAC,IAAY;QACrB,MAAM,KAAK,GAAG,IAAI;aACb,OAAO,CAAC,oBAAoB,EAAE,OAAO,CAAC;aACtC,OAAO,CAAC,uBAAuB,EAAE,OAAO,CAAC;aACzC,WAAW,EAAE;aACb,OAAO,CAAC,MAAM,EAAE,GAAG,CAAC,CAAC;QAC1B,OAAO,KAAK,KAAK,EAAE,CAAC;IACxB,CAAC;IAED;;OAEG;IACH,gBAAgB,CAAC,KAAa;QAC1B,OAAO,YAAY,KAAK,EAAE,CAAC;IAC/B,CAAC;IAED,mBAAmB;QACf,OAAO,4BAA4B,CAAC;IACxC,CAAC;IAED,OAAO;QACH,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,WAAW,CAAC;IACnC,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,WAAW,CAAC;IACnC,CAAC;IAED;;;;OAIG;IACH,gBAAgB;QACZ,OAAO,GAAG,KAAK,CAAC,gBAAgB,EAAE,QAAQ,CAAC;IAC/C,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,OAAkB;QACnC,IAAI,OAAO,IAAI,OAAO,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAChC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YACnD,OAAO,aAAa,IAAI,EAAE,CAAC;QAC/B,CAAC;QACD,OAAO,aAAa,CAAC;IACzB,CAAC;IAED,yBAAyB;QACrB,OAAO,8BAA8B,CAAC;IAC1C,CAAC;IAED,aAAa;QACT,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,uBAAuB;QACnB,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,kBAAkB;QACd,yDAAyD;QACzD,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,oEAAoE;IAEpE,cAAc;QACV,OAAO,EAAE,CAAC,CAAC,4CAA4C;IAC3D,CAAC;IAED,iBAAiB,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY;QAC9D,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,QAAQ,cAAc,EAAE,CAAC;YACrB,KAAK,OAAO;gBACR,OAAO,yEAAyE,MAAM,sBAAsB,IAAI,IAAI,CAAC;YACzH,KAAK,MAAM;gBACP,OAAO,wEAAwE,MAAM,qBAAqB,IAAI,IAAI,CAAC;YACvH,KAAK,UAAU;gBACX,OAAO,iIAAiI,MAAM,sBAAsB,IAAI,IAAI,CAAC;YACjL,KAAK,WAAW;gBACZ,OAAO,iIAAiI,MAAM,sBAAsB,IAAI,wBAAwB,CAAC;YACrM,KAAK,SAAS;gBACV,OAAO,sEAAsE,IAAI,IAAI,CAAC;YAC1F;gBACI,OAAO,kIAAkI,MAAM,sBAAsB,IAAI,IAAI,CAAC;QACtL,CAAC;IACL,CAAC;IAED,wBAAwB,CAAC,UAAkB;QACvC,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAC5C,OAAO,UAAU,KAAK,UAAU,IAAI,UAAU,KAAK,MAAM,IAAI,UAAU,KAAK,WAAW,CAAC;IAC5F,CAAC;IAED,oEAAoE;IAEpE,uBAAuB,CAAC,MAAc,EAAE,UAAkB;QACtD,OAAO,GAAG,MAAM,kCAAkC,UAAU,GAAG,CAAC;IACpE,CAAC;IAED,gBAAgB,CAAC,KAAa,EAAE,OAAiB,EAAE,QAAiB;QAChE,MAAM,OAAO,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACtD,MAAM,UAAU,GAAG,KAAK,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;QAC3C,MAAM,WAAW,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC1D,MAAM,KAAK,GAAa,EAAE,CAAC;QAE3B,sBAAsB;QACtB,KAAK,CAAC,IAAI,CAAC,eAAe,KAAK,qDAAqD,CAAC,CAAC;QACtF,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,0CAA0C;QAC1C,KAAK,CAAC,IAAI,CAAC,sCAAsC,UAAU,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,OAAO,KAAK,8BAA8B,CAAC,CAAC;QAC3H,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,wBAAwB;QACxB,KAAK,CAAC,IAAI,CAAC,8BAA8B,IAAI,CAAC,aAAa,CAAC,KAAK,CAAC,eAAe,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,IAAI,CAAC,CAAC;QAC9G,KAAK,CAAC,IAAI,CAAC,uBAAuB,CAAC,CAAC;QACpC,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,qDAAqD,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,iBAAiB,CAAC,QAAQ,CAAC,CAAC,IAAI,CAAC,aAAa,CAAC,IAAI,CAAC,CAAC;QACtI,KAAK,CAAC,IAAI,CAAC,iBAAiB,CAAC,CAAC;QAC9B,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QACnB,KAAK,CAAC,IAAI,CAAC,sBAAsB,CAAC,CAAC;QACnC,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,KAAK,CAAC,IAAI,CAAC,kCAAkC,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,OAAO,KAAK,GAAG,CAAC,CAAC;QACrF,KAAK,CAAC,IAAI,CAAC,0BAA0B,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,EAAE,CAAC,CAAC;QAChE,KAAK,CAAC,IAAI,CAAC,kCAAkC,KAAK,EAAE,CAAC,CAAC;QACtD,KAAK,CAAC,IAAI,CAAC,qCAAqC,IAAI,CAAC,aAAa,CAAC,KAAK,CAAC,eAAe,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,KAAK,CAAC,CAAC;QAEtH,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,oEAAoE;IAEpE,kBAAkB;QACd,OAAO,gBAAgB,CAAC;IAC5B,CAAC;IAED,IAAI,kBAAkB;QAClB,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,IAAI,oBAAoB;QACpB,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,IAAI,OAAO;QACP,OAAO,IAAI,qBAAqB,EAAE,CAAC;IACvC,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,KAAa;QAC9B,OAAO,IAAI,KAAK,GAAG,CAAC,EAAE,CAAC,CAAC,mCAAmC;IAC/D,CAAC;IAED,cAAc;QACV,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,KAAa,EAAE,SAAiB;QAChD,OAAO,0BAA0B,KAAK,KAAK,SAAS,IAAI,CAAC;IAC7D,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,IAAY;QACpC,gDAAgD;QAChD,OAAO,GAAG,MAAM,OAAO,IAAI,GAAG,CAAC;IACnC,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,MAAc,EAAE,IAAY,EAAE,MAAgB;QAC9D,MAAM,SAAS,GAAG,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACpC,OAAO,iBAAiB,MAAM,KAAK,IAAI,KAAK,SAAS,GAAG,CAAC;IAC7D,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,UAAkB;QAC9B,OAAO,gCAAgC,UAAU,IAAI,CAAC;IAC1D,CAAC;IAED,mEAAmE;IAEnE,iBAAiB,CAAC,IAA+B,EAAE,MAAc,EAAE,QAAgB;QAC/E,MAAM,MAAM,GAAG,IAAI,CAAC,WAAW,EAAE,GAAG,GAAG,CAAC,CAAC,gDAAgD;QACzF,OAAO,GAAG,QAAQ,gBAAgB,MAAM,IAAI,MAAM,GAAG,CAAC;IAC1D,CAAC;IAED,yBAAyB,CAAC,MAAc,EAAE,SAAiB,EAAE,UAAkB;QAC3E,MAAM,WAAW,GAAG,IAAI,CAAC,WAAW,CAAC,MAAM,EAAE,SAAS,CAAC,CAAC;QACxD,OAAO;YACH,8BAA8B,WAAW,IAAI;YAC7C,UAAU;YACV,IAAI;SACP,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,gBAAgB,CAAC,SAAiB,EAAE,OAAe,EAAE,OAAgB;QACjE,MAAM,KAAK,GAAG;YACV,OAAO;YACP,OAAO;YACP,QAAQ,SAAS,OAAO;YACxB,OAAO,OAAO,GAAG;SACpB,CAAC;QACF,IAAI,OAAO,EAAE,CAAC;YACV,KAAK,CAAC,IAAI,CAAC,QAAQ,CAAC,CAAC;YACrB,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,GAAG,CAAC,CAAC;QAClC,CAAC;QACD,KAAK,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC;QACxB,KAAK,CAAC,IAAI,CAAC,SAAS,CAAC,CAAC;QACtB,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,cAAc,CAAC,OAAe;QAC1B,OAAO,iBAAiB,OAAO,GAAG,CAAC;IACvC,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,GAAqB;QACjC,MAAM,QAAQ,GAAG,GAAG,CAAC,QAAQ,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QACpD,MAAM,WAAW,GAAG,GAAG,CAAC,YAAY,IAAI,IAAI,CAAC,CAAC,CAAC,YAAY,GAAG,CAAC,YAAY,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QACnF,OAAO,eAAe,GAAG,CAAC,IAAI,KAAK,GAAG,CAAC,OAAO,IAAI,QAAQ,GAAG,WAAW,EAAE,CAAC;IAC/E,CAAC;IAED,cAAc,CAAC,WAAmB,EAAE,OAA2B;QAC3D,OAAO,CACH,eAAe,WAAW,IAAI;YAC9B,qBAAqB,OAAO,CAAC,UAAU,UAAU,OAAO,CAAC,OAAO,KAAK;YACrE,qBAAqB,OAAO,CAAC,UAAU,KAAK,OAAO,CAAC,WAAW,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC,CAAC,cAAc,GAAG,CACxG,CAAC;IACN,CAAC;IAED,eAAe,CAAC,MAAc,EAAE,KAAa,EAAE,MAAc,EAAE,OAAe;QAC1E,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QAC5C,OAAO,sBAAsB,MAAM,MAAM,KAAK,MAAM,MAAM,SAAS,OAAO,IAAI,CAAC;IACnF,CAAC;IAED,YAAY;QACR,OAAO,MAAM,CAAC;IAClB,CAAC;IAED,mEAAmE;IAEnE,UAAU,CAAC,OAAuB;QAC9B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QAC3C,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,IAAI,KAAK,CAAC;QACzC,MAAM,QAAQ,GAAG,OAAO,CAAC,YAAY,IAAI,MAAM,OAAO,CAAC,WAAW,EAAE,CAAC;QACrE,MAAM,KAAK,GAAa,EAAE,CAAC;QAE3B,mDAAmD;QACnD,KAAK,CAAC,IAAI,CAAC,8BAA8B,OAAO,CAAC,MAAM,KAAK,QAAQ,KAAK,CAAC,CAAC;QAC3E,KAAK,CAAC,IAAI,CAAC,uBAAuB,CAAC,CAAC;QACpC,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QACnB,KAAK,CAAC,IAAI,CAAC,sBAAsB,CAAC,CAAC;QACnC,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,KAAK,CAAC,IAAI,CAAC,2BAA2B,OAAO,CAAC,WAAW,QAAQ,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,IAAI,CAAC,CAAC;QAC3G,KAAK,CAAC,IAAI,CAAC,mBAAmB,OAAO,CAAC,WAAW,GAAG,CAAC,CAAC;QACtD,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,MAAM,IAAI,MAAM,OAAO,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,GAAG,CAAC,CAAC;QAC1F,KAAK,CAAC,IAAI,CAAC,gBAAgB,OAAO,EAAE,CAAC,CAAC;QACtC,KAAK,CAAC,IAAI,CAAC,wBAAwB,OAAO,CAAC,MAAM,KAAK,QAAQ,MAAM,CAAC,CAAC;QAEtE,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,QAAQ,CAAC,OAAqB;QAC1B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,EAAE,CAAC;QAC/C,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,OAAO,CAAC,MAAM,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QAChE,MAAM,IAAI,GAAG,OAAO,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC3D,IAAI,GAAG,GAAG,UAAU,MAAM,wBAAwB,OAAO,CAAC,SAAS,QAAQ,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,IAAI,MAAM,IAAI,IAAI,GAAG,CAAC;QACrI,IAAI,OAAO,CAAC,KAAK,EAAE,CAAC;YAChB,GAAG,IAAI,UAAU,OAAO,CAAC,KAAK,EAAE,CAAC;QACrC,CAAC;QACD,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,UAAkB,EAAE,WAAmB,EAAE,MAAc,EAAE,MAAc,EAAE,IAAY;QACjG,OAAO,SAAS,UAAU,OAAO,MAAM,KAAK,MAAM,SAAS,IAAI,GAAG,CAAC;IACvE,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY,EAAE,OAAe;QAC7E,MAAM,cAAc,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QACnD,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,OAAO,cAAc,cAAc,IAAI,MAAM,KAAK,IAAI,SAAS,cAAc,GAAG,CAAC;IACrF,CAAC;IAED,oEAAoE;IAEpE,0BAA0B;QACtB,OAAO;YACH,UAAU,EAAE;;;;mCAIW;YACvB,WAAW,EAAE;;;;;;;4CAOmB;YAChC,eAAe,EAAE;;;;;;kEAMqC;YACtD,eAAe,EAAE;;;;;;;;;;;;;;;4CAee;YAChC,WAAW,EAAE;;;;;;;;;;;;;;mCAcU;YACvB,YAAY,EAAE;;;;;4BAKE;SACnB,CAAC;IACN,CAAC;IAED,oEAAoE;IAEpE,GAAG,CAAC,SAAiB,EAAE,OAAe,EAAE,QAAgB;QACpD,OAAO,aAAa,SAAS,SAAS,OAAO,SAAS,QAAQ,MAAM,CAAC;IACzE,CAAC;IAED,qEAAqE;IAErE,mBAAmB,CAAC,OAA2B;QAC3C,QAAQ,OAAO,CAAC,IAAI,EAAE,CAAC;YACnB,KAAK,QAAQ;gBACT,OAAO,IAAI,CAAC,iBAAiB,CAAC,OAAO,CAAC,SAAS,CAAC,CAAC;YACrD,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,SAAS;gBACV,OAAO,SAAS,CAAC;YACrB,KAAK,QAAQ;gBACT,OAAO,QAAQ,CAAC;YACpB,KAAK,SAAS;gBACV,OAAO,WAAW,OAAO,CAAC,SAAS,IAAI,EAAE,IAAI,OAAO,CAAC,KAAK,IAAI,CAAC,GAAG,CAAC;YACvE,KAAK,SAAS;gBACV,OAAO,SAAS,CAAC;YACrB,KAAK,UAAU;gBACX,OAAO,aAAa,CAAC;YACzB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,OAAO,CAAC;YACnB,KAAK,OAAO;gBACR,OAAO,kBAAkB,CAAC;YAC9B,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB;gBACI,OAAO,IAAI,CAAC,YAAY,EAAE,CAAC;QACnC,CAAC;IACL,CAAC;IAEO,iBAAiB,CAAC,SAAkB;QACxC,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,GAAG,CAAC,EAAE,CAAC;YACrC,OAAO,WAAW,SAAS,GAAG,CAAC;QACnC,CAAC;QACD,OAAO,cAAc,CAAC;IAC1B,CAAC;IAED,oEAAoE;IAE5D,aAAa,CAAC,aAAqB;QACvC,MAAM,QAAQ,GAAG,aAAa,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC;QAC5C,IAAI,QAAQ,KAAK,CAAC,CAAC;YAAE,OAAO,QAAQ,CAAC;QACrC,OAAO,aAAa,CAAC,SAAS,CAAC,CAAC,EAAE,QAAQ,CAAC,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;IAClE,CAAC;IAEO,WAAW,CAAC,aAAqB;QACrC,MAAM,QAAQ,GAAG,aAAa,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC;QAC5C,IAAI,QAAQ,KAAK,CAAC,CAAC;YAAE,OAAO,aAAa,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;QAC5D,OAAO,aAAa,CAAC,SAAS,CAAC,QAAQ,GAAG,CAAC,CAAC,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;IACnE,CAAC;CACJ"}
+{"version":3,"file":"postgresqlDialect.js","sourceRoot":"","sources":["../src/postgresqlDialect.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAEzB;;;GAGG;AACH,MAAM,qBAAqB;IACvB,OAAO,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QAC7F,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC,IAAI,EAAE,CAAC;QAEnD,QAAQ,UAAU,EAAE,CAAC;YACjB,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU;gBACX,OAAO,IAAI,CAAC,WAAW,CAAC,YAAY,CAAC,CAAC;YAC1C,KAAK,SAAS;gBACV,OAAO,IAAI,CAAC,UAAU,CAAC,YAAY,CAAC,CAAC;YACzC,KAAK,OAAO,CAAC;YACb,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YACvH,KAAK,KAAK,CAAC;YACX,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,SAAS,CAAC;YACf,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,IAAI,EAAE,CAAC;YACxF,KAAK,OAAO;gBACR,OAAO,IAAI,CAAC,QAAQ,CAAC,eAAe,CAAC,CAAC;YAC1C,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,YAAY;gBACb,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU,CAAC;YAChB,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,gBAAgB;gBACjB,OAAO,EAAE,QAAQ,EAAE,aAAa,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC7F,KAAK,eAAe;gBAChB,OAAO,EAAE,QAAQ,EAAE,cAAc,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC9F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,MAAM,CAAC;YACZ,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,yCAAyC;YACzC,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,aAAa;gBACd,OAAO,EAAE,QAAQ,EAAE,aAAa,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC7F,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAClG;gBACI,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;IACL,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QACrG,MAAM,MAAM,GAAG,IAAI,CAAC,OAAO,CAAC,UAAU,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;QACpF,OAAO,gBAAgB,CAAC,MAAM,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;IAChF,CAAC;IAEO,WAAW,CAAC,MAAe;QAC/B,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;IAEO,UAAU,CAAC,MAAe;QAC9B,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;IAEO,QAAQ,CAAC,SAAkB;QAC/B,iEAAiE;QACjE,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,IAAI,EAAE,EAAE,CAAC;YACvC,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QACtF,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;IAClG,CAAC;CACJ;AAED;;GAEG;AACH,SAAS,gBAAgB,CAAC,MAAkB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;IAC7F,IAAI,MAAM,CAAC,sBAAsB,IAAI,SAAS,IAAI,IAAI,EAAE,CAAC;QACrD,OAAO,KAAK,IAAI,IAAI;YAChB,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,IAAI,KAAK,GAAG;YAC7C,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,GAAG,CAAC;IAC7C,CAAC;IACD,IAAI,MAAM,CAAC,cAAc,EAAE,CAAC;QACxB,MAAM,GAAG,GAAG,MAAM,IAAI,MAAM,CAAC,aAAa,CAAC;QAC3C,IAAI,GAAG,IAAI,IAAI,EAAE,CAAC;YACd,OAAO,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,GAAG,GAAG,CAAC;QAC9D,CAAC;IACL,CAAC;IACD,OAAO,MAAM,CAAC,QAAQ,CAAC;AAC3B,CAAC;AAED;;;GAGG;AACH,MAAM,OAAO,iBAAkB,SAAQ,UAAU;IAC7C,IAAI,WAAW;QACX,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,IAAI,aAAa;QACb,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,IAAY;QACxB,OAAO,IAAI,IAAI,GAAG,CAAC;IACvB,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,MAAc;QACtC,OAAO,GAAG,MAAM,KAAK,MAAM,GAAG,CAAC;IACnC,CAAC;IAED;;;;;;OAMG;IACH,gBAAgB,CAAC,SAAiB;QAC9B,OAAO,IAAI,SAAS,GAAG,CAAC;IAC5B,CAAC;IAED,oEAAoE;IAEpE,WAAW,CAAC,KAAa,EAAE,MAAe;QACtC,MAAM,KAAK,GAAG,CAAC,SAAS,KAAK,EAAE,CAAC,CAAC;QACjC,IAAI,MAAM,IAAI,IAAI,EAAE,CAAC;YACjB,KAAK,CAAC,IAAI,CAAC,UAAU,MAAM,EAAE,CAAC,CAAC;QACnC,CAAC;QACD,OAAO,EAAE,MAAM,EAAE,EAAE,EAAE,MAAM,EAAE,KAAK,CAAC,IAAI,CAAC,GAAG,CAAC,EAAE,CAAC;IACnD,CAAC;IAED,oEAAoE;IAEpE,cAAc,CAAC,KAAc;QACzB,OAAO,KAAK,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,OAAO,CAAC;IACpC,CAAC;IAED,oBAAoB;QAChB,OAAO,SAAS,CAAC;IACrB,CAAC;IAED;;;;OAIG;IACH,MAAM,CAAC,IAAY,EAAE,QAAgB;QACjC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED;;;OAGG;IACH,QAAQ,CAAC,IAAY,EAAE,QAAgB;QACnC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED;;;;;;;;;;OAUG;IACH,YAAY,CAAC,IAAY;QACrB,OAAO,KAAK,IAAI,CAAC,WAAW,EAAE,EAAE,CAAC;IACrC,CAAC;IAED;;OAEG;IACH,gBAAgB,CAAC,KAAa;QAC1B,OAAO,YAAY,KAAK,EAAE,CAAC;IAC/B,CAAC;IAED,mBAAmB;QACf,OAAO,4BAA4B,CAAC;IACxC,CAAC;IAED,oEAAoE;IACpE,kEAAkE;IAClE,uEAAuE;IACvE,uEAAuE;IACvE,sEAAsE;IACtE,uBAAuB;aAEC,sBAAiB,GAAG,CAAC,MAAM,EAAE,SAAS,CAAU,CAAC;aACjD,qBAAgB,GAAG,CAAC,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,WAAW,EAAE,mBAAmB,EAAE,QAAQ,EAAE,QAAQ,EAAE,MAAM,CAAU,CAAC;aACtH,mBAAc,GAAG,CAAC,MAAM,EAAE,MAAM,EAAE,wBAAwB,EAAE,qBAAqB,EAAE,WAAW,EAAE,aAAa,EAAE,0BAA0B,EAAE,6BAA6B,CAAU,CAAC;aACnL,sBAAiB,GAAG,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,QAAQ,EAAE,UAAU,EAAE,QAAQ,EAAE,WAAW,EAAE,aAAa,EAAE,KAAK,CAAU,CAAC;aAC3I,oBAAe,GAAG,CAAC,SAAS,EAAE,SAAS,EAAE,MAAM,EAAE,kBAAkB,EAAE,QAAQ,EAAE,QAAQ,CAAU,CAAC;aAClG,mBAAc,GAAG,CAAC,MAAM,CAAU,CAAC;aACnC,qBAAgB,GAAG,CAAC,OAAO,CAAU,CAAC;aACtC,mBAAc,GAAG,CAAC,MAAM,EAAE,OAAO,EAAE,KAAK,CAAU,CAAC;aACnD,uBAAkB,GAAG,CAAC,OAAO,CAAU,CAAC;aACxC,uBAAkB,GAAG,CAAC,UAAU,CAAU,CAAC;aAC3C,sBAAiB,GAAG,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,UAAU,CAAU,CAAC;IAE7F,IAAI,gBAAgB,KAAyB,OAAO,iBAAiB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IAC1F,IAAI,eAAe,KAA0B,OAAO,iBAAiB,CAAC,gBAAgB,CAAC,CAAC,CAAC;IACzF,IAAI,aAAa,KAA4B,OAAO,iBAAiB,CAAC,cAAc,CAAC,CAAC,CAAC;IACvF,IAAI,gBAAgB,KAAyB,OAAO,iBAAiB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IAC1F,IAAI,cAAc,KAA2B,OAAO,iBAAiB,CAAC,eAAe,CAAC,CAAC,CAAC;IACxF,IAAI,aAAa,KAA4B,OAAO,iBAAiB,CAAC,cAAc,CAAC,CAAC,CAAC;IACvF,IAAI,eAAe,KAA0B,OAAO,iBAAiB,CAAC,gBAAgB,CAAC,CAAC,CAAC;IACzF,IAAI,aAAa,KAA4B,OAAO,iBAAiB,CAAC,cAAc,CAAC,CAAC,CAAC;IACvF,IAAI,iBAAiB,KAAwB,OAAO,iBAAiB,CAAC,kBAAkB,CAAC,CAAC,CAAC;IAC3F,IAAI,iBAAiB,KAAwB,OAAO,iBAAiB,CAAC,kBAAkB,CAAC,CAAC,CAAC;IAC3F,IAAI,gBAAgB,KAAyB,OAAO,iBAAiB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IAE1F,OAAO;QACH,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,WAAW,CAAC;IACnC,CAAC;IAED;;;;;;;OAOG;IACH,+BAA+B,CAAC,GAAW;QACvC,OAAO,GAAG,CAAC,UAAU,CAAC,OAAO,EAAE,SAAS,CAAC,CAAC;IAC9C,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,WAAW,CAAC;IACnC,CAAC;IAED;;;;OAIG;IACH,gBAAgB;QACZ,OAAO,GAAG,KAAK,CAAC,gBAAgB,EAAE,QAAQ,CAAC;IAC/C,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,OAAkB;QACnC,IAAI,OAAO,IAAI,OAAO,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAChC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YACnD,OAAO,aAAa,IAAI,EAAE,CAAC;QAC/B,CAAC;QACD,OAAO,aAAa,CAAC;IACzB,CAAC;IAED,yBAAyB;QACrB,OAAO,8BAA8B,CAAC;IAC1C,CAAC;IAED,aAAa;QACT,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,uBAAuB;QACnB,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,kBAAkB;QACd,yDAAyD;QACzD,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,oEAAoE;IAEpE,cAAc;QACV,OAAO,EAAE,CAAC,CAAC,4CAA4C;IAC3D,CAAC;IAED,iBAAiB,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY;QAC9D,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,QAAQ,cAAc,EAAE,CAAC;YACrB,KAAK,OAAO;gBACR,OAAO,yEAAyE,MAAM,sBAAsB,IAAI,IAAI,CAAC;YACzH,KAAK,MAAM;gBACP,OAAO,wEAAwE,MAAM,qBAAqB,IAAI,IAAI,CAAC;YACvH,KAAK,UAAU;gBACX,OAAO,iIAAiI,MAAM,sBAAsB,IAAI,IAAI,CAAC;YACjL,KAAK,WAAW;gBACZ,OAAO,iIAAiI,MAAM,sBAAsB,IAAI,wBAAwB,CAAC;YACrM,KAAK,SAAS;gBACV,OAAO,sEAAsE,IAAI,IAAI,CAAC;YAC1F;gBACI,OAAO,kIAAkI,MAAM,sBAAsB,IAAI,IAAI,CAAC;QACtL,CAAC;IACL,CAAC;IAED,wBAAwB,CAAC,UAAkB;QACvC,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAC5C,OAAO,UAAU,KAAK,UAAU,IAAI,UAAU,KAAK,MAAM,IAAI,UAAU,KAAK,WAAW,CAAC;IAC5F,CAAC;IAED,oEAAoE;IAEpE,uBAAuB,CAAC,MAAc,EAAE,UAAkB;QACtD,OAAO,GAAG,MAAM,kCAAkC,UAAU,GAAG,CAAC;IACpE,CAAC;IAED,gBAAgB,CAAC,KAAa,EAAE,OAAiB,EAAE,QAAiB;QAChE,MAAM,OAAO,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACtD,MAAM,UAAU,GAAG,KAAK,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;QAC3C,MAAM,WAAW,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC1D,MAAM,KAAK,GAAa,EAAE,CAAC;QAE3B,sBAAsB;QACtB,KAAK,CAAC,IAAI,CAAC,eAAe,KAAK,qDAAqD,CAAC,CAAC;QACtF,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,0CAA0C;QAC1C,KAAK,CAAC,IAAI,CAAC,sCAAsC,UAAU,CAAC,OAAO,CAAC,KAAK,EAAE,GAAG,CAAC,OAAO,KAAK,8BAA8B,CAAC,CAAC;QAC3H,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,wBAAwB;QACxB,KAAK,CAAC,IAAI,CAAC,8BAA8B,IAAI,CAAC,aAAa,CAAC,KAAK,CAAC,eAAe,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,IAAI,CAAC,CAAC;QAC9G,KAAK,CAAC,IAAI,CAAC,uBAAuB,CAAC,CAAC;QACpC,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,qDAAqD,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,iBAAiB,CAAC,QAAQ,CAAC,CAAC,IAAI,CAAC,aAAa,CAAC,IAAI,CAAC,CAAC;QACtI,KAAK,CAAC,IAAI,CAAC,iBAAiB,CAAC,CAAC;QAC9B,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QACnB,KAAK,CAAC,IAAI,CAAC,sBAAsB,CAAC,CAAC;QACnC,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,KAAK,CAAC,IAAI,CAAC,kCAAkC,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,OAAO,KAAK,GAAG,CAAC,CAAC;QACrF,KAAK,CAAC,IAAI,CAAC,0BAA0B,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,EAAE,CAAC,CAAC;QAChE,KAAK,CAAC,IAAI,CAAC,kCAAkC,KAAK,EAAE,CAAC,CAAC;QACtD,KAAK,CAAC,IAAI,CAAC,qCAAqC,IAAI,CAAC,aAAa,CAAC,KAAK,CAAC,eAAe,IAAI,CAAC,WAAW,CAAC,KAAK,CAAC,KAAK,CAAC,CAAC;QAEtH,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,oEAAoE;IAEpE,kBAAkB;QACd,OAAO,gBAAgB,CAAC;IAC5B,CAAC;IAED,IAAI,kBAAkB;QAClB,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,IAAI,oBAAoB;QACpB,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,IAAI,OAAO;QACP,OAAO,IAAI,qBAAqB,EAAE,CAAC;IACvC,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,KAAa;QAC9B,OAAO,IAAI,KAAK,GAAG,CAAC,EAAE,CAAC,CAAC,mCAAmC;IAC/D,CAAC;IAED,cAAc;QACV,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,KAAa,EAAE,SAAiB;QAChD,OAAO,0BAA0B,KAAK,KAAK,SAAS,IAAI,CAAC;IAC7D,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,IAAY;QACpC,gDAAgD;QAChD,OAAO,GAAG,MAAM,OAAO,IAAI,GAAG,CAAC;IACnC,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,MAAc,EAAE,IAAY,EAAE,MAAgB;QAC9D,MAAM,SAAS,GAAG,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACpC,OAAO,iBAAiB,MAAM,KAAK,IAAI,KAAK,SAAS,GAAG,CAAC;IAC7D,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,UAAkB;QAC9B,OAAO,gCAAgC,UAAU,IAAI,CAAC;IAC1D,CAAC;IAED,mEAAmE;IAEnE,iBAAiB,CAAC,IAA+B,EAAE,MAAc,EAAE,QAAgB;QAC/E,MAAM,MAAM,GAAG,IAAI,CAAC,WAAW,EAAE,GAAG,GAAG,CAAC,CAAC,gDAAgD;QACzF,OAAO,GAAG,QAAQ,gBAAgB,MAAM,IAAI,MAAM,GAAG,CAAC;IAC1D,CAAC;IAED,yBAAyB,CAAC,MAAc,EAAE,SAAiB,EAAE,UAAkB;QAC3E,MAAM,WAAW,GAAG,IAAI,CAAC,WAAW,CAAC,MAAM,EAAE,SAAS,CAAC,CAAC;QACxD,OAAO;YACH,8BAA8B,WAAW,IAAI;YAC7C,UAAU;YACV,IAAI;SACP,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,gBAAgB,CAAC,SAAiB,EAAE,OAAe,EAAE,OAAgB;QACjE,MAAM,KAAK,GAAG;YACV,OAAO;YACP,OAAO;YACP,QAAQ,SAAS,OAAO;YACxB,OAAO,OAAO,GAAG;SACpB,CAAC;QACF,IAAI,OAAO,EAAE,CAAC;YACV,KAAK,CAAC,IAAI,CAAC,QAAQ,CAAC,CAAC;YACrB,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,GAAG,CAAC,CAAC;QAClC,CAAC;QACD,KAAK,CAAC,IAAI,CAAC,WAAW,CAAC,CAAC;QACxB,KAAK,CAAC,IAAI,CAAC,SAAS,CAAC,CAAC;QACtB,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,cAAc,CAAC,OAAe;QAC1B,OAAO,iBAAiB,OAAO,GAAG,CAAC;IACvC,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,GAAqB;QACjC,MAAM,QAAQ,GAAG,GAAG,CAAC,QAAQ,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QACpD,MAAM,WAAW,GAAG,GAAG,CAAC,YAAY,IAAI,IAAI,CAAC,CAAC,CAAC,YAAY,GAAG,CAAC,YAAY,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QACnF,OAAO,eAAe,GAAG,CAAC,IAAI,KAAK,GAAG,CAAC,OAAO,IAAI,QAAQ,GAAG,WAAW,EAAE,CAAC;IAC/E,CAAC;IAED,cAAc,CAAC,WAAmB,EAAE,OAA2B;QAC3D,OAAO,CACH,eAAe,WAAW,IAAI;YAC9B,qBAAqB,OAAO,CAAC,UAAU,UAAU,OAAO,CAAC,OAAO,KAAK;YACrE,qBAAqB,OAAO,CAAC,UAAU,KAAK,OAAO,CAAC,WAAW,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC,CAAC,cAAc,GAAG,CACxG,CAAC;IACN,CAAC;IAED,eAAe,CAAC,MAAc,EAAE,KAAa,EAAE,MAAc,EAAE,OAAe;QAC1E,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QAC5C,OAAO,sBAAsB,MAAM,MAAM,KAAK,MAAM,MAAM,SAAS,OAAO,IAAI,CAAC;IACnF,CAAC;IAED,YAAY;QACR,OAAO,MAAM,CAAC;IAClB,CAAC;IAED,mEAAmE;IAEnE,UAAU,CAAC,OAAuB;QAC9B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QAC3C,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,IAAI,KAAK,CAAC;QACzC,MAAM,QAAQ,GAAG,OAAO,CAAC,YAAY,IAAI,MAAM,OAAO,CAAC,WAAW,EAAE,CAAC;QACrE,MAAM,KAAK,GAAa,EAAE,CAAC;QAE3B,mDAAmD;QACnD,KAAK,CAAC,IAAI,CAAC,8BAA8B,OAAO,CAAC,MAAM,KAAK,QAAQ,KAAK,CAAC,CAAC;QAC3E,KAAK,CAAC,IAAI,CAAC,uBAAuB,CAAC,CAAC;QACpC,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;QACnB,KAAK,CAAC,IAAI,CAAC,sBAAsB,CAAC,CAAC;QACnC,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QAEf,KAAK,CAAC,IAAI,CAAC,2BAA2B,OAAO,CAAC,WAAW,QAAQ,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,IAAI,CAAC,CAAC;QAC3G,KAAK,CAAC,IAAI,CAAC,mBAAmB,OAAO,CAAC,WAAW,GAAG,CAAC,CAAC;QACtD,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,MAAM,IAAI,MAAM,OAAO,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,GAAG,CAAC,CAAC;QAC1F,KAAK,CAAC,IAAI,CAAC,gBAAgB,OAAO,EAAE,CAAC,CAAC;QACtC,KAAK,CAAC,IAAI,CAAC,wBAAwB,OAAO,CAAC,MAAM,KAAK,QAAQ,MAAM,CAAC,CAAC;QAEtE,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,QAAQ,CAAC,OAAqB;QAC1B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,EAAE,CAAC;QAC/C,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,OAAO,CAAC,MAAM,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QAChE,MAAM,IAAI,GAAG,OAAO,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC3D,IAAI,GAAG,GAAG,UAAU,MAAM,wBAAwB,OAAO,CAAC,SAAS,QAAQ,OAAO,CAAC,MAAM,KAAK,OAAO,CAAC,SAAS,IAAI,MAAM,IAAI,IAAI,GAAG,CAAC;QACrI,IAAI,OAAO,CAAC,KAAK,EAAE,CAAC;YAChB,GAAG,IAAI,UAAU,OAAO,CAAC,KAAK,EAAE,CAAC;QACrC,CAAC;QACD,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,UAAkB,EAAE,WAAmB,EAAE,MAAc,EAAE,MAAc,EAAE,IAAY;QACjG,OAAO,SAAS,UAAU,OAAO,MAAM,KAAK,MAAM,SAAS,IAAI,GAAG,CAAC;IACvE,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY,EAAE,OAAe;QAC7E,MAAM,cAAc,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QACnD,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,OAAO,cAAc,cAAc,IAAI,MAAM,KAAK,IAAI,SAAS,cAAc,GAAG,CAAC;IACrF,CAAC;IAED,oEAAoE;IAEpE,0BAA0B;QACtB,OAAO;YACH,UAAU,EAAE;;;;mCAIW;YACvB,WAAW,EAAE;;;;;;;4CAOmB;YAChC,eAAe,EAAE;;;;;;kEAMqC;YACtD,eAAe,EAAE;;;;;;;;;;;;;;;4CAee;YAChC,WAAW,EAAE;;;;;;;;;;;;;;mCAcU;YACvB,YAAY,EAAE;;;;;4BAKE;SACnB,CAAC;IACN,CAAC;IAED,oEAAoE;IAEpE,GAAG,CAAC,SAAiB,EAAE,OAAe,EAAE,QAAgB;QACpD,OAAO,aAAa,SAAS,SAAS,OAAO,SAAS,QAAQ,MAAM,CAAC;IACzE,CAAC;IAED,qEAAqE;IAErE,mBAAmB,CAAC,OAA2B;QAC3C,QAAQ,OAAO,CAAC,IAAI,EAAE,CAAC;YACnB,KAAK,QAAQ;gBACT,OAAO,IAAI,CAAC,iBAAiB,CAAC,OAAO,CAAC,SAAS,CAAC,CAAC;YACrD,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,SAAS;gBACV,OAAO,SAAS,CAAC;YACrB,KAAK,QAAQ;gBACT,OAAO,QAAQ,CAAC;YACpB,KAAK,SAAS;gBACV,OAAO,WAAW,OAAO,CAAC,SAAS,IAAI,EAAE,IAAI,OAAO,CAAC,KAAK,IAAI,CAAC,GAAG,CAAC;YACvE,KAAK,SAAS;gBACV,OAAO,SAAS,CAAC;YACrB,KAAK,UAAU;gBACX,OAAO,aAAa,CAAC;YACzB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,OAAO,CAAC;YACnB,KAAK,OAAO;gBACR,OAAO,kBAAkB,CAAC;YAC9B,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB;gBACI,OAAO,IAAI,CAAC,YAAY,EAAE,CAAC;QACnC,CAAC;IACL,CAAC;IAEO,iBAAiB,CAAC,SAAkB;QACxC,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,GAAG,CAAC,EAAE,CAAC;YACrC,OAAO,WAAW,SAAS,GAAG,CAAC;QACnC,CAAC;QACD,OAAO,cAAc,CAAC;IAC1B,CAAC;IAED,oEAAoE;IAE5D,aAAa,CAAC,aAAqB;QACvC,MAAM,QAAQ,GAAG,aAAa,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC;QAC5C,IAAI,QAAQ,KAAK,CAAC,CAAC;YAAE,OAAO,QAAQ,CAAC;QACrC,OAAO,aAAa,CAAC,SAAS,CAAC,CAAC,EAAE,QAAQ,CAAC,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;IAClE,CAAC;IAEO,WAAW,CAAC,aAAqB;QACrC,MAAM,QAAQ,GAAG,aAAa,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC;QAC5C,IAAI,QAAQ,KAAK,CAAC,CAAC;YAAE,OAAO,aAAa,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;QAC5D,OAAO,aAAa,CAAC,SAAS,CAAC,QAAQ,GAAG,CAAC,CAAC,CAAC,OAAO,CAAC,IAAI,EAAE,EAAE,CAAC,CAAC;IACnE,CAAC"}

dist/sqlDialect.d.ts

 import { DataTypeMap, MappedType } from './dataTypeMap.js';
 /**
- * Supported database platforms.
- * Extensible — add new platforms as support is implemented.
+ * Canonical database-platform value used across MJ. Single source of truth —
+ * config validation, env-var parsing, and runtime branching all compare
+ * against these literals. Aliases (`mssql`, `postgres`, `pg`) are not
+ * recognized.
+ *
+ * Lives in `@memberjunction/sql-dialect` (not `core` or `global`) because
+ * this is the package that owns SQL dialect semantics; every other package
+ * imports it from here (or from core, which re-exports for back-compat).
  */
@@ -168,2 +174,18 @@ export type DatabasePlatform = 'sqlserver' | 'postgresql';
     /**
+     * Quotes a column alias used in `SELECT ... AS <alias>`. SQL Server is
+     * case-insensitive and accepts a bare identifier; PostgreSQL folds
+     * unquoted identifiers to lowercase, so we must quote the alias when the
+     * caller cares about preserving case (e.g. matching a TypeScript property
+     * name in the result row).
+     */
+    abstract QuoteColumnAlias(aliasName: string): string;
+    /**
+     * Quotes a value as a SQL string literal. Both SQL Server and PostgreSQL
+     * use single quotes with `''` doubling to escape internal apostrophes —
+     * this is concrete in the base class so callers don't reinvent the
+     * `value.replace(/'/g, "''")` pattern. Subclasses may override if a
+     * future dialect needs a different escape rule.
+     */
+    QuoteStringLiteral(value: string): string;
+    /**
      * Returns pagination SQL fragments.
@@ -180,2 +202,15 @@ * SQL Server uses TOP (prefix) or OFFSET/FETCH (suffix).
     /**
+     * Returns the SQL type token for a boolean parameter in a stored-procedure /
+     * function signature. Used by codegen when emitting tolerant-SP `_Clear`
+     * companion parameters and other boolean-typed params.
+     *
+     * SQL Server: `bit` (BIT type, 0/1)
+     * PostgreSQL: `boolean` (BOOLEAN type, TRUE/FALSE)
+     *
+     * Hardcoding `bit` everywhere worked on SQL Server but produced sprocs
+     * that PG rejected as `operator does not exist: boolean = integer` when
+     * the generated CASE compared a `bit`-declared parameter with `= 1`.
+     */
+    abstract BooleanParameterType(): string;
+    /**
      * Returns the current UTC timestamp expression.
@@ -186,2 +221,38 @@ * SQL Server: GETUTCDATE(), PostgreSQL: NOW() AT TIME ZONE 'UTC'
     /**
+     * Wraps an expression in the dialect's lowercase function — used for
+     * case-insensitive comparison when authoring filters that must work on
+     * both SS (default case-insensitive collation) and PG (case-sensitive).
+     *
+     * Both SQL Server and PostgreSQL implement `LOWER()` per the ANSI SQL
+     * standard, so the default returns `LOWER(${expr})`. A subclass would
+     * override only for an exotic dialect (e.g. one that exposes `lc()` or
+     * needs a CAST first).
+     *
+     * Use this instead of hardcoding `LOWER(...)` in callers — keeps the
+     * dialect-aware SQL surface in one place per the SQLDialect contract.
+     */
+    LowerCase(expr: string): string;
+    /** SQL type names this dialect uses for boolean columns. */
+    abstract get BooleanTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for variable-length character / text columns. */
+    abstract get StringTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for date / time / timestamp columns. */
+    abstract get DateTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for integer columns (int, bigint, smallint, …). */
+    abstract get IntegerTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for floating-point / decimal columns. */
+    abstract get FloatTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for UUID / uniqueidentifier columns. */
+    abstract get UuidTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for binary blob columns (image, bytea, varbinary). */
+    abstract get BinaryTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for JSON / XML structured columns. */
+    abstract get JsonTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for fixed-precision currency columns. */
+    abstract get CurrencyTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for interval / duration columns. */
+    abstract get IntervalTypeNames(): readonly string[];
+    /** SQL type names this dialect uses for network address columns (inet, cidr, …). */
+    abstract get NetworkTypeNames(): readonly string[];
+    /**
      * Returns a new UUID generation expression.
@@ -233,2 +304,14 @@ * SQL Server: NEWID(), PostgreSQL: gen_random_uuid()
     /**
+     * Returns a CAST to a bounded-width string type. Used when the result
+     * needs to be comparable against an indexed column (SQL Server cannot
+     * compare/index `NVARCHAR(MAX)`) or against a fixed-width text column
+     * such as MJ's `RecordID` (NVARCHAR(450) on SQL Server).
+     *
+     * Implemented by composing `ResolveAbstractType({ type: 'string', maxLength })`,
+     * which dialects already supply — SQL Server emits `NVARCHAR(N)` and
+     * PostgreSQL emits `VARCHAR(N)`. Defaults to MJ's standard 450-char
+     * width to match the cap on indexable string columns in SQL Server.
+     */
+    CastToBoundedString(expr: string, maxLength?: number): string;
+    /**
      * Returns a CAST-to-UUID expression.
@@ -354,2 +437,10 @@ * SQL Server: CAST(expr AS UNIQUEIDENTIFIER), PostgreSQL: CAST(expr AS UUID)
     /**
+     * Splits `${...}` inside SQL string literals so Flyway doesn't treat
+     * them as placeholders. Each `${name}` becomes a concat-split that
+     * round-trips back to `${name}` at execution but contains no adjacent
+     * `${` in the file text. Form is platform-specific (concat operator,
+     * truncation rules) — see each dialect's implementation.
+     */
+    abstract EscapeFlywayStringInterpolation(sql: string): string;
+    /**
      * Returns the SQL syntax for calling a stored procedure or function.
@@ -356,0 +447,0 @@ * SQL Server: EXEC [schema].[name] @p0, @p1

dist/sqlDialect.d.ts.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"sqlDialect.d.ts","sourceRoot":"","sources":["../src/sqlDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAE,UAAU,EAAE,MAAM,kBAAkB,CAAC;AAE3D;;;GAGG;AACH,MAAM,MAAM,gBAAgB,GAAG,WAAW,GAAG,YAAY,CAAC;AAE1D;;;GAGG;AACH,MAAM,MAAM,eAAe,GACrB,QAAQ,GAAG,MAAM,GAAG,SAAS,GAAG,QAAQ,GAAG,SAAS,GACpD,SAAS,GAAG,UAAU,GAAG,MAAM,GAAG,MAAM,GAAG,MAAM,GACjD,OAAO,GAAG,MAAM,CAAC;AAEvB;;GAEG;AACH,MAAM,WAAW,kBAAkB;IAC/B,4DAA4D;IAC5D,IAAI,EAAE,eAAe,CAAC;IACtB,mCAAmC;IACnC,SAAS,CAAC,EAAE,MAAM,CAAC;IACnB,mCAAmC;IACnC,SAAS,CAAC,EAAE,MAAM,CAAC;IACnB,+BAA+B;IAC/B,KAAK,CAAC,EAAE,MAAM,CAAC;CAClB;AAED;;;GAGG;AACH,MAAM,WAAW,iBAAiB;IAC9B,qEAAqE;IACrE,MAAM,EAAE,MAAM,CAAC;IACf,gFAAgF;IAChF,MAAM,EAAE,MAAM,CAAC;CAClB;AAED;;;GAGG;AACH,MAAM,WAAW,sBAAsB;IACnC,qDAAqD;IACrD,UAAU,EAAE,MAAM,CAAC;IACnB,uDAAuD;IACvD,WAAW,EAAE,MAAM,CAAC;IACpB,yDAAyD;IACzD,eAAe,EAAE,MAAM,CAAC;IACxB,mDAAmD;IACnD,eAAe,EAAE,MAAM,CAAC;IACxB,iCAAiC;IACjC,WAAW,EAAE,MAAM,CAAC;IACpB,wDAAwD;IACxD,YAAY,EAAE,MAAM,CAAC;CACxB;AAED;;GAEG;AACH,MAAM,WAAW,gBAAgB;IAC7B,0DAA0D;IAC1D,IAAI,EAAE,MAAM,CAAC;IACb,8EAA8E;IAC9E,OAAO,EAAE,MAAM,CAAC;IAChB,6CAA6C;IAC7C,QAAQ,EAAE,OAAO,CAAC;IAClB,4EAA4E;IAC5E,YAAY,CAAC,EAAE,MAAM,CAAC;CACzB;AAED;;GAEG;AACH,MAAM,WAAW,kBAAkB;IAC/B,8BAA8B;IAC9B,UAAU,EAAE,MAAM,CAAC;IACnB,2BAA2B;IAC3B,OAAO,EAAE,MAAM,CAAC;IAChB,uBAAuB;IACvB,WAAW,EAAE,OAAO,CAAC;CACxB;AAED;;GAEG;AACH,MAAM,WAAW,cAAc;IAC3B,kBAAkB;IAClB,MAAM,EAAE,MAAM,CAAC;IACf,mCAAmC;IACnC,SAAS,EAAE,MAAM,CAAC;IAClB,mBAAmB;IACnB,WAAW,EAAE,MAAM,CAAC;IACpB,2CAA2C;IAC3C,MAAM,EAAE,QAAQ,GAAG,OAAO,GAAG,YAAY,CAAC;IAC1C,mCAAmC;IACnC,MAAM,EAAE,CAAC,QAAQ,GAAG,QAAQ,GAAG,QAAQ,CAAC,EAAE,CAAC;IAC3C,2BAA2B;IAC3B,IAAI,EAAE,MAAM,CAAC;IACb,mDAAmD;IACnD,YAAY,CAAC,EAAE,MAAM,CAAC;IACtB,mEAAmE;IACnE,OAAO,CAAC,EAAE,KAAK,GAAG,WAAW,CAAC;CACjC;AAED;;GAEG;AACH,MAAM,WAAW,YAAY;IACzB,kBAAkB;IAClB,MAAM,EAAE,MAAM,CAAC;IACf,iBAAiB;IACjB,SAAS,EAAE,MAAM,CAAC;IAClB,iBAAiB;IACjB,SAAS,EAAE,MAAM,CAAC;IAClB,uBAAuB;IACvB,OAAO,EAAE,MAAM,EAAE,CAAC;IAClB,qCAAqC;IACrC,MAAM,CAAC,EAAE,OAAO,CAAC;IACjB,0FAA0F;IAC1F,MAAM,CAAC,EAAE,MAAM,CAAC;IAChB,yDAAyD;IACzD,KAAK,CAAC,EAAE,MAAM,CAAC;IACf,kDAAkD;IAClD,cAAc,CAAC,EAAE,MAAM,EAAE,CAAC;CAC7B;AAED;;;;;;;;;GASG;AACH,MAAM,WAAW,gBAAgB;IAC7B,kFAAkF;IAClF,aAAa,EAAE,MAAM,CAAC;IACtB,0FAA0F;IAC1F,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM,CAAC;IACtC,wEAAwE;IACxE,kBAAkB,EAAE,OAAO,CAAC;IAC5B;uDACmD;IACnD,oBAAoB,EAAE,MAAM,CAAC;CAChC;AAED;;;;;;GAMG;AACH,8BAAsB,UAAW,YAAW,gBAAgB;IACxD;;OAEG;IACH,QAAQ,KAAK,WAAW,IAAI,gBAAgB,CAAC;IAE7C;;;OAGG;IACH,QAAQ,KAAK,aAAa,IAAI,MAAM,CAAC;IAIrC;;;OAGG;IACH,QAAQ,CAAC,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAE9C;;;OAGG;IACH,QAAQ,CAAC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAI5D;;;;OAIG;IACH,QAAQ,CAAC,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAIvE;;;OAGG;IACH,QAAQ,CAAC,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAE/C;;;OAGG;IACH,QAAQ,CAAC,mBAAmB,IAAI,MAAM;IAEtC;;;OAGG;IACH,QAAQ,CAAC,OAAO,IAAI,MAAM;IAE1B;;;;;OAKG;IACH,QAAQ,CAAC,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAEzD;;;;;;OAMG;IACH,IAAI,WAAW,IAAI,MAAM,CAExB;IAED;;;;;OAKG;IACH,aAAa,CAAC,KAAK,EAAE,MAAM,GAAG,OAAO;IAKrC;;;;;OAKG;IACH,QAAQ,CAAC,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAE3C;;;;;OAKG;IACH,QAAQ,CAAC,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAEhD;;;OAGG;IACH,QAAQ,CAAC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAEzC;;;OAGG;IACH,QAAQ,CAAC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAEzC;;;;;;;OAOG;IACH,gBAAgB,IAAI,MAAM;IAM1B;;;;OAIG;IACH,QAAQ,CAAC,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAEzD;;;OAGG;IACH,QAAQ,CAAC,yBAAyB,IAAI,MAAM;IAE5C;;;OAGG;IACH,QAAQ,CAAC,aAAa,IAAI,MAAM;IAEhC;;;OAGG;IACH,QAAQ,CAAC,uBAAuB,IAAI,MAAM;IAE1C;;;OAGG;IACH,QAAQ,CAAC,kBAAkB,IAAI,MAAM;IAIrC;;;OAGG;IACH,QAAQ,CAAC,cAAc,IAAI,MAAM;IAEjC;;;;;OAKG;IACH,QAAQ,CAAC,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAEpF;;;OAGG;IACH,QAAQ,CAAC,wBAAwB,CAAC,UAAU,EAAE,MAAM,GAAG,OAAO;IAI9D;;;;OAIG;IACH,QAAQ,CAAC,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAE5E;;;;OAIG;IACH,QAAQ,CAAC,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAIrF;;;OAGG;IACH,QAAQ,CAAC,kBAAkB,IAAI,MAAM;IAErC;;;;;OAKG;IACH,QAAQ,KAAK,kBAAkB,IAAI,OAAO,CAAC;IAE3C;;;OAGG;IACH,QAAQ,KAAK,oBAAoB,IAAI,MAAM,CAAC;IAI5C;;OAEG;IACH,QAAQ,KAAK,OAAO,IAAI,WAAW,CAAC;IAEpC;;OAEG;IACH,WAAW,CAAC,aAAa,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,EAAE,SAAS,CAAC,EAAE,MAAM,EAAE,KAAK,CAAC,EAAE,MAAM,GAAG,UAAU;IAInG;;OAEG;IACH,mBAAmB,CAAC,aAAa,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,EAAE,SAAS,CAAC,EAAE,MAAM,EAAE,KAAK,CAAC,EAAE,MAAM,GAAG,MAAM;IAMvG;;;OAGG;IACH,QAAQ,CAAC,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAEpD;;;OAGG;IACH,QAAQ,CAAC,cAAc,IAAI,MAAM;IAIjC;;;;OAIG;IACH,QAAQ,CAAC,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAEtE;;;;OAIG;IACH,QAAQ,CAAC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI1D;;;;OAIG;IACH,QAAQ,CAAC,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAIpF;;;;OAIG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAEpD;;;;;OAKG;IACH,gBAAgB,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAI5C;;;;OAIG;IACH,QAAQ,CAAC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAEvD;;;;OAIG;IACH,QAAQ,CAAC,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAEjF;;;;;;;OAOG;IACH,QAAQ,CAAC,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAEhG;;;;OAIG;IACH,QAAQ,CAAC,YAAY,IAAI,MAAM;IAE/B;;;;;OAKG;IACH,QAAQ,CAAC,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAIjE;;;;;;;;OAQG;IACH,QAAQ,CAAC,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAErG;;;;;;;;OAQG;IACH,QAAQ,CAAC,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAEjG;;;;;;;;OAQG;IACH,QAAQ,CAAC,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAEvF;;;;;;;;;OASG;IACH,QAAQ,CAAC,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAIhD;;OAEG;IACH,QAAQ,CAAC,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAEpD;;OAEG;IACH,QAAQ,CAAC,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAIhD;;OAEG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAEtH;;OAEG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAInG;;OAEG;IACH,QAAQ,CAAC,0BAA0B,IAAI,sBAAsB;IAI7D;;;;;;;OAOG;IACH,QAAQ,CAAC,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAEvD;;;;OAIG;IACH,QAAQ,CAAC,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;CAC7E"}
+{"version":3,"file":"sqlDialect.d.ts","sourceRoot":"","sources":["../src/sqlDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAE,UAAU,EAAE,MAAM,kBAAkB,CAAC;AAE3D;;;;;;;;;GASG;AACH,MAAM,MAAM,gBAAgB,GAAG,WAAW,GAAG,YAAY,CAAC;AAE1D;;;GAGG;AACH,MAAM,MAAM,eAAe,GACrB,QAAQ,GAAG,MAAM,GAAG,SAAS,GAAG,QAAQ,GAAG,SAAS,GACpD,SAAS,GAAG,UAAU,GAAG,MAAM,GAAG,MAAM,GAAG,MAAM,GACjD,OAAO,GAAG,MAAM,CAAC;AAEvB;;GAEG;AACH,MAAM,WAAW,kBAAkB;IAC/B,4DAA4D;IAC5D,IAAI,EAAE,eAAe,CAAC;IACtB,mCAAmC;IACnC,SAAS,CAAC,EAAE,MAAM,CAAC;IACnB,mCAAmC;IACnC,SAAS,CAAC,EAAE,MAAM,CAAC;IACnB,+BAA+B;IAC/B,KAAK,CAAC,EAAE,MAAM,CAAC;CAClB;AAED;;;GAGG;AACH,MAAM,WAAW,iBAAiB;IAC9B,qEAAqE;IACrE,MAAM,EAAE,MAAM,CAAC;IACf,gFAAgF;IAChF,MAAM,EAAE,MAAM,CAAC;CAClB;AAED;;;GAGG;AACH,MAAM,WAAW,sBAAsB;IACnC,qDAAqD;IACrD,UAAU,EAAE,MAAM,CAAC;IACnB,uDAAuD;IACvD,WAAW,EAAE,MAAM,CAAC;IACpB,yDAAyD;IACzD,eAAe,EAAE,MAAM,CAAC;IACxB,mDAAmD;IACnD,eAAe,EAAE,MAAM,CAAC;IACxB,iCAAiC;IACjC,WAAW,EAAE,MAAM,CAAC;IACpB,wDAAwD;IACxD,YAAY,EAAE,MAAM,CAAC;CACxB;AAED;;GAEG;AACH,MAAM,WAAW,gBAAgB;IAC7B,0DAA0D;IAC1D,IAAI,EAAE,MAAM,CAAC;IACb,8EAA8E;IAC9E,OAAO,EAAE,MAAM,CAAC;IAChB,6CAA6C;IAC7C,QAAQ,EAAE,OAAO,CAAC;IAClB,4EAA4E;IAC5E,YAAY,CAAC,EAAE,MAAM,CAAC;CACzB;AAED;;GAEG;AACH,MAAM,WAAW,kBAAkB;IAC/B,8BAA8B;IAC9B,UAAU,EAAE,MAAM,CAAC;IACnB,2BAA2B;IAC3B,OAAO,EAAE,MAAM,CAAC;IAChB,uBAAuB;IACvB,WAAW,EAAE,OAAO,CAAC;CACxB;AAED;;GAEG;AACH,MAAM,WAAW,cAAc;IAC3B,kBAAkB;IAClB,MAAM,EAAE,MAAM,CAAC;IACf,mCAAmC;IACnC,SAAS,EAAE,MAAM,CAAC;IAClB,mBAAmB;IACnB,WAAW,EAAE,MAAM,CAAC;IACpB,2CAA2C;IAC3C,MAAM,EAAE,QAAQ,GAAG,OAAO,GAAG,YAAY,CAAC;IAC1C,mCAAmC;IACnC,MAAM,EAAE,CAAC,QAAQ,GAAG,QAAQ,GAAG,QAAQ,CAAC,EAAE,CAAC;IAC3C,2BAA2B;IAC3B,IAAI,EAAE,MAAM,CAAC;IACb,mDAAmD;IACnD,YAAY,CAAC,EAAE,MAAM,CAAC;IACtB,mEAAmE;IACnE,OAAO,CAAC,EAAE,KAAK,GAAG,WAAW,CAAC;CACjC;AAED;;GAEG;AACH,MAAM,WAAW,YAAY;IACzB,kBAAkB;IAClB,MAAM,EAAE,MAAM,CAAC;IACf,iBAAiB;IACjB,SAAS,EAAE,MAAM,CAAC;IAClB,iBAAiB;IACjB,SAAS,EAAE,MAAM,CAAC;IAClB,uBAAuB;IACvB,OAAO,EAAE,MAAM,EAAE,CAAC;IAClB,qCAAqC;IACrC,MAAM,CAAC,EAAE,OAAO,CAAC;IACjB,0FAA0F;IAC1F,MAAM,CAAC,EAAE,MAAM,CAAC;IAChB,yDAAyD;IACzD,KAAK,CAAC,EAAE,MAAM,CAAC;IACf,kDAAkD;IAClD,cAAc,CAAC,EAAE,MAAM,EAAE,CAAC;CAC7B;AAED;;;;;;;;;GASG;AACH,MAAM,WAAW,gBAAgB;IAC7B,kFAAkF;IAClF,aAAa,EAAE,MAAM,CAAC;IACtB,0FAA0F;IAC1F,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM,CAAC;IACtC,wEAAwE;IACxE,kBAAkB,EAAE,OAAO,CAAC;IAC5B;uDACmD;IACnD,oBAAoB,EAAE,MAAM,CAAC;CAChC;AAED;;;;;;GAMG;AACH,8BAAsB,UAAW,YAAW,gBAAgB;IACxD;;OAEG;IACH,QAAQ,KAAK,WAAW,IAAI,gBAAgB,CAAC;IAE7C;;;OAGG;IACH,QAAQ,KAAK,aAAa,IAAI,MAAM,CAAC;IAIrC;;;OAGG;IACH,QAAQ,CAAC,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAE9C;;;OAGG;IACH,QAAQ,CAAC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAE5D;;;;;;OAMG;IACH,QAAQ,CAAC,gBAAgB,CAAC,SAAS,EAAE,MAAM,GAAG,MAAM;IAEpD;;;;;;OAMG;IACH,kBAAkB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAMzC;;;;OAIG;IACH,QAAQ,CAAC,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAIvE;;;OAGG;IACH,QAAQ,CAAC,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAE/C;;;;;;;;;;;OAWG;IACH,QAAQ,CAAC,oBAAoB,IAAI,MAAM;IAEvC;;;OAGG;IACH,QAAQ,CAAC,mBAAmB,IAAI,MAAM;IAEtC;;;;;;;;;;;;OAYG;IACH,SAAS,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAmB/B,4DAA4D;IAC5D,QAAQ,KAAK,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAC;IAEnD,qFAAqF;IACrF,QAAQ,KAAK,eAAe,IAAI,SAAS,MAAM,EAAE,CAAC;IAElD,4EAA4E;IAC5E,QAAQ,KAAK,aAAa,IAAI,SAAS,MAAM,EAAE,CAAC;IAEhD,uFAAuF;IACvF,QAAQ,KAAK,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAC;IAEnD,6EAA6E;IAC7E,QAAQ,KAAK,cAAc,IAAI,SAAS,MAAM,EAAE,CAAC;IAEjD,4EAA4E;IAC5E,QAAQ,KAAK,aAAa,IAAI,SAAS,MAAM,EAAE,CAAC;IAEhD,0FAA0F;IAC1F,QAAQ,KAAK,eAAe,IAAI,SAAS,MAAM,EAAE,CAAC;IAElD,0EAA0E;IAC1E,QAAQ,KAAK,aAAa,IAAI,SAAS,MAAM,EAAE,CAAC;IAEhD,6EAA6E;IAC7E,QAAQ,KAAK,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAC;IAEpD,wEAAwE;IACxE,QAAQ,KAAK,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAC;IAEpD,oFAAoF;IACpF,QAAQ,KAAK,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAC;IAEnD;;;OAGG;IACH,QAAQ,CAAC,OAAO,IAAI,MAAM;IAE1B;;;;;OAKG;IACH,QAAQ,CAAC,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAEzD;;;;;;OAMG;IACH,IAAI,WAAW,IAAI,MAAM,CAExB;IAED;;;;;OAKG;IACH,aAAa,CAAC,KAAK,EAAE,MAAM,GAAG,OAAO;IAKrC;;;;;OAKG;IACH,QAAQ,CAAC,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAE3C;;;;;OAKG;IACH,QAAQ,CAAC,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAEhD;;;OAGG;IACH,QAAQ,CAAC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAEzC;;;;;;;;;;OAUG;IACH,mBAAmB,CAAC,IAAI,EAAE,MAAM,EAAE,SAAS,GAAE,MAAY,GAAG,MAAM;IAKlE;;;OAGG;IACH,QAAQ,CAAC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAEzC;;;;;;;OAOG;IACH,gBAAgB,IAAI,MAAM;IAM1B;;;;OAIG;IACH,QAAQ,CAAC,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAEzD;;;OAGG;IACH,QAAQ,CAAC,yBAAyB,IAAI,MAAM;IAE5C;;;OAGG;IACH,QAAQ,CAAC,aAAa,IAAI,MAAM;IAEhC;;;OAGG;IACH,QAAQ,CAAC,uBAAuB,IAAI,MAAM;IAE1C;;;OAGG;IACH,QAAQ,CAAC,kBAAkB,IAAI,MAAM;IAIrC;;;OAGG;IACH,QAAQ,CAAC,cAAc,IAAI,MAAM;IAEjC;;;;;OAKG;IACH,QAAQ,CAAC,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAEpF;;;OAGG;IACH,QAAQ,CAAC,wBAAwB,CAAC,UAAU,EAAE,MAAM,GAAG,OAAO;IAI9D;;;;OAIG;IACH,QAAQ,CAAC,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAE5E;;;;OAIG;IACH,QAAQ,CAAC,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAIrF;;;OAGG;IACH,QAAQ,CAAC,kBAAkB,IAAI,MAAM;IAErC;;;;;OAKG;IACH,QAAQ,KAAK,kBAAkB,IAAI,OAAO,CAAC;IAE3C;;;OAGG;IACH,QAAQ,KAAK,oBAAoB,IAAI,MAAM,CAAC;IAI5C;;OAEG;IACH,QAAQ,KAAK,OAAO,IAAI,WAAW,CAAC;IAEpC;;OAEG;IACH,WAAW,CAAC,aAAa,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,EAAE,SAAS,CAAC,EAAE,MAAM,EAAE,KAAK,CAAC,EAAE,MAAM,GAAG,UAAU;IAInG;;OAEG;IACH,mBAAmB,CAAC,aAAa,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,EAAE,SAAS,CAAC,EAAE,MAAM,EAAE,KAAK,CAAC,EAAE,MAAM,GAAG,MAAM;IAMvG;;;OAGG;IACH,QAAQ,CAAC,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAEpD;;;OAGG;IACH,QAAQ,CAAC,cAAc,IAAI,MAAM;IAIjC;;;;OAIG;IACH,QAAQ,CAAC,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAEtE;;;;OAIG;IACH,QAAQ,CAAC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI1D;;;;;;OAMG;IACH,QAAQ,CAAC,+BAA+B,CAAC,GAAG,EAAE,MAAM,GAAG,MAAM;IAI7D;;;;OAIG;IACH,QAAQ,CAAC,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAIpF;;;;OAIG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAEpD;;;;;OAKG;IACH,gBAAgB,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAI5C;;;;OAIG;IACH,QAAQ,CAAC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAEvD;;;;OAIG;IACH,QAAQ,CAAC,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAEjF;;;;;;;OAOG;IACH,QAAQ,CAAC,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAEhG;;;;OAIG;IACH,QAAQ,CAAC,YAAY,IAAI,MAAM;IAE/B;;;;;OAKG;IACH,QAAQ,CAAC,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAIjE;;;;;;;;OAQG;IACH,QAAQ,CAAC,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAErG;;;;;;;;OAQG;IACH,QAAQ,CAAC,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAEjG;;;;;;;;OAQG;IACH,QAAQ,CAAC,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAEvF;;;;;;;;;OASG;IACH,QAAQ,CAAC,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAIhD;;OAEG;IACH,QAAQ,CAAC,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAEpD;;OAEG;IACH,QAAQ,CAAC,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAIhD;;OAEG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAEtH;;OAEG;IACH,QAAQ,CAAC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAInG;;OAEG;IACH,QAAQ,CAAC,0BAA0B,IAAI,sBAAsB;IAI7D;;;;;;;OAOG;IACH,QAAQ,CAAC,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAEvD;;;;OAIG;IACH,QAAQ,CAAC,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;CAC7E"}

dist/sqlDialect.js

@@ -10,2 +10,28 @@ /**
     /**
+     * Quotes a value as a SQL string literal. Both SQL Server and PostgreSQL
+     * use single quotes with `''` doubling to escape internal apostrophes —
+     * this is concrete in the base class so callers don't reinvent the
+     * `value.replace(/'/g, "''")` pattern. Subclasses may override if a
+     * future dialect needs a different escape rule.
+     */
+    QuoteStringLiteral(value) {
+        return `'${value.replace(/'/g, "''")}'`;
+    }
+    /**
+     * Wraps an expression in the dialect's lowercase function — used for
+     * case-insensitive comparison when authoring filters that must work on
+     * both SS (default case-insensitive collation) and PG (case-sensitive).
+     *
+     * Both SQL Server and PostgreSQL implement `LOWER()` per the ANSI SQL
+     * standard, so the default returns `LOWER(${expr})`. A subclass would
+     * override only for an exotic dialect (e.g. one that exposes `lc()` or
+     * needs a CAST first).
+     *
+     * Use this instead of hardcoding `LOWER(...)` in callers — keeps the
+     * dialect-aware SQL surface in one place per the SQLDialect contract.
+     */
+    LowerCase(expr) {
+        return `LOWER(${expr})`;
+    }
+    /**
      * Returns the dialect's literal representation of NULL as it would
@@ -32,2 +58,17 @@ * appear in generated SQL (e.g. as the result of a default-value
     /**
+     * Returns a CAST to a bounded-width string type. Used when the result
+     * needs to be comparable against an indexed column (SQL Server cannot
+     * compare/index `NVARCHAR(MAX)`) or against a fixed-width text column
+     * such as MJ's `RecordID` (NVARCHAR(450) on SQL Server).
+     *
+     * Implemented by composing `ResolveAbstractType({ type: 'string', maxLength })`,
+     * which dialects already supply — SQL Server emits `NVARCHAR(N)` and
+     * PostgreSQL emits `VARCHAR(N)`. Defaults to MJ's standard 450-char
+     * width to match the cap on indexable string columns in SQL Server.
+     */
+    CastToBoundedString(expr, maxLength = 450) {
+        const sqlType = this.ResolveAbstractType({ type: 'string', maxLength });
+        return `CAST(${expr} AS ${sqlType})`;
+    }
+    /**
      * Returns the empty-GUID sentinel literal
@@ -34,0 +75,0 @@ * (`00000000-0000-0000-0000-000000000000`) formatted for use in a

dist/sqlDialect.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"sqlDialect.js","sourceRoot":"","sources":["../src/sqlDialect.ts"],"names":[],"mappings":"AAyJA;;;;;;GAMG;AACH,MAAM,OAAgB,UAAU;IA+D5B;;;;;;OAMG;IACH,IAAI,WAAW;QACX,OAAO,MAAM,CAAC;IAClB,CAAC;IAED;;;;;OAKG;IACH,aAAa,CAAC,KAAa;QACvB,IAAI,KAAK,IAAI,IAAI;YAAE,OAAO,KAAK,CAAC;QAChC,OAAO,KAAK,CAAC,IAAI,EAAE,CAAC,WAAW,EAAE,KAAK,IAAI,CAAC,WAAW,CAAC,WAAW,EAAE,CAAC;IACzE,CAAC;IA8BD;;;;;;;OAOG;IACH,gBAAgB;QACZ,OAAO,wCAAwC,CAAC;IACpD,CAAC;IAsGD;;OAEG;IACH,WAAW,CAAC,aAAqB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;QAClF,OAAO,IAAI,CAAC,OAAO,CAAC,OAAO,CAAC,aAAa,EAAE,MAAM,EAAE,SAAS,EAAE,KAAK,CAAC,CAAC;IACzE,CAAC;IAED;;OAEG;IACH,mBAAmB,CAAC,aAAqB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;QAC1F,OAAO,IAAI,CAAC,OAAO,CAAC,eAAe,CAAC,aAAa,EAAE,MAAM,EAAE,SAAS,EAAE,KAAK,CAAC,CAAC;IACjF,CAAC;IAkDD;;;;;OAKG;IACH,gBAAgB,CAAC,UAAkB;QAC/B,OAAO,UAAU,CAAC;IACtB,CAAC;CAyIJ"}
+{"version":3,"file":"sqlDialect.js","sourceRoot":"","sources":["../src/sqlDialect.ts"],"names":[],"mappings":"AA+JA;;;;;;GAMG;AACH,MAAM,OAAgB,UAAU;IAmC5B;;;;;;OAMG;IACH,kBAAkB,CAAC,KAAa;QAC5B,OAAO,IAAI,KAAK,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,GAAG,CAAC;IAC5C,CAAC;IAuCD;;;;;;;;;;;;OAYG;IACH,SAAS,CAAC,IAAY;QAClB,OAAO,SAAS,IAAI,GAAG,CAAC;IAC5B,CAAC;IAgED;;;;;;OAMG;IACH,IAAI,WAAW;QACX,OAAO,MAAM,CAAC;IAClB,CAAC;IAED;;;;;OAKG;IACH,aAAa,CAAC,KAAa;QACvB,IAAI,KAAK,IAAI,IAAI;YAAE,OAAO,KAAK,CAAC;QAChC,OAAO,KAAK,CAAC,IAAI,EAAE,CAAC,WAAW,EAAE,KAAK,IAAI,CAAC,WAAW,CAAC,WAAW,EAAE,CAAC;IACzE,CAAC;IAwBD;;;;;;;;;;OAUG;IACH,mBAAmB,CAAC,IAAY,EAAE,YAAoB,GAAG;QACrD,MAAM,OAAO,GAAG,IAAI,CAAC,mBAAmB,CAAC,EAAE,IAAI,EAAE,QAAQ,EAAE,SAAS,EAAE,CAAC,CAAC;QACxE,OAAO,QAAQ,IAAI,OAAO,OAAO,GAAG,CAAC;IACzC,CAAC;IAQD;;;;;;;OAOG;IACH,gBAAgB;QACZ,OAAO,wCAAwC,CAAC;IACpD,CAAC;IAsGD;;OAEG;IACH,WAAW,CAAC,aAAqB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;QAClF,OAAO,IAAI,CAAC,OAAO,CAAC,OAAO,CAAC,aAAa,EAAE,MAAM,EAAE,SAAS,EAAE,KAAK,CAAC,CAAC;IACzE,CAAC;IAED;;OAEG;IACH,mBAAmB,CAAC,aAAqB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;QAC1F,OAAO,IAAI,CAAC,OAAO,CAAC,eAAe,CAAC,aAAa,EAAE,MAAM,EAAE,SAAS,EAAE,KAAK,CAAC,CAAC;IACjF,CAAC;IA6DD;;;;;OAKG;IACH,gBAAgB,CAAC,UAAkB;QAC/B,OAAO,UAAU,CAAC;IACtB,CAAC;CAyIJ"}

dist/sqlServerDialect.d.ts

@@ -12,4 +12,11 @@ import { DataTypeMap } from './dataTypeMap.js';
     QuoteSchema(schema: string, object: string): string;
+    /**
+     * SQL Server identifiers are case-insensitive by default, so a bare
+     * alias preserves the requested casing when echoed in result-set
+     * column metadata. Bracketed quoting would also work but is unnecessary.
+     */
+    QuoteColumnAlias(aliasName: string): string;
     LimitClause(limit: number, offset?: number): LimitClauseResult;
     BooleanLiteral(value: boolean): string;
+    BooleanParameterType(): string;
     ParameterRef(name: string): string;
@@ -33,4 +40,34 @@ ParameterDefault(value: string): string;
     CurrentTimestampUTC(): string;
+    private static readonly _BooleanTypeNames;
+    private static readonly _StringTypeNames;
+    private static readonly _DateTypeNames;
+    private static readonly _IntegerTypeNames;
+    private static readonly _FloatTypeNames;
+    private static readonly _UuidTypeNames;
+    private static readonly _BinaryTypeNames;
+    private static readonly _JsonTypeNames;
+    private static readonly _CurrencyTypeNames;
+    private static readonly _IntervalTypeNames;
+    private static readonly _NetworkTypeNames;
+    get BooleanTypeNames(): readonly string[];
+    get StringTypeNames(): readonly string[];
+    get DateTypeNames(): readonly string[];
+    get IntegerTypeNames(): readonly string[];
+    get FloatTypeNames(): readonly string[];
+    get UuidTypeNames(): readonly string[];
+    get BinaryTypeNames(): readonly string[];
+    get JsonTypeNames(): readonly string[];
+    get CurrencyTypeNames(): readonly string[];
+    get IntervalTypeNames(): readonly string[];
+    get NetworkTypeNames(): readonly string[];
     NewUUID(): string;
     CastToText(expr: string): string;
+    /**
+     * SQL Server-specific Flyway escape. Interleaves a `CAST(N'' AS NVARCHAR(MAX))`
+     * between the split halves so the running T-SQL concat chain inherits
+     * NVARCHAR(MAX) precedence. Without the cast, `N'a' + N'b'` produces
+     * NVARCHAR(a+b) capped at NVARCHAR(4000) and silently truncates anything
+     * past 4,000 characters.
+     */
+    EscapeFlywayStringInterpolation(sql: string): string;
     CastToUUID(expr: string): string;
@@ -37,0 +74,0 @@ ReturnInsertedClause(columns?: string[]): string;

dist/sqlServerDialect.d.ts.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"sqlServerDialect.d.ts","sourceRoot":"","sources":["../src/sqlServerDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAc,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,EACrB,MAAM,iBAAiB,CAAC;AA6GzB;;;GAGG;AACH,qBAAa,gBAAiB,SAAQ,UAAU;IAC5C,IAAI,WAAW,IAAI,gBAAgB,CAElC;IAED,IAAI,aAAa,IAAI,MAAM,CAE1B;IAID,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIrC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAMnD,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAS9D,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAItC,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIlC,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAIvC;;;;;OAKG;IACH,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI9C;;;;;;OAMG;IACH,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAIhD,mBAAmB,IAAI,MAAM;IAI7B,OAAO,IAAI,MAAM;IAIjB,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAMhC,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAQhD,yBAAyB,IAAI,MAAM;IAInC,aAAa,IAAI,MAAM;IAIvB,uBAAuB,IAAI,MAAM;IAIjC,kBAAkB,IAAI,MAAM;IAM5B,cAAc,IAAI,MAAM;IAIxB,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAkB3E,wBAAwB,CAAC,WAAW,EAAE,MAAM,GAAG,OAAO;IAMtD,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAInE,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAc5E,kBAAkB,IAAI,MAAM;IAI5B,IAAI,kBAAkB,IAAI,OAAO,CAEhC;IAED,IAAI,oBAAoB,IAAI,MAAM,CAEjC;IAID,IAAI,OAAO,IAAI,WAAW,CAEzB;IAID,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAI3C,cAAc,IAAI,MAAM;IAMxB,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAI7D,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAMjD,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAO3E,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAI3C,4EAA4E;IACnE,gBAAgB,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAMrD,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI5F,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAYxF,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAgB9E,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAMvC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAM9C,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAKxE,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAYvF,YAAY,IAAI,MAAM;IAMtB,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAc3C,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAavC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,WAAW,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI9G,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAc1F,0BAA0B,IAAI,sBAAsB;IAkDpD,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAMjE,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IA+BxD,OAAO,CAAC,iBAAiB;IAUzB,OAAO,CAAC,sBAAsB;CASjC"}
+{"version":3,"file":"sqlServerDialect.d.ts","sourceRoot":"","sources":["../src/sqlServerDialect.ts"],"names":[],"mappings":"AAAA,OAAO,EAAE,WAAW,EAAc,MAAM,kBAAkB,CAAC;AAC3D,OAAO,EACH,UAAU,EACV,gBAAgB,EAChB,iBAAiB,EACjB,sBAAsB,EACtB,cAAc,EACd,YAAY,EACZ,gBAAgB,EAChB,kBAAkB,EAClB,kBAAkB,EACrB,MAAM,iBAAiB,CAAC;AA6GzB;;;GAGG;AACH,qBAAa,gBAAiB,SAAQ,UAAU;IAC5C,IAAI,WAAW,IAAI,gBAAgB,CAElC;IAED,IAAI,aAAa,IAAI,MAAM,CAE1B;IAID,eAAe,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIrC,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,GAAG,MAAM;IAInD;;;;OAIG;IACH,gBAAgB,CAAC,SAAS,EAAE,MAAM,GAAG,MAAM;IAM3C,WAAW,CAAC,KAAK,EAAE,MAAM,EAAE,MAAM,CAAC,EAAE,MAAM,GAAG,iBAAiB;IAS9D,cAAc,CAAC,KAAK,EAAE,OAAO,GAAG,MAAM;IAItC,oBAAoB,IAAI,MAAM;IAI9B,YAAY,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIlC,gBAAgB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAIvC;;;;;OAKG;IACH,MAAM,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI9C;;;;;;OAMG;IACH,QAAQ,CAAC,IAAI,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAIhD,mBAAmB,IAAI,MAAM;IAQ7B,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAAoB;IAC7D,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,gBAAgB,CAAsE;IAC9G,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAyF;IAC/H,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAA2F;IACpI,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,eAAe,CAAoD;IAC3F,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAiC;IACvE,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,gBAAgB,CAA6C;IACrF,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,cAAc,CAAoB;IAC1D,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,kBAAkB,CAAoC;IAC9E,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,kBAAkB,CAAe;IACzD,OAAO,CAAC,MAAM,CAAC,QAAQ,CAAC,iBAAiB,CAAe;IAExD,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAgD;IACzF,IAAI,eAAe,IAAI,SAAS,MAAM,EAAE,CAAgD;IACxF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAgD;IACtF,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAgD;IACzF,IAAI,cAAc,IAAI,SAAS,MAAM,EAAE,CAAgD;IACvF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAgD;IACtF,IAAI,eAAe,IAAI,SAAS,MAAM,EAAE,CAAgD;IACxF,IAAI,aAAa,IAAI,SAAS,MAAM,EAAE,CAAgD;IACtF,IAAI,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAgD;IAC1F,IAAI,iBAAiB,IAAI,SAAS,MAAM,EAAE,CAAgD;IAC1F,IAAI,gBAAgB,IAAI,SAAS,MAAM,EAAE,CAAgD;IAEzF,OAAO,IAAI,MAAM;IAIjB,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAIhC;;;;;;OAMG;IACH,+BAA+B,CAAC,GAAG,EAAE,MAAM,GAAG,MAAM;IAIpD,UAAU,CAAC,IAAI,EAAE,MAAM,GAAG,MAAM;IAMhC,oBAAoB,CAAC,OAAO,CAAC,EAAE,MAAM,EAAE,GAAG,MAAM;IAQhD,yBAAyB,IAAI,MAAM;IAInC,aAAa,IAAI,MAAM;IAIvB,uBAAuB,IAAI,MAAM;IAIjC,kBAAkB,IAAI,MAAM;IAM5B,cAAc,IAAI,MAAM;IAIxB,iBAAiB,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAkB3E,wBAAwB,CAAC,WAAW,EAAE,MAAM,GAAG,OAAO;IAMtD,uBAAuB,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAInE,gBAAgB,CAAC,KAAK,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAc5E,kBAAkB,IAAI,MAAM;IAI5B,IAAI,kBAAkB,IAAI,OAAO,CAEhC;IAED,IAAI,oBAAoB,IAAI,MAAM,CAEjC;IAID,IAAI,OAAO,IAAI,WAAW,CAEzB;IAID,oBAAoB,CAAC,KAAK,EAAE,MAAM,GAAG,MAAM;IAI3C,cAAc,IAAI,MAAM;IAMxB,mBAAmB,CAAC,KAAK,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,GAAG,MAAM;IAI7D,WAAW,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAMjD,mBAAmB,CAAC,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,GAAG,MAAM;IAO3E,eAAe,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAI3C,4EAA4E;IACnE,gBAAgB,CAAC,UAAU,EAAE,MAAM,GAAG,MAAM;IAMrD,iBAAiB,CAAC,IAAI,EAAE,QAAQ,GAAG,MAAM,GAAG,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAI5F,yBAAyB,CAAC,MAAM,EAAE,MAAM,EAAE,SAAS,EAAE,MAAM,EAAE,UAAU,EAAE,MAAM,GAAG,MAAM;IAYxF,gBAAgB,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,OAAO,CAAC,EAAE,MAAM,GAAG,MAAM;IAgB9E,cAAc,CAAC,OAAO,EAAE,MAAM,GAAG,MAAM;IAMvC,eAAe,CAAC,GAAG,EAAE,gBAAgB,GAAG,MAAM;IAM9C,cAAc,CAAC,WAAW,EAAE,MAAM,EAAE,OAAO,EAAE,kBAAkB,GAAG,MAAM;IAKxE,eAAe,CAAC,MAAM,EAAE,MAAM,EAAE,KAAK,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAYvF,YAAY,IAAI,MAAM;IAMtB,UAAU,CAAC,OAAO,EAAE,cAAc,GAAG,MAAM;IAc3C,QAAQ,CAAC,OAAO,EAAE,YAAY,GAAG,MAAM;IAavC,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,WAAW,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,GAAG,MAAM;IAI9G,eAAe,CAAC,UAAU,EAAE,MAAM,EAAE,MAAM,EAAE,MAAM,EAAE,IAAI,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,GAAG,MAAM;IAc1F,0BAA0B,IAAI,sBAAsB;IAkDpD,GAAG,CAAC,SAAS,EAAE,MAAM,EAAE,OAAO,EAAE,MAAM,EAAE,QAAQ,EAAE,MAAM,GAAG,MAAM;IAMjE,mBAAmB,CAAC,OAAO,EAAE,kBAAkB,GAAG,MAAM;IA+BxD,OAAO,CAAC,iBAAiB;IAUzB,OAAO,CAAC,sBAAsB;CASjC"}

dist/sqlServerDialect.js

@@ -121,2 +121,10 @@ import { SQLDialect, } from './sqlDialect.js';
     }
+    /**
+     * SQL Server identifiers are case-insensitive by default, so a bare
+     * alias preserves the requested casing when echoed in result-set
+     * column metadata. Bracketed quoting would also work but is unnecessary.
+     */
+    QuoteColumnAlias(aliasName) {
+        return aliasName;
+    }
     // ─── Pagination ──────────────────────────────────────────────────
@@ -133,2 +141,5 @@ LimitClause(limit, offset) {
     }
+    BooleanParameterType() {
+        return 'bit';
+    }
     ParameterRef(name) {
@@ -162,2 +173,27 @@ return `@${name}`;
     }
+    // ─── Type-Name Sets ──────────────────────────────────────────────
+    // SQL Server's column-type names as they appear in `sys.columns.name`
+    // / `EntityField.Type` for entities backed by a SQL Server schema.
+    static { this._BooleanTypeNames = ['bit']; }
+    static { this._StringTypeNames = ['text', 'ntext', 'varchar', 'nvarchar', 'char', 'nchar']; }
+    static { this._DateTypeNames = ['date', 'time', 'datetime', 'datetime2', 'datetimeoffset', 'smalldatetime']; }
+    static { this._IntegerTypeNames = ['int', 'integer', 'bigint', 'smallint', 'tinyint', 'rowversion', 'timestamp']; }
+    static { this._FloatTypeNames = ['decimal', 'numeric', 'float', 'real']; }
+    static { this._UuidTypeNames = ['uniqueidentifier']; }
+    static { this._BinaryTypeNames = ['binary', 'varbinary', 'image']; }
+    static { this._JsonTypeNames = ['xml']; }
+    static { this._CurrencyTypeNames = ['money', 'smallmoney']; }
+    static { this._IntervalTypeNames = []; }
+    static { this._NetworkTypeNames = []; }
+    get BooleanTypeNames() { return SQLServerDialect._BooleanTypeNames; }
+    get StringTypeNames() { return SQLServerDialect._StringTypeNames; }
+    get DateTypeNames() { return SQLServerDialect._DateTypeNames; }
+    get IntegerTypeNames() { return SQLServerDialect._IntegerTypeNames; }
+    get FloatTypeNames() { return SQLServerDialect._FloatTypeNames; }
+    get UuidTypeNames() { return SQLServerDialect._UuidTypeNames; }
+    get BinaryTypeNames() { return SQLServerDialect._BinaryTypeNames; }
+    get JsonTypeNames() { return SQLServerDialect._JsonTypeNames; }
+    get CurrencyTypeNames() { return SQLServerDialect._CurrencyTypeNames; }
+    get IntervalTypeNames() { return SQLServerDialect._IntervalTypeNames; }
+    get NetworkTypeNames() { return SQLServerDialect._NetworkTypeNames; }
     NewUUID() {
@@ -169,2 +205,12 @@ return 'NEWID()';
     }
+    /**
+     * SQL Server-specific Flyway escape. Interleaves a `CAST(N'' AS NVARCHAR(MAX))`
+     * between the split halves so the running T-SQL concat chain inherits
+     * NVARCHAR(MAX) precedence. Without the cast, `N'a' + N'b'` produces
+     * NVARCHAR(a+b) capped at NVARCHAR(4000) and silently truncates anything
+     * past 4,000 characters.
+     */
+    EscapeFlywayStringInterpolation(sql) {
+        return sql.replaceAll(/\$\{/g, "$$'+CAST(N'' AS NVARCHAR(MAX))+N'{");
+    }
     CastToUUID(expr) {
@@ -171,0 +217,0 @@ return `CAST(${expr} AS UNIQUEIDENTIFIER)`;

dist/sqlServerDialect.js.map

@@ -1,1 +0,1 @@
-{"version":3,"file":"sqlServerDialect.js","sourceRoot":"","sources":["../src/sqlServerDialect.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAEzB;;;;GAIG;AACH,MAAM,oBAAoB;IACtB,OAAO,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QAC7F,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC,IAAI,EAAE,CAAC;QAEnD,QAAQ,UAAU,EAAE,CAAC;YACjB,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAClG,KAAK,UAAU;gBACX,OAAO,IAAI,CAAC,iBAAiB,CAAC,YAAY,CAAC,CAAC;YAChD,KAAK,SAAS;gBACV,OAAO,IAAI,CAAC,gBAAgB,CAAC,YAAY,CAAC,CAAC;YAC/C,KAAK,OAAO,CAAC;YACb,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YAC3H,KAAK,KAAK,CAAC;YACX,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,KAAK,SAAS,CAAC;YACf,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,IAAI,EAAE,CAAC;YACzF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,YAAY;gBACb,OAAO,EAAE,QAAQ,EAAE,YAAY,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC5F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,gBAAgB;gBACjB,OAAO,EAAE,QAAQ,EAAE,gBAAgB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAChG,KAAK,eAAe;gBAChB,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,MAAM,CAAC;YACZ,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,EAAE,CAAC;YACvH,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YACzH,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF;gBACI,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;IACL,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QACrG,MAAM,MAAM,GAAG,IAAI,CAAC,OAAO,CAAC,UAAU,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;QACpF,OAAO,gBAAgB,CAAC,MAAM,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;IAChF,CAAC;IAEO,iBAAiB,CAAC,MAAe;QACrC,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC/F,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAChH,CAAC;IAEO,gBAAgB,CAAC,MAAe;QACpC,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,cAAc,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;CACJ;AAED;;GAEG;AACH,SAAS,gBAAgB,CAAC,MAAkB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;IAC7F,IAAI,MAAM,CAAC,sBAAsB,IAAI,SAAS,IAAI,IAAI,EAAE,CAAC;QACrD,OAAO,KAAK,IAAI,IAAI;YAChB,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,IAAI,KAAK,GAAG;YAC7C,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,GAAG,CAAC;IAC7C,CAAC;IACD,IAAI,MAAM,CAAC,cAAc,EAAE,CAAC;QACxB,MAAM,GAAG,GAAG,MAAM,IAAI,MAAM,CAAC,aAAa,CAAC;QAC3C,IAAI,GAAG,IAAI,IAAI,EAAE,CAAC;YACd,OAAO,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,OAAO,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,GAAG,GAAG,CAAC;QACjF,CAAC;IACL,CAAC;IACD,OAAO,MAAM,CAAC,QAAQ,CAAC;AAC3B,CAAC;AAED;;;GAGG;AACH,MAAM,OAAO,gBAAiB,SAAQ,UAAU;IAC5C,IAAI,WAAW;QACX,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,IAAI,aAAa;QACb,OAAO,aAAa,CAAC;IACzB,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,IAAY;QACxB,OAAO,IAAI,IAAI,GAAG,CAAC;IACvB,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,MAAc;QACtC,OAAO,IAAI,MAAM,MAAM,MAAM,GAAG,CAAC;IACrC,CAAC;IAED,oEAAoE;IAEpE,WAAW,CAAC,KAAa,EAAE,MAAe;QACtC,IAAI,MAAM,IAAI,IAAI,EAAE,CAAC;YACjB,OAAO,EAAE,MAAM,EAAE,EAAE,EAAE,MAAM,EAAE,UAAU,MAAM,oBAAoB,KAAK,YAAY,EAAE,CAAC;QACzF,CAAC;QACD,OAAO,EAAE,MAAM,EAAE,OAAO,KAAK,EAAE,EAAE,MAAM,EAAE,EAAE,EAAE,CAAC;IAClD,CAAC;IAED,oEAAoE;IAEpE,cAAc,CAAC,KAAc;QACzB,OAAO,KAAK,CAAC,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC,GAAG,CAAC;IAC7B,CAAC;IAED,YAAY,CAAC,IAAY;QACrB,OAAO,IAAI,IAAI,EAAE,CAAC;IACtB,CAAC;IAED,gBAAgB,CAAC,KAAa;QAC1B,OAAO,MAAM,KAAK,EAAE,CAAC;IACzB,CAAC;IAED;;;;;OAKG;IACH,MAAM,CAAC,IAAY,EAAE,QAAgB;QACjC,OAAO,UAAU,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC1C,CAAC;IAED;;;;;;OAMG;IACH,QAAQ,CAAC,IAAY,EAAE,QAAgB;QACnC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED,mBAAmB;QACf,OAAO,cAAc,CAAC;IAC1B,CAAC;IAED,OAAO;QACH,OAAO,SAAS,CAAC;IACrB,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,oBAAoB,CAAC;IAC5C,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,uBAAuB,CAAC;IAC/C,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,OAAkB;QACnC,IAAI,OAAO,IAAI,OAAO,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAChC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,aAAa,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YAC5D,OAAO,UAAU,IAAI,EAAE,CAAC;QAC5B,CAAC;QACD,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,yBAAyB;QACrB,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,aAAa;QACT,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,uBAAuB;QACnB,OAAO,kBAAkB,CAAC;IAC9B,CAAC;IAED,kBAAkB;QACd,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,oEAAoE;IAEpE,cAAc;QACV,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,iBAAiB,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY;QAC9D,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,QAAQ,cAAc,EAAE,CAAC;YACrB,KAAK,OAAO;gBACR,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,MAAM;gBACP,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,WAAW;gBACZ,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,UAAU;gBACX,OAAO,kBAAkB,MAAM,MAAM,IAAI,uBAAuB,CAAC;YACrE,KAAK,SAAS;gBACV,OAAO,kBAAkB,MAAM,MAAM,IAAI,uBAAuB,CAAC;YACrE;gBACI,OAAO,kBAAkB,MAAM,MAAM,IAAI,iBAAiB,CAAC;QACnE,CAAC;IACL,CAAC;IAED,wBAAwB,CAAC,WAAmB;QACxC,OAAO,KAAK,CAAC,CAAC,gDAAgD;IAClE,CAAC;IAED,oEAAoE;IAEpE,uBAAuB,CAAC,MAAc,EAAE,UAAkB;QACtD,OAAO,YAAY,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,KAAK,UAAU,GAAG,CAAC;IACtE,CAAC;IAED,gBAAgB,CAAC,KAAa,EAAE,OAAiB,EAAE,OAAgB;QAC/D,MAAM,OAAO,GAAG,OAAO,IAAI,QAAQ,CAAC;QACpC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,eAAe,CAAC,CAAC,CAAC,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAClE,MAAM,KAAK,GAAa,EAAE,CAAC;QAC3B,KAAK,CAAC,IAAI,CAAC,oEAAoE,OAAO,IAAI,CAAC,CAAC;QAC5F,KAAK,CAAC,IAAI,CAAC,gCAAgC,OAAO,IAAI,CAAC,CAAC;QACxD,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QACf,KAAK,CAAC,IAAI,CAAC,4BAA4B,KAAK,IAAI,IAAI,GAAG,CAAC,CAAC;QACzD,KAAK,CAAC,IAAI,CAAC,oBAAoB,KAAK,CAAC,OAAO,CAAC,UAAU,EAAE,EAAE,CAAC,QAAQ,OAAO,IAAI,CAAC,CAAC;QACjF,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,oEAAoE;IAEpE,kBAAkB;QACd,OAAO,MAAM,CAAC;IAClB,CAAC;IAED,IAAI,kBAAkB;QAClB,OAAO,KAAK,CAAC;IACjB,CAAC;IAED,IAAI,oBAAoB;QACpB,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,oEAAoE;IAEpE,IAAI,OAAO;QACP,OAAO,IAAI,oBAAoB,EAAE,CAAC;IACtC,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,KAAa;QAC9B,OAAO,KAAK,KAAK,EAAE,CAAC;IACxB,CAAC;IAED,cAAc;QACV,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,KAAa,EAAE,SAAiB;QAChD,OAAO,gBAAgB,KAAK,KAAK,SAAS,GAAG,CAAC;IAClD,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,IAAY;QACpC,OAAO,cAAc,MAAM,MAAM,IAAI,IAAI,CAAC;IAC9C,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,MAAc,EAAE,IAAY,EAAE,MAAgB;QAC9D,MAAM,SAAS,GAAG,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACpC,OAAO,SAAS,MAAM,MAAM,IAAI,KAAK,SAAS,EAAE,CAAC;IACrD,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,UAAkB;QAC9B,OAAO,0DAA0D,UAAU,gCAAgC,UAAU,UAAU,CAAC;IACpI,CAAC;IAED,4EAA4E;IACnE,gBAAgB,CAAC,UAAkB;QACxC,OAAO,UAAU,CAAC,WAAW,EAAE,KAAK,eAAe,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC,CAAC,UAAU,CAAC;IACvF,CAAC;IAED,mEAAmE;IAEnE,iBAAiB,CAAC,IAA+B,EAAE,MAAc,EAAE,QAAgB;QAC/E,OAAO,WAAW,IAAI,KAAK,MAAM,KAAK,QAAQ,GAAG,CAAC;IACtD,CAAC;IAED,yBAAyB,CAAC,MAAc,EAAE,SAAiB,EAAE,UAAkB;QAC3E,MAAM,WAAW,GAAG,IAAI,CAAC,WAAW,CAAC,MAAM,EAAE,SAAS,CAAC,CAAC;QACxD,OAAO;YACH,2GAA2G,MAAM,iBAAiB,SAAS,IAAI;YAC/I,OAAO;YACP,kBAAkB,WAAW,IAAI;YACjC,UAAU;YACV,MAAM;YACN,MAAM;SACT,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,gBAAgB,CAAC,SAAiB,EAAE,OAAe,EAAE,OAAgB;QACjE,MAAM,KAAK,GAAG;YACV,MAAM,SAAS,EAAE;YACjB,OAAO;YACP,KAAK,OAAO,EAAE;YACd,KAAK;SACR,CAAC;QACF,IAAI,OAAO,EAAE,CAAC;YACV,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;YACnB,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;YACpB,KAAK,CAAC,IAAI,CAAC,KAAK,OAAO,EAAE,CAAC,CAAC;YAC3B,KAAK,CAAC,IAAI,CAAC,KAAK,CAAC,CAAC;QACtB,CAAC;QACD,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,cAAc,CAAC,OAAe;QAC1B,OAAO,cAAc,OAAO,WAAW,CAAC;IAC5C,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,GAAqB;QACjC,MAAM,QAAQ,GAAG,GAAG,CAAC,QAAQ,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QACpD,MAAM,WAAW,GAAG,GAAG,CAAC,YAAY,IAAI,IAAI,CAAC,CAAC,CAAC,YAAY,GAAG,CAAC,YAAY,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QACnF,OAAO,QAAQ,GAAG,CAAC,IAAI,KAAK,GAAG,CAAC,OAAO,IAAI,QAAQ,GAAG,WAAW,EAAE,CAAC;IACxE,CAAC;IAED,cAAc,CAAC,WAAmB,EAAE,OAA2B;QAC3D,MAAM,QAAQ,GAAG,OAAO,CAAC,WAAW,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QAC3D,OAAO,eAAe,WAAW,uBAAuB,OAAO,CAAC,UAAU,KAAK,OAAO,CAAC,OAAO,IAAI,QAAQ,GAAG,CAAC;IAClH,CAAC;IAED,eAAe,CAAC,MAAc,EAAE,KAAa,EAAE,MAAc,EAAE,OAAe;QAC1E,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QAC5C,OAAO;YACH,6BAA6B;YAC7B,gCAAgC;YAChC,kBAAkB,OAAO,IAAI;YAC7B,+CAA+C,MAAM,IAAI;YACzD,8CAA8C,KAAK,IAAI;YACvD,+CAA+C,MAAM,IAAI;SAC5D,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,YAAY;QACR,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,mEAAmE;IAEnE,UAAU,CAAC,OAAuB;QAC9B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACzC,MAAM,KAAK,GAAa,EAAE,CAAC;QAC3B,KAAK,CAAC,IAAI,CAAC,mBAAmB,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,WAAW,GAAG,CAAC,CAAC;QAC1E,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,SAAS,GAAG,CAAC,CAAC;QAC5D,KAAK,CAAC,IAAI,CAAC,GAAG,OAAO,CAAC,MAAM,IAAI,MAAM,EAAE,CAAC,CAAC;QAC1C,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACjB,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,qBAAqB,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,KAAK,CAAC,CAAC;QAClB,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,QAAQ,CAAC,OAAqB;QAC1B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,EAAE,CAAC;QAC/C,MAAM,IAAI,GAAG,OAAO,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC3D,IAAI,GAAG,GAAG,UAAU,MAAM,UAAU,OAAO,CAAC,SAAS,SAAS,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,SAAS,KAAK,IAAI,GAAG,CAAC;QAChH,IAAI,OAAO,CAAC,cAAc,IAAI,OAAO,CAAC,cAAc,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAC9D,MAAM,GAAG,GAAG,OAAO,CAAC,cAAc,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YACjE,GAAG,IAAI,aAAa,GAAG,GAAG,CAAC;QAC/B,CAAC;QACD,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,UAAkB,EAAE,WAAmB,EAAE,MAAc,EAAE,MAAc,EAAE,IAAY;QACjG,OAAO,SAAS,UAAU,QAAQ,MAAM,MAAM,MAAM,SAAS,IAAI,GAAG,CAAC;IACzE,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY,EAAE,OAAe;QAC7E,MAAM,cAAc,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QACnD,MAAM,UAAU,GAAG,IAAI,CAAC,sBAAsB,CAAC,UAAU,CAAC,CAAC;QAC3D,OAAO;YACH,6BAA6B;YAC7B,gCAAgC;YAChC,kBAAkB,cAAc,IAAI;YACpC,gDAAgD,MAAM,IAAI;YAC1D,uBAAuB,UAAU,sBAAsB,IAAI,GAAG;SACjE,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,oEAAoE;IAEpE,0BAA0B;QACtB,OAAO;YACH,UAAU,EAAE;;;;;gCAKQ;YACpB,WAAW,EAAE;;;;;;;;qCAQY;YACzB,eAAe,EAAE;;;;;;kEAMqC;YACtD,eAAe,EAAE;;;;;;;;;;;iCAWI;YACrB,WAAW,EAAE;;;;;;;gDAOuB;YACpC,YAAY,EAAE,4CAA4C;SAC7D,CAAC;IACN,CAAC;IAED,oEAAoE;IAEpE,GAAG,CAAC,SAAiB,EAAE,OAAe,EAAE,QAAgB;QACpD,OAAO,OAAO,SAAS,KAAK,OAAO,KAAK,QAAQ,GAAG,CAAC;IACxD,CAAC;IAED,qEAAqE;IAErE,mBAAmB,CAAC,OAA2B;QAC3C,QAAQ,OAAO,CAAC,IAAI,EAAE,CAAC;YACnB,KAAK,QAAQ;gBACT,OAAO,IAAI,CAAC,iBAAiB,CAAC,OAAO,CAAC,SAAS,CAAC,CAAC;YACrD,KAAK,MAAM;gBACP,OAAO,eAAe,CAAC;YAC3B,KAAK,SAAS;gBACV,OAAO,KAAK,CAAC;YACjB,KAAK,QAAQ;gBACT,OAAO,QAAQ,CAAC;YACpB,KAAK,SAAS;gBACV,OAAO,WAAW,OAAO,CAAC,SAAS,IAAI,EAAE,IAAI,OAAO,CAAC,KAAK,IAAI,CAAC,GAAG,CAAC;YACvE,KAAK,SAAS;gBACV,OAAO,KAAK,CAAC;YACjB,KAAK,UAAU;gBACX,OAAO,gBAAgB,CAAC;YAC5B,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,kBAAkB,CAAC;YAC9B,KAAK,MAAM;gBACP,OAAO,eAAe,CAAC;YAC3B,KAAK,OAAO;gBACR,OAAO,OAAO,CAAC;YACnB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB;gBACI,OAAO,IAAI,CAAC,YAAY,EAAE,CAAC;QACnC,CAAC;IACL,CAAC;IAEO,iBAAiB,CAAC,SAAkB;QACxC,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,GAAG,CAAC,EAAE,CAAC;YACrC,IAAI,SAAS,GAAG,IAAI;gBAAE,OAAO,eAAe,CAAC;YAC7C,OAAO,YAAY,SAAS,GAAG,CAAC;QACpC,CAAC;QACD,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,oEAAoE;IAE5D,sBAAsB,CAAC,UAAkB;QAC7C,QAAQ,UAAU,CAAC,WAAW,EAAE,EAAE,CAAC;YAC/B,KAAK,OAAO,CAAC,CAAC,OAAO,OAAO,CAAC;YAC7B,KAAK,MAAM,CAAC,CAAC,OAAO,MAAM,CAAC;YAC3B,KAAK,WAAW,CAAC,CAAC,OAAO,WAAW,CAAC;YACrC,KAAK,UAAU,CAAC,CAAC,OAAO,UAAU,CAAC;YACnC,OAAO,CAAC,CAAC,OAAO,UAAU,CAAC,WAAW,EAAE,CAAC;QAC7C,CAAC;IACL,CAAC;CACJ"}
+{"version":3,"file":"sqlServerDialect.js","sourceRoot":"","sources":["../src/sqlServerDialect.ts"],"names":[],"mappings":"AACA,OAAO,EACH,UAAU,GASb,MAAM,iBAAiB,CAAC;AAEzB;;;;GAIG;AACH,MAAM,oBAAoB;IACtB,OAAO,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QAC7F,MAAM,UAAU,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC,IAAI,EAAE,CAAC;QAEnD,QAAQ,UAAU,EAAE,CAAC;YACjB,KAAK,kBAAkB;gBACnB,OAAO,EAAE,QAAQ,EAAE,kBAAkB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAClG,KAAK,UAAU;gBACX,OAAO,IAAI,CAAC,iBAAiB,CAAC,YAAY,CAAC,CAAC;YAChD,KAAK,SAAS;gBACV,OAAO,IAAI,CAAC,gBAAgB,CAAC,YAAY,CAAC,CAAC;YAC/C,KAAK,OAAO,CAAC;YACb,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YAC3H,KAAK,KAAK,CAAC;YACX,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACxF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACzF,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF,KAAK,SAAS,CAAC;YACf,KAAK,SAAS;gBACV,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,IAAI,EAAE,CAAC;YACzF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,YAAY;gBACb,OAAO,EAAE,QAAQ,EAAE,YAAY,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC5F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,UAAU;gBACX,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC3F,KAAK,gBAAgB;gBACjB,OAAO,EAAE,QAAQ,EAAE,gBAAgB,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAChG,KAAK,eAAe;gBAChB,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC/F,KAAK,MAAM;gBACP,OAAO,EAAE,QAAQ,EAAE,MAAM,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACtF,KAAK,MAAM,CAAC;YACZ,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YAC1F,KAAK,OAAO;gBACR,OAAO,EAAE,QAAQ,EAAE,OAAO,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACvF,KAAK,WAAW;gBACZ,OAAO,EAAE,QAAQ,EAAE,WAAW,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,EAAE,CAAC;YACvH,KAAK,QAAQ;gBACT,OAAO,EAAE,QAAQ,EAAE,QAAQ,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,YAAY,IAAI,CAAC,EAAE,CAAC;YACzH,KAAK,KAAK;gBACN,OAAO,EAAE,QAAQ,EAAE,KAAK,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;YACrF;gBACI,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;IACL,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,YAAqB,EAAE,eAAwB,EAAE,WAAoB;QACrG,MAAM,MAAM,GAAG,IAAI,CAAC,OAAO,CAAC,UAAU,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;QACpF,OAAO,gBAAgB,CAAC,MAAM,EAAE,YAAY,EAAE,eAAe,EAAE,WAAW,CAAC,CAAC;IAChF,CAAC;IAEO,iBAAiB,CAAC,MAAe;QACrC,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,eAAe,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC/F,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,UAAU,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAChH,CAAC;IAEO,gBAAgB,CAAC,MAAe;QACpC,IAAI,MAAM,KAAK,CAAC,CAAC,IAAI,MAAM,KAAK,SAAS,EAAE,CAAC;YACxC,OAAO,EAAE,QAAQ,EAAE,cAAc,EAAE,cAAc,EAAE,KAAK,EAAE,sBAAsB,EAAE,KAAK,EAAE,CAAC;QAC9F,CAAC;QACD,OAAO,EAAE,QAAQ,EAAE,SAAS,EAAE,cAAc,EAAE,IAAI,EAAE,sBAAsB,EAAE,KAAK,EAAE,aAAa,EAAE,MAAM,EAAE,CAAC;IAC/G,CAAC;CACJ;AAED;;GAEG;AACH,SAAS,gBAAgB,CAAC,MAAkB,EAAE,MAAe,EAAE,SAAkB,EAAE,KAAc;IAC7F,IAAI,MAAM,CAAC,sBAAsB,IAAI,SAAS,IAAI,IAAI,EAAE,CAAC;QACrD,OAAO,KAAK,IAAI,IAAI;YAChB,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,IAAI,KAAK,GAAG;YAC7C,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,SAAS,GAAG,CAAC;IAC7C,CAAC;IACD,IAAI,MAAM,CAAC,cAAc,EAAE,CAAC;QACxB,MAAM,GAAG,GAAG,MAAM,IAAI,MAAM,CAAC,aAAa,CAAC;QAC3C,IAAI,GAAG,IAAI,IAAI,EAAE,CAAC;YACd,OAAO,GAAG,KAAK,CAAC,CAAC,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,OAAO,CAAC,CAAC,CAAC,GAAG,MAAM,CAAC,QAAQ,IAAI,GAAG,GAAG,CAAC;QACjF,CAAC;IACL,CAAC;IACD,OAAO,MAAM,CAAC,QAAQ,CAAC;AAC3B,CAAC;AAED;;;GAGG;AACH,MAAM,OAAO,gBAAiB,SAAQ,UAAU;IAC5C,IAAI,WAAW;QACX,OAAO,WAAW,CAAC;IACvB,CAAC;IAED,IAAI,aAAa;QACb,OAAO,aAAa,CAAC;IACzB,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,IAAY;QACxB,OAAO,IAAI,IAAI,GAAG,CAAC;IACvB,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,MAAc;QACtC,OAAO,IAAI,MAAM,MAAM,MAAM,GAAG,CAAC;IACrC,CAAC;IAED;;;;OAIG;IACH,gBAAgB,CAAC,SAAiB;QAC9B,OAAO,SAAS,CAAC;IACrB,CAAC;IAED,oEAAoE;IAEpE,WAAW,CAAC,KAAa,EAAE,MAAe;QACtC,IAAI,MAAM,IAAI,IAAI,EAAE,CAAC;YACjB,OAAO,EAAE,MAAM,EAAE,EAAE,EAAE,MAAM,EAAE,UAAU,MAAM,oBAAoB,KAAK,YAAY,EAAE,CAAC;QACzF,CAAC;QACD,OAAO,EAAE,MAAM,EAAE,OAAO,KAAK,EAAE,EAAE,MAAM,EAAE,EAAE,EAAE,CAAC;IAClD,CAAC;IAED,oEAAoE;IAEpE,cAAc,CAAC,KAAc;QACzB,OAAO,KAAK,CAAC,CAAC,CAAC,GAAG,CAAC,CAAC,CAAC,GAAG,CAAC;IAC7B,CAAC;IAED,oBAAoB;QAChB,OAAO,KAAK,CAAC;IACjB,CAAC;IAED,YAAY,CAAC,IAAY;QACrB,OAAO,IAAI,IAAI,EAAE,CAAC;IACtB,CAAC;IAED,gBAAgB,CAAC,KAAa;QAC1B,OAAO,MAAM,KAAK,EAAE,CAAC;IACzB,CAAC;IAED;;;;;OAKG;IACH,MAAM,CAAC,IAAY,EAAE,QAAgB;QACjC,OAAO,UAAU,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC1C,CAAC;IAED;;;;;;OAMG;IACH,QAAQ,CAAC,IAAY,EAAE,QAAgB;QACnC,OAAO,YAAY,IAAI,KAAK,QAAQ,GAAG,CAAC;IAC5C,CAAC;IAED,mBAAmB;QACf,OAAO,cAAc,CAAC;IAC1B,CAAC;IAED,oEAAoE;IACpE,sEAAsE;IACtE,mEAAmE;aAE3C,sBAAiB,GAAG,CAAC,KAAK,CAAU,CAAC;aACrC,qBAAgB,GAAG,CAAC,MAAM,EAAE,OAAO,EAAE,SAAS,EAAE,UAAU,EAAE,MAAM,EAAE,OAAO,CAAU,CAAC;aACtF,mBAAc,GAAG,CAAC,MAAM,EAAE,MAAM,EAAE,UAAU,EAAE,WAAW,EAAE,gBAAgB,EAAE,eAAe,CAAU,CAAC;aACvG,sBAAiB,GAAG,CAAC,KAAK,EAAE,SAAS,EAAE,QAAQ,EAAE,UAAU,EAAE,SAAS,EAAE,YAAY,EAAE,WAAW,CAAU,CAAC;aAC5G,oBAAe,GAAG,CAAC,SAAS,EAAE,SAAS,EAAE,OAAO,EAAE,MAAM,CAAU,CAAC;aACnE,mBAAc,GAAG,CAAC,kBAAkB,CAAU,CAAC;aAC/C,qBAAgB,GAAG,CAAC,QAAQ,EAAE,WAAW,EAAE,OAAO,CAAU,CAAC;aAC7D,mBAAc,GAAG,CAAC,KAAK,CAAU,CAAC;aAClC,uBAAkB,GAAG,CAAC,OAAO,EAAE,YAAY,CAAU,CAAC;aACtD,uBAAkB,GAAG,EAAW,CAAC;aACjC,sBAAiB,GAAG,EAAW,CAAC;IAExD,IAAI,gBAAgB,KAAyB,OAAO,gBAAgB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IACzF,IAAI,eAAe,KAA0B,OAAO,gBAAgB,CAAC,gBAAgB,CAAC,CAAC,CAAC;IACxF,IAAI,aAAa,KAA4B,OAAO,gBAAgB,CAAC,cAAc,CAAC,CAAC,CAAC;IACtF,IAAI,gBAAgB,KAAyB,OAAO,gBAAgB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IACzF,IAAI,cAAc,KAA2B,OAAO,gBAAgB,CAAC,eAAe,CAAC,CAAC,CAAC;IACvF,IAAI,aAAa,KAA4B,OAAO,gBAAgB,CAAC,cAAc,CAAC,CAAC,CAAC;IACtF,IAAI,eAAe,KAA0B,OAAO,gBAAgB,CAAC,gBAAgB,CAAC,CAAC,CAAC;IACxF,IAAI,aAAa,KAA4B,OAAO,gBAAgB,CAAC,cAAc,CAAC,CAAC,CAAC;IACtF,IAAI,iBAAiB,KAAwB,OAAO,gBAAgB,CAAC,kBAAkB,CAAC,CAAC,CAAC;IAC1F,IAAI,iBAAiB,KAAwB,OAAO,gBAAgB,CAAC,kBAAkB,CAAC,CAAC,CAAC;IAC1F,IAAI,gBAAgB,KAAyB,OAAO,gBAAgB,CAAC,iBAAiB,CAAC,CAAC,CAAC;IAEzF,OAAO;QACH,OAAO,SAAS,CAAC;IACrB,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,oBAAoB,CAAC;IAC5C,CAAC;IAED;;;;;;OAMG;IACH,+BAA+B,CAAC,GAAW;QACvC,OAAO,GAAG,CAAC,UAAU,CAAC,OAAO,EAAE,oCAAoC,CAAC,CAAC;IACzE,CAAC;IAED,UAAU,CAAC,IAAY;QACnB,OAAO,QAAQ,IAAI,uBAAuB,CAAC;IAC/C,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,OAAkB;QACnC,IAAI,OAAO,IAAI,OAAO,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAChC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,aAAa,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YAC5D,OAAO,UAAU,IAAI,EAAE,CAAC;QAC5B,CAAC;QACD,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,yBAAyB;QACrB,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,aAAa;QACT,OAAO,mBAAmB,CAAC;IAC/B,CAAC;IAED,uBAAuB;QACnB,OAAO,kBAAkB,CAAC;IAC9B,CAAC;IAED,kBAAkB;QACd,OAAO,YAAY,CAAC;IACxB,CAAC;IAED,oEAAoE;IAEpE,cAAc;QACV,OAAO,IAAI,CAAC;IAChB,CAAC;IAED,iBAAiB,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY;QAC9D,MAAM,cAAc,GAAG,UAAU,CAAC,WAAW,EAAE,CAAC;QAChD,QAAQ,cAAc,EAAE,CAAC;YACrB,KAAK,OAAO;gBACR,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,MAAM;gBACP,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,WAAW;gBACZ,OAAO,kBAAkB,MAAM,MAAM,IAAI,sBAAsB,CAAC;YACpE,KAAK,UAAU;gBACX,OAAO,kBAAkB,MAAM,MAAM,IAAI,uBAAuB,CAAC;YACrE,KAAK,SAAS;gBACV,OAAO,kBAAkB,MAAM,MAAM,IAAI,uBAAuB,CAAC;YACrE;gBACI,OAAO,kBAAkB,MAAM,MAAM,IAAI,iBAAiB,CAAC;QACnE,CAAC;IACL,CAAC;IAED,wBAAwB,CAAC,WAAmB;QACxC,OAAO,KAAK,CAAC,CAAC,gDAAgD;IAClE,CAAC;IAED,oEAAoE;IAEpE,uBAAuB,CAAC,MAAc,EAAE,UAAkB;QACtD,OAAO,YAAY,IAAI,CAAC,eAAe,CAAC,MAAM,CAAC,KAAK,UAAU,GAAG,CAAC;IACtE,CAAC;IAED,gBAAgB,CAAC,KAAa,EAAE,OAAiB,EAAE,OAAgB;QAC/D,MAAM,OAAO,GAAG,OAAO,IAAI,QAAQ,CAAC;QACpC,MAAM,IAAI,GAAG,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,eAAe,CAAC,CAAC,CAAC,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAClE,MAAM,KAAK,GAAa,EAAE,CAAC;QAC3B,KAAK,CAAC,IAAI,CAAC,oEAAoE,OAAO,IAAI,CAAC,CAAC;QAC5F,KAAK,CAAC,IAAI,CAAC,gCAAgC,OAAO,IAAI,CAAC,CAAC;QACxD,KAAK,CAAC,IAAI,CAAC,EAAE,CAAC,CAAC;QACf,KAAK,CAAC,IAAI,CAAC,4BAA4B,KAAK,IAAI,IAAI,GAAG,CAAC,CAAC;QACzD,KAAK,CAAC,IAAI,CAAC,oBAAoB,KAAK,CAAC,OAAO,CAAC,UAAU,EAAE,EAAE,CAAC,QAAQ,OAAO,IAAI,CAAC,CAAC;QACjF,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,oEAAoE;IAEpE,kBAAkB;QACd,OAAO,MAAM,CAAC;IAClB,CAAC;IAED,IAAI,kBAAkB;QAClB,OAAO,KAAK,CAAC;IACjB,CAAC;IAED,IAAI,oBAAoB;QACpB,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,oEAAoE;IAEpE,IAAI,OAAO;QACP,OAAO,IAAI,oBAAoB,EAAE,CAAC;IACtC,CAAC;IAED,oEAAoE;IAEpE,oBAAoB,CAAC,KAAa;QAC9B,OAAO,KAAK,KAAK,EAAE,CAAC;IACxB,CAAC;IAED,cAAc;QACV,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,KAAa,EAAE,SAAiB;QAChD,OAAO,gBAAgB,KAAK,KAAK,SAAS,GAAG,CAAC;IAClD,CAAC;IAED,WAAW,CAAC,MAAc,EAAE,IAAY;QACpC,OAAO,cAAc,MAAM,MAAM,IAAI,IAAI,CAAC;IAC9C,CAAC;IAED,oEAAoE;IAEpE,mBAAmB,CAAC,MAAc,EAAE,IAAY,EAAE,MAAgB;QAC9D,MAAM,SAAS,GAAG,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACpC,OAAO,SAAS,MAAM,MAAM,IAAI,KAAK,SAAS,EAAE,CAAC;IACrD,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,UAAkB;QAC9B,OAAO,0DAA0D,UAAU,gCAAgC,UAAU,UAAU,CAAC;IACpI,CAAC;IAED,4EAA4E;IACnE,gBAAgB,CAAC,UAAkB;QACxC,OAAO,UAAU,CAAC,WAAW,EAAE,KAAK,eAAe,CAAC,CAAC,CAAC,eAAe,CAAC,CAAC,CAAC,UAAU,CAAC;IACvF,CAAC;IAED,mEAAmE;IAEnE,iBAAiB,CAAC,IAA+B,EAAE,MAAc,EAAE,QAAgB;QAC/E,OAAO,WAAW,IAAI,KAAK,MAAM,KAAK,QAAQ,GAAG,CAAC;IACtD,CAAC;IAED,yBAAyB,CAAC,MAAc,EAAE,SAAiB,EAAE,UAAkB;QAC3E,MAAM,WAAW,GAAG,IAAI,CAAC,WAAW,CAAC,MAAM,EAAE,SAAS,CAAC,CAAC;QACxD,OAAO;YACH,2GAA2G,MAAM,iBAAiB,SAAS,IAAI;YAC/I,OAAO;YACP,kBAAkB,WAAW,IAAI;YACjC,UAAU;YACV,MAAM;YACN,MAAM;SACT,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,gBAAgB,CAAC,SAAiB,EAAE,OAAe,EAAE,OAAgB;QACjE,MAAM,KAAK,GAAG;YACV,MAAM,SAAS,EAAE;YACjB,OAAO;YACP,KAAK,OAAO,EAAE;YACd,KAAK;SACR,CAAC;QACF,IAAI,OAAO,EAAE,CAAC;YACV,KAAK,CAAC,IAAI,CAAC,MAAM,CAAC,CAAC;YACnB,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;YACpB,KAAK,CAAC,IAAI,CAAC,KAAK,OAAO,EAAE,CAAC,CAAC;YAC3B,KAAK,CAAC,IAAI,CAAC,KAAK,CAAC,CAAC;QACtB,CAAC;QACD,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,cAAc,CAAC,OAAe;QAC1B,OAAO,cAAc,OAAO,WAAW,CAAC;IAC5C,CAAC;IAED,mEAAmE;IAEnE,eAAe,CAAC,GAAqB;QACjC,MAAM,QAAQ,GAAG,GAAG,CAAC,QAAQ,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QACpD,MAAM,WAAW,GAAG,GAAG,CAAC,YAAY,IAAI,IAAI,CAAC,CAAC,CAAC,YAAY,GAAG,CAAC,YAAY,EAAE,CAAC,CAAC,CAAC,EAAE,CAAC;QACnF,OAAO,QAAQ,GAAG,CAAC,IAAI,KAAK,GAAG,CAAC,OAAO,IAAI,QAAQ,GAAG,WAAW,EAAE,CAAC;IACxE,CAAC;IAED,cAAc,CAAC,WAAmB,EAAE,OAA2B;QAC3D,MAAM,QAAQ,GAAG,OAAO,CAAC,WAAW,CAAC,CAAC,CAAC,MAAM,CAAC,CAAC,CAAC,UAAU,CAAC;QAC3D,OAAO,eAAe,WAAW,uBAAuB,OAAO,CAAC,UAAU,KAAK,OAAO,CAAC,OAAO,IAAI,QAAQ,GAAG,CAAC;IAClH,CAAC;IAED,eAAe,CAAC,MAAc,EAAE,KAAa,EAAE,MAAc,EAAE,OAAe;QAC1E,MAAM,OAAO,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QAC5C,OAAO;YACH,6BAA6B;YAC7B,gCAAgC;YAChC,kBAAkB,OAAO,IAAI;YAC7B,+CAA+C,MAAM,IAAI;YACzD,8CAA8C,KAAK,IAAI;YACvD,+CAA+C,MAAM,IAAI;SAC5D,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,YAAY;QACR,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,mEAAmE;IAEnE,UAAU,CAAC,OAAuB;QAC9B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACzC,MAAM,KAAK,GAAa,EAAE,CAAC;QAC3B,KAAK,CAAC,IAAI,CAAC,mBAAmB,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,WAAW,GAAG,CAAC,CAAC;QAC1E,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,SAAS,GAAG,CAAC,CAAC;QAC5D,KAAK,CAAC,IAAI,CAAC,GAAG,OAAO,CAAC,MAAM,IAAI,MAAM,EAAE,CAAC,CAAC;QAC1C,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QACjB,KAAK,CAAC,IAAI,CAAC,OAAO,CAAC,CAAC;QACpB,KAAK,CAAC,IAAI,CAAC,qBAAqB,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,OAAO,OAAO,CAAC,IAAI,EAAE,CAAC,CAAC;QAClC,KAAK,CAAC,IAAI,CAAC,KAAK,CAAC,CAAC;QAClB,OAAO,KAAK,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IAC5B,CAAC;IAED,QAAQ,CAAC,OAAqB;QAC1B,MAAM,MAAM,GAAG,OAAO,CAAC,MAAM,CAAC,CAAC,CAAC,SAAS,CAAC,CAAC,CAAC,EAAE,CAAC;QAC/C,MAAM,IAAI,GAAG,OAAO,CAAC,OAAO,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;QAC3D,IAAI,GAAG,GAAG,UAAU,MAAM,UAAU,OAAO,CAAC,SAAS,SAAS,OAAO,CAAC,MAAM,MAAM,OAAO,CAAC,SAAS,KAAK,IAAI,GAAG,CAAC;QAChH,IAAI,OAAO,CAAC,cAAc,IAAI,OAAO,CAAC,cAAc,CAAC,MAAM,GAAG,CAAC,EAAE,CAAC;YAC9D,MAAM,GAAG,GAAG,OAAO,CAAC,cAAc,CAAC,GAAG,CAAC,CAAC,CAAC,EAAE,CAAC,IAAI,CAAC,GAAG,CAAC,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;YACjE,GAAG,IAAI,aAAa,GAAG,GAAG,CAAC;QAC/B,CAAC;QACD,OAAO,GAAG,CAAC;IACf,CAAC;IAED,oEAAoE;IAEpE,eAAe,CAAC,UAAkB,EAAE,WAAmB,EAAE,MAAc,EAAE,MAAc,EAAE,IAAY;QACjG,OAAO,SAAS,UAAU,QAAQ,MAAM,MAAM,MAAM,SAAS,IAAI,GAAG,CAAC;IACzE,CAAC;IAED,eAAe,CAAC,UAAkB,EAAE,MAAc,EAAE,IAAY,EAAE,OAAe;QAC7E,MAAM,cAAc,GAAG,OAAO,CAAC,OAAO,CAAC,IAAI,EAAE,IAAI,CAAC,CAAC;QACnD,MAAM,UAAU,GAAG,IAAI,CAAC,sBAAsB,CAAC,UAAU,CAAC,CAAC;QAC3D,OAAO;YACH,6BAA6B;YAC7B,gCAAgC;YAChC,kBAAkB,cAAc,IAAI;YACpC,gDAAgD,MAAM,IAAI;YAC1D,uBAAuB,UAAU,sBAAsB,IAAI,GAAG;SACjE,CAAC,IAAI,CAAC,IAAI,CAAC,CAAC;IACjB,CAAC;IAED,oEAAoE;IAEpE,0BAA0B;QACtB,OAAO;YACH,UAAU,EAAE;;;;;gCAKQ;YACpB,WAAW,EAAE;;;;;;;;qCAQY;YACzB,eAAe,EAAE;;;;;;kEAMqC;YACtD,eAAe,EAAE;;;;;;;;;;;iCAWI;YACrB,WAAW,EAAE;;;;;;;gDAOuB;YACpC,YAAY,EAAE,4CAA4C;SAC7D,CAAC;IACN,CAAC;IAED,oEAAoE;IAEpE,GAAG,CAAC,SAAiB,EAAE,OAAe,EAAE,QAAgB;QACpD,OAAO,OAAO,SAAS,KAAK,OAAO,KAAK,QAAQ,GAAG,CAAC;IACxD,CAAC;IAED,qEAAqE;IAErE,mBAAmB,CAAC,OAA2B;QAC3C,QAAQ,OAAO,CAAC,IAAI,EAAE,CAAC;YACnB,KAAK,QAAQ;gBACT,OAAO,IAAI,CAAC,iBAAiB,CAAC,OAAO,CAAC,SAAS,CAAC,CAAC;YACrD,KAAK,MAAM;gBACP,OAAO,eAAe,CAAC;YAC3B,KAAK,SAAS;gBACV,OAAO,KAAK,CAAC;YACjB,KAAK,QAAQ;gBACT,OAAO,QAAQ,CAAC;YACpB,KAAK,SAAS;gBACV,OAAO,WAAW,OAAO,CAAC,SAAS,IAAI,EAAE,IAAI,OAAO,CAAC,KAAK,IAAI,CAAC,GAAG,CAAC;YACvE,KAAK,SAAS;gBACV,OAAO,KAAK,CAAC;YACjB,KAAK,UAAU;gBACX,OAAO,gBAAgB,CAAC;YAC5B,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB,KAAK,MAAM;gBACP,OAAO,kBAAkB,CAAC;YAC9B,KAAK,MAAM;gBACP,OAAO,eAAe,CAAC;YAC3B,KAAK,OAAO;gBACR,OAAO,OAAO,CAAC;YACnB,KAAK,MAAM;gBACP,OAAO,MAAM,CAAC;YAClB;gBACI,OAAO,IAAI,CAAC,YAAY,EAAE,CAAC;QACnC,CAAC;IACL,CAAC;IAEO,iBAAiB,CAAC,SAAkB;QACxC,IAAI,SAAS,IAAI,IAAI,IAAI,SAAS,GAAG,CAAC,EAAE,CAAC;YACrC,IAAI,SAAS,GAAG,IAAI;gBAAE,OAAO,eAAe,CAAC;YAC7C,OAAO,YAAY,SAAS,GAAG,CAAC;QACpC,CAAC;QACD,OAAO,eAAe,CAAC;IAC3B,CAAC;IAED,oEAAoE;IAE5D,sBAAsB,CAAC,UAAkB;QAC7C,QAAQ,UAAU,CAAC,WAAW,EAAE,EAAE,CAAC;YAC/B,KAAK,OAAO,CAAC,CAAC,OAAO,OAAO,CAAC;YAC7B,KAAK,MAAM,CAAC,CAAC,OAAO,MAAM,CAAC;YAC3B,KAAK,WAAW,CAAC,CAAC,OAAO,WAAW,CAAC;YACrC,KAAK,UAAU,CAAC,CAAC,OAAO,UAAU,CAAC;YACnC,OAAO,CAAC,CAAC,OAAO,UAAU,CAAC,WAAW,EAAE,CAAC;QAC7C,CAAC;IACL,CAAC"}

package.json

 {
   "name": "@memberjunction/sql-dialect",
   "type": "module",
-  "version": "5.32.0",
+  "version": "5.33.0",
   "description": "MemberJunction: SQL Dialect Abstraction Layer for multi-database support",
@@ -6,0 +6,0 @@ "main": "dist/index.js",

No alert changes

Improved metrics

Total package byte prevSize

184143

25.96%

Number of package files

30

15.38%

Lines of code

2265

27.1%

No dependency changes