{"version":3,"file":"dialect.cjs","names":["entityKind","makeJitQueryMapper","makeDefaultQueryMapper","sql","Table","SQL","Subquery","StringChunk","Column","MsSqlColumn","MsSqlViewBase","ViewBaseConfig","View","MsSqlTable","DrizzleError","Param","V1","and","eq"],"sources":["../../src/mssql-core/dialect.ts"],"sourcesContent":["import * as V1 from '~/_relations.ts';\nimport {\n\taliasedTable,\n\taliasedTableColumn,\n\tgetOriginalColumnFromAlias,\n\tmapColumnsInAliasedSQLToAlias,\n\tmapColumnsInSQLToAlias,\n} from '~/alias.ts';\nimport { Column } from '~/column.ts';\nimport { entityKind, is } from '~/entity.ts';\nimport type { MigrationConfig, MigrationMeta, MigratorInitFailResponse } from '~/migrator.ts';\nimport { getMigrationsToRun } from '~/migrator.utils.ts';\nimport type { TypedQueryBuilder } from '~/query-builders/query-builder.ts';\nimport { Param, type Query, SQL, sql, type SQLChunk, StringChunk, View } from '~/sql/sql.ts';\nimport { Subquery } from '~/subquery.ts';\nimport { getTableName, getTableUniqueName, Table } from '~/table.ts';\nimport { upgradeIfNeeded } from '~/up-migrations/mssql.ts';\nimport { makeDefaultQueryMapper, makeJitQueryMapper, type RowsMapperGenerator, type UpdateSet } from '~/utils.ts';\nimport { and, DrizzleError, eq, type Name, ViewBaseConfig } from '../index.ts';\nimport { MsSqlColumn } from './columns/common.ts';\nimport type { MsSqlDeleteConfig } from './query-builders/delete.ts';\nimport type { MsSqlInsertConfig } from './query-builders/insert.ts';\nimport type {\n\tAnyMsSqlSelectQueryBuilder,\n\tMsSqlSelectConfig,\n\tSelectedFieldsOrdered,\n} from './query-builders/select.types.ts';\nimport type { MsSqlUpdateConfig } from './query-builders/update.ts';\nimport type { MsSqlSession } from './session.ts';\nimport { MsSqlTable } from './table.ts';\nimport { MsSqlViewBase } from './view-base.ts';\n\nexport interface MsSqlDialectConfig {\n\tuseJitMappers?: boolean;\n}\n\nexport class MsSqlDialect {\n\tstatic readonly [entityKind]: string = 'MsSqlDialect';\n\n\treadonly mapperGenerators: {\n\t\trows: RowsMapperGenerator;\n\t};\n\n\tconstructor(config?: MsSqlDialectConfig) {\n\t\tthis.mapperGenerators = {\n\t\t\trows: config?.useJitMappers ? makeJitQueryMapper : makeDefaultQueryMapper,\n\t\t};\n\t}\n\n\tasync migrate(\n\t\tmigrations: MigrationMeta[],\n\t\tsession: MsSqlSession,\n\t\tconfig: MigrationConfig,\n\t): Promise<void | MigratorInitFailResponse> {\n\t\tconst migrationsSchema = typeof config === 'string'\n\t\t\t? 'drizzle'\n\t\t\t: (config.migrationsSchema ?? 'drizzle');\n\n\t\tconst migrationSchemaCreate = sql`\n\t\t\tIF NOT EXISTS (\n\t\t\t\tSELECT 1 FROM sys.schemas WHERE name = ${migrationsSchema}\n\t\t\t)\n\t\t\tEXEC(\\'CREATE SCHEMA ${sql.identifier(migrationsSchema)}\\')\n\t\t`;\n\n\t\tawait session.execute(migrationSchemaCreate);\n\n\t\tconst migrationsTable = typeof config === 'string'\n\t\t\t? '__drizzle_migrations'\n\t\t\t: (config.migrationsTable ?? '__drizzle_migrations');\n\n\t\t// Detect DB version and upgrade table schema if needed\n\t\tconst { newDb } = await upgradeIfNeeded(\n\t\t\tmigrationsSchema,\n\t\t\tmigrationsTable,\n\t\t\tsession,\n\t\t\tmigrations,\n\t\t);\n\n\t\tif (newDb) {\n\t\t\tconst migrationTableCreate = sql`\n\t\t\tIF NOT EXISTS (\n\t\t\t\tSELECT 1 FROM INFORMATION_SCHEMA.TABLES \n\t\t\t\tWHERE TABLE_NAME = ${migrationsTable} AND TABLE_SCHEMA = ${migrationsSchema}\n\t\t\t)\n\t\t\tCREATE TABLE ${sql.identifier(migrationsSchema)}.${sql.identifier(migrationsTable)} (\n\t\t\t\tid bigint identity PRIMARY KEY,\n\t\t\t\thash text NOT NULL,\n\t\t\t\tcreated_at bigint,\n\t\t\t\tname text,\n\t\t\t\tapplied_at datetime2 NOT NULL DEFAULT GETUTCDATE()\n\t\t\t)\n\t\t`;\n\n\t\t\tawait session.execute(migrationTableCreate);\n\t\t}\n\n\t\tconst dbMigrations = (\n\t\t\tawait session.execute<{\n\t\t\t\trecordset: {\n\t\t\t\t\tid: number;\n\t\t\t\t\thash: string;\n\t\t\t\t\tcreated_at: string;\n\t\t\t\t\tname: string | null;\n\t\t\t\t}[];\n\t\t\t}>(\n\t\t\t\tsql`select id, hash, created_at, name from ${sql.identifier(migrationsSchema)}.${\n\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\tmigrationsTable,\n\t\t\t\t\t)\n\t\t\t\t}`,\n\t\t\t)\n\t\t).recordset;\n\n\t\tif (typeof config === 'object' && config.init) {\n\t\t\tif (dbMigrations.length > 0) {\n\t\t\t\treturn { exitCode: 'databaseMigrations' as const };\n\t\t\t}\n\n\t\t\tif (migrations.length > 1) {\n\t\t\t\treturn { exitCode: 'localMigrations' as const };\n\t\t\t}\n\n\t\t\tconst [migration] = migrations;\n\n\t\t\tif (!migration) return;\n\n\t\t\tawait session.execute(\n\t\t\t\tsql`insert into ${sql.identifier(migrationsSchema)}.${\n\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\tmigrationsTable,\n\t\t\t\t\t)\n\t\t\t\t} ([hash], [created_at], [name]) values(${migration.hash}, ${migration.folderMillis}, ${migration.name})`,\n\t\t\t);\n\n\t\t\treturn;\n\t\t}\n\n\t\tconst migrationsToRun = getMigrationsToRun({\n\t\t\tlocalMigrations: migrations,\n\t\t\tdbMigrations,\n\t\t});\n\t\tawait session.transaction(async (tx) => {\n\t\t\tfor (const migration of migrationsToRun) {\n\t\t\t\tfor (const stmt of migration.sql) {\n\t\t\t\t\tawait tx.execute(sql.raw(stmt));\n\t\t\t\t}\n\t\t\t\tawait tx.execute(\n\t\t\t\t\tsql`insert into ${sql.identifier(migrationsSchema)}.${\n\t\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\t\tmigrationsTable,\n\t\t\t\t\t\t)\n\t\t\t\t\t} ([hash], [created_at], [name]) values(${migration.hash}, ${migration.folderMillis}, ${migration.name})`,\n\t\t\t\t);\n\t\t\t}\n\t\t});\n\t}\n\n\tescapeName(name: string): string {\n\t\treturn `[${name.replace(/\\]/g, ']]')}]`;\n\t}\n\n\tescapeParam(_num: number): string {\n\t\treturn `@par${_num}`;\n\t}\n\n\tescapeString(str: string): string {\n\t\treturn `'${str.replace(/'/g, \"''\")}'`;\n\t}\n\n\tbuildDeleteQuery({ table, where, output }: MsSqlDeleteConfig): SQL {\n\t\tconst outputSql = output\n\t\t\t? sql` output ${this.buildSelectionOutput(output, { type: 'DELETED' })}`\n\t\t\t: undefined;\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\treturn sql`delete from ${table}${outputSql}${whereSql}`;\n\t}\n\n\tbuildUpdateSet(table: MsSqlTable, set: UpdateSet): SQL {\n\t\tconst tableColumns = table[Table.Symbol.Columns];\n\n\t\tconst columnNames = Object.keys(tableColumns).filter(\n\t\t\t(colName) =>\n\t\t\t\tset[colName] !== undefined\n\t\t\t\t|| tableColumns[colName]?.onUpdateFn !== undefined,\n\t\t);\n\n\t\tconst setLength = columnNames.length;\n\t\tconst setArr: SQLChunk[] = new Array(setLength);\n\n\t\tfor (let i = 0; i < columnNames.length; ++i) {\n\t\t\tconst colName = columnNames[i]!;\n\t\t\tconst col = tableColumns[colName]!;\n\n\t\t\tlet value;\n\t\t\tif (set[colName] !== undefined) {\n\t\t\t\tvalue = set[colName];\n\t\t\t} else {\n\t\t\t\tconst updateRes = col.onUpdateFn?.();\n\t\t\t\tvalue = is(updateRes, SQL) ? updateRes : sql.param(updateRes, col);\n\t\t\t}\n\n\t\t\tsetArr[i] = i < setLength - 1\n\t\t\t\t? sql`${sql.identifier(col.name)} = ${value}, `\n\t\t\t\t: sql`${sql.identifier(col.name)} = ${value}`;\n\t\t}\n\n\t\treturn new SQL(setArr);\n\t\t// const setEntries = Object.entries(set);\n\t\t//\n\t\t// const setSize = setEntries.length;\n\t\t// return sql.join(\n\t\t// \tsetEntries\n\t\t// \t\t.flatMap(([colName, value], i): SQL[] => {\n\t\t// \t\t\tconst col: MsSqlColumn = table[Table.Symbol.Columns][colName]!;\n\t\t// \t\t\tconst res = sql`${sql.identifier(col.name)} = ${value}`;\n\t\t// \t\t\tif (i < setSize - 1) {\n\t\t// \t\t\t\treturn [res, sql.raw(', ')];\n\t\t// \t\t\t}\n\t\t// \t\t\treturn [res];\n\t\t// \t\t}),\n\t\t// );\n\t}\n\n\tbuildUpdateQuery({ table, set, where, output }: MsSqlUpdateConfig): SQL {\n\t\tconst setSql = this.buildUpdateSet(table, set);\n\n\t\tconst outputSql = sql``;\n\n\t\tif (output) {\n\t\t\toutputSql.append(sql` output `);\n\n\t\t\tif (output.inserted) {\n\t\t\t\toutputSql.append(\n\t\t\t\t\tthis.buildSelectionOutput(output.inserted, { type: 'INSERTED' }),\n\t\t\t\t);\n\t\t\t}\n\n\t\t\tif (output.deleted) {\n\t\t\t\tif (output.inserted) outputSql.append(sql`, `); // add space if both are present\n\t\t\t\toutputSql.append(\n\t\t\t\t\tthis.buildSelectionOutput(output.deleted, { type: 'DELETED' }),\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\treturn sql`update ${table} set ${setSql}${outputSql}${whereSql}`;\n\t}\n\n\t/**\n\t * Builds selection SQL with provided fields/expressions\n\t *\n\t * Examples:\n\t *\n\t * `select <selection> from`\n\t *\n\t * `insert ... returning <selection>`\n\t *\n\t * If `isSingleTable` is true, then columns won't be prefixed with table name\n\t */\n\tprivate buildSelection(\n\t\tfields: SelectedFieldsOrdered,\n\t\t{ isSingleTable = false, table }: {\n\t\t\tisSingleTable?: boolean;\n\t\t\ttable?: MsSqlTable | MsSqlViewBase | SQL | Subquery;\n\t\t} = {},\n\t): SQL {\n\t\tconst { length: columnsLen } = fields;\n\t\tconst chunks: SQLChunk[] = [];\n\t\tconst tableName = table\n\t\t\t? is(table, SQL) || is(table, Subquery)\n\t\t\t\t? undefined\n\t\t\t\t: (table[Table.Symbol.IsAlias] || table[Table.Symbol.Schema] === undefined\n\t\t\t\t\t? table[Table.Symbol.Name]\n\t\t\t\t\t: `${table[Table.Symbol.Schema]}.${table[Table.Symbol.Name]}`)\n\t\t\t: undefined;\n\n\t\tfor (let i = 0; i < columnsLen; ++i) {\n\t\t\tconst { field, fieldType } = fields[i]!;\n\n\t\t\tswitch (fieldType) {\n\t\t\t\tcase 'Column': {\n\t\t\t\t\tif (isSingleTable) {\n\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t? sql`${sql.identifier(getOriginalColumnFromAlias(field).name)} as ${field}`\n\t\t\t\t\t\t\t\t: sql.identifier(field.name),\n\t\t\t\t\t\t);\n\t\t\t\t\t} else {\n\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t? sql`${getOriginalColumnFromAlias(field)} as ${field}`\n\t\t\t\t\t\t\t\t: field,\n\t\t\t\t\t\t);\n\t\t\t\t\t}\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tcase 'SQL.Aliased': {\n\t\t\t\t\tif (field.isSelectionField) {\n\t\t\t\t\t\tif (!isSingleTable && field.origin !== undefined) {\n\t\t\t\t\t\t\tchunks.push(sql.identifier(field.origin), new StringChunk('.'));\n\t\t\t\t\t\t}\n\t\t\t\t\t\tchunks.push(sql.identifier(field.fieldAlias));\n\t\t\t\t\t} else {\n\t\t\t\t\t\tif (isSingleTable && tableName !== undefined) {\n\t\t\t\t\t\t\tconst { queryChunks } = field.sql;\n\t\t\t\t\t\t\tconst newChunks: SQLChunk[] = new Array(queryChunks.length);\n\t\t\t\t\t\t\tlet abort = false;\n\n\t\t\t\t\t\t\tfor (let i = 0; i < queryChunks.length; ++i) {\n\t\t\t\t\t\t\t\tconst c = queryChunks[i]!;\n\t\t\t\t\t\t\t\tif (is(c, Column)) {\n\t\t\t\t\t\t\t\t\tconst { table } = c;\n\t\t\t\t\t\t\t\t\tconst columnTableName = table[Table.Symbol.IsAlias] || table[Table.Symbol.Schema] === undefined\n\t\t\t\t\t\t\t\t\t\t? table[Table.Symbol.Name]\n\t\t\t\t\t\t\t\t\t\t: `${table[Table.Symbol.Schema]}.${table[Table.Symbol.Name]}`;\n\t\t\t\t\t\t\t\t\tif (columnTableName !== tableName) {\n\t\t\t\t\t\t\t\t\t\tabort = true;\n\t\t\t\t\t\t\t\t\t\tbreak;\n\t\t\t\t\t\t\t\t\t}\n\n\t\t\t\t\t\t\t\t\tnewChunks[i] = sql.identifier(c.name);\n\t\t\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\t\t\tnewChunks[i] = c;\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\n\t\t\t\t\t\t\tif (abort) {\n\t\t\t\t\t\t\t\tchunks.push(field.sql);\n\t\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\t\tconst newSql = new SQL(newChunks);\n\t\t\t\t\t\t\t\tif (field.sql.shouldInlineParams) newSql.inlineParams();\n\t\t\t\t\t\t\t\tchunks.push(newSql);\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tchunks.push(field.sql);\n\t\t\t\t\t\t}\n\n\t\t\t\t\t\tchunks.push(sql` as ${sql.identifier(field.fieldAlias)}`);\n\t\t\t\t\t}\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tcase 'SQL': {\n\t\t\t\t\tif (isSingleTable && tableName !== undefined) {\n\t\t\t\t\t\tconst { queryChunks } = field;\n\t\t\t\t\t\tconst newChunks: SQLChunk[] = new Array(queryChunks.length);\n\t\t\t\t\t\tlet abort = false;\n\n\t\t\t\t\t\tfor (let i = 0; i < queryChunks.length; ++i) {\n\t\t\t\t\t\t\tconst c = queryChunks[i]!;\n\t\t\t\t\t\t\tif (is(c, Column)) {\n\t\t\t\t\t\t\t\tconst { table } = c;\n\t\t\t\t\t\t\t\tconst columnTableName = table[Table.Symbol.IsAlias] || table[Table.Symbol.Schema] === undefined\n\t\t\t\t\t\t\t\t\t? table[Table.Symbol.Name]\n\t\t\t\t\t\t\t\t\t: `${table[Table.Symbol.Schema]}.${table[Table.Symbol.Name]}`;\n\t\t\t\t\t\t\t\tif (columnTableName !== tableName) {\n\t\t\t\t\t\t\t\t\tabort = true;\n\t\t\t\t\t\t\t\t\tbreak;\n\t\t\t\t\t\t\t\t}\n\n\t\t\t\t\t\t\t\tnewChunks[i] = sql.identifier(c.name);\n\t\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\t\tnewChunks[i] = c;\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t}\n\n\t\t\t\t\t\tif (abort) {\n\t\t\t\t\t\t\tchunks.push(field);\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tconst newSql = new SQL(newChunks);\n\t\t\t\t\t\t\tif (field.shouldInlineParams) newSql.inlineParams();\n\t\t\t\t\t\t\tchunks.push(newSql);\n\t\t\t\t\t\t}\n\t\t\t\t\t} else chunks.push(field);\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tcase 'Subquery': {\n\t\t\t\t\tif (!field._.isWith) {\n\t\t\t\t\t\tchunks.push(sql`(${field._.sql}) ${sql.identifier(field._.alias)}`);\n\t\t\t\t\t} else {\n\t\t\t\t\t\tchunks.push(field);\n\t\t\t\t\t}\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t}\n\n\t\t\tif (i < columnsLen - 1) {\n\t\t\t\tchunks.push(new StringChunk(', '));\n\t\t\t}\n\t\t}\n\n\t\treturn new SQL(chunks);\n\t}\n\n\tprivate buildSelectionOutput(\n\t\tfields: SelectedFieldsOrdered,\n\t\t{ type }: { type: 'INSERTED' | 'DELETED' },\n\t): SQL {\n\t\tconst { length: columnsLen } = fields;\n\t\tconst chunks: SQLChunk[] = [];\n\n\t\tfor (let i = 0; i < columnsLen; ++i) {\n\t\t\tconst { field, fieldType } = fields[i]!;\n\n\t\t\tswitch (fieldType) {\n\t\t\t\tcase 'Column': {\n\t\t\t\t\tchunks.push(\n\t\t\t\t\t\tsql.join([\n\t\t\t\t\t\t\tnew StringChunk(`${type}.`),\n\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t? sql`${sql.identifier(getOriginalColumnFromAlias(field).name)} as ${field}`\n\t\t\t\t\t\t\t\t: sql.identifier(field.name),\n\t\t\t\t\t\t]),\n\t\t\t\t\t);\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tcase 'SQL.Aliased': {\n\t\t\t\t\tif (field.isSelectionField) {\n\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\tsql.join([new StringChunk(`${type}.`), sql.identifier(field.fieldAlias)]),\n\t\t\t\t\t\t);\n\t\t\t\t\t} else {\n\t\t\t\t\t\tconst query = field.sql;\n\n\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\tnew SQL(\n\t\t\t\t\t\t\t\tquery.queryChunks.map((c) => {\n\t\t\t\t\t\t\t\t\tif (is(c, MsSqlColumn)) {\n\t\t\t\t\t\t\t\t\t\treturn sql.join([\n\t\t\t\t\t\t\t\t\t\t\tnew StringChunk(`${type}.`),\n\t\t\t\t\t\t\t\t\t\t\tsql.identifier(c.name),\n\t\t\t\t\t\t\t\t\t\t]);\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\treturn c;\n\t\t\t\t\t\t\t\t}),\n\t\t\t\t\t\t\t),\n\t\t\t\t\t\t);\n\n\t\t\t\t\t\tchunks.push(sql` as ${sql.identifier(field.fieldAlias)}`);\n\t\t\t\t\t}\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t\tcase 'SQL': {\n\t\t\t\t\tconst query = field;\n\n\t\t\t\t\tchunks.push(\n\t\t\t\t\t\tnew SQL(\n\t\t\t\t\t\t\tquery.queryChunks.map((c) => {\n\t\t\t\t\t\t\t\tif (is(c, MsSqlColumn)) {\n\t\t\t\t\t\t\t\t\treturn sql.join([\n\t\t\t\t\t\t\t\t\t\tnew StringChunk(`${type}.`),\n\t\t\t\t\t\t\t\t\t\tsql.identifier(c.name),\n\t\t\t\t\t\t\t\t\t]);\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\treturn c;\n\t\t\t\t\t\t\t}),\n\t\t\t\t\t\t),\n\t\t\t\t\t);\n\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\t\t\t}\n\n\t\t\tif (i < columnsLen - 1) {\n\t\t\t\tchunks.push(new StringChunk(', '));\n\t\t\t}\n\t\t}\n\n\t\treturn new SQL(chunks);\n\t}\n\n\tbuildSelectQuery({\n\t\twithList,\n\t\tfieldsFlat,\n\t\twhere,\n\t\thaving,\n\t\ttable,\n\t\tjoins,\n\t\torderBy,\n\t\tgroupBy,\n\t\tfetch,\n\t\tfor: _for,\n\t\ttop,\n\t\toffset,\n\t\tdistinct,\n\t\tsetOperators,\n\t}: MsSqlSelectConfig): SQL {\n\t\tif (!fieldsFlat) {\n\t\t\tthrow new Error('Select query builder must be provided with `fieldsFlat` on `buildSelectQuery` invocation');\n\t\t}\n\t\tconst fieldsList = fieldsFlat;\n\t\tfor (const f of fieldsList) {\n\t\t\tif (\n\t\t\t\tis(f.field, Column)\n\t\t\t\t&& getTableName(f.field.table)\n\t\t\t\t\t!== (is(table, Subquery)\n\t\t\t\t\t\t? table._.alias\n\t\t\t\t\t\t: is(table, MsSqlViewBase)\n\t\t\t\t\t\t? table[ViewBaseConfig].name\n\t\t\t\t\t\t: is(table, SQL)\n\t\t\t\t\t\t? undefined\n\t\t\t\t\t\t: getTableName(table))\n\t\t\t\t&& !((table) =>\n\t\t\t\t\tjoins?.some(\n\t\t\t\t\t\t({ alias }) =>\n\t\t\t\t\t\t\talias\n\t\t\t\t\t\t\t\t=== (table[Table.Symbol.IsAlias]\n\t\t\t\t\t\t\t\t\t? getTableName(table)\n\t\t\t\t\t\t\t\t\t: table[Table.Symbol.BaseName]),\n\t\t\t\t\t))(f.field.table)\n\t\t\t) {\n\t\t\t\tconst tableName = getTableName(f.field.table);\n\t\t\t\tthrow new Error(\n\t\t\t\t\t`Your \"${\n\t\t\t\t\t\tf.path.join(\n\t\t\t\t\t\t\t'->',\n\t\t\t\t\t\t)\n\t\t\t\t\t}\" field references a column \"${tableName}\".\"${f.field.name}\", but the table \"${tableName}\" is not part of the query! Did you forget to join it?`,\n\t\t\t\t);\n\t\t\t}\n\t\t}\n\n\t\tconst isSingleTable = !joins || joins.length === 0;\n\n\t\tlet withSql: SQL | undefined;\n\t\tif (withList?.length) {\n\t\t\tconst withListLen = withList.length;\n\t\t\tconst withSqlChunks: SQLChunk[] = new Array(withListLen + 1);\n\t\t\tlet writeIdx = 0;\n\t\t\twithSqlChunks[writeIdx++] = new StringChunk('with ');\n\n\t\t\tfor (let i = 0; i < withListLen; ++i) {\n\t\t\t\tconst w = withList[i]!;\n\t\t\t\twithSqlChunks[writeIdx++] = (i < withListLen - 1)\n\t\t\t\t\t? sql`${sql.identifier(w._.alias)} as (${w._.sql}), `\n\t\t\t\t\t: sql`${sql.identifier(w._.alias)} as (${w._.sql}) `;\n\t\t\t}\n\n\t\t\twithSql = new SQL(withSqlChunks);\n\t\t}\n\n\t\tconst distinctSql = distinct ? sql` distinct` : undefined;\n\n\t\tconst topSql = top ? sql` top(${top})` : undefined;\n\n\t\tconst selection = this.buildSelection(fieldsList, { isSingleTable, table });\n\n\t\tconst tableSql = (() => {\n\t\t\tif (\n\t\t\t\tis(table, Table)\n\t\t\t\t&& table[Table.Symbol.OriginalName] !== table[Table.Symbol.Name]\n\t\t\t) {\n\t\t\t\tlet fullName = sql`${sql.identifier(table[Table.Symbol.OriginalName])} ${\n\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\ttable[Table.Symbol.Name],\n\t\t\t\t\t)\n\t\t\t\t}`;\n\t\t\t\tif (table[Table.Symbol.Schema]) {\n\t\t\t\t\tfullName = sql`${sql.identifier(table[Table.Symbol.Schema]!)}.${fullName}`;\n\t\t\t\t}\n\t\t\t\treturn fullName;\n\t\t\t}\n\n\t\t\tif (is(table, View) && table[ViewBaseConfig].isAlias) {\n\t\t\t\tlet fullName = sql`${sql.identifier(table[ViewBaseConfig].originalName)}`;\n\t\t\t\tif (table[ViewBaseConfig].schema) {\n\t\t\t\t\tfullName = sql`${sql.identifier(table[ViewBaseConfig].schema)}.${fullName}`;\n\t\t\t\t}\n\t\t\t\treturn sql`${fullName} ${sql.identifier(table[ViewBaseConfig].name)}`;\n\t\t\t}\n\n\t\t\treturn table;\n\t\t})();\n\n\t\tconst joinsArray: SQLChunk[] = [];\n\n\t\tif (joins) {\n\t\t\tfor (const [index, joinMeta] of joins.entries()) {\n\t\t\t\tif (index === 0) {\n\t\t\t\t\tjoinsArray.push(new StringChunk(' '));\n\t\t\t\t}\n\t\t\t\tconst table = joinMeta.table;\n\t\t\t\tconst joinKeyword = joinMeta.lateral\n\t\t\t\t\t? new StringChunk(joinMeta.joinType === 'left' ? 'outer apply' : 'cross apply')\n\t\t\t\t\t: new StringChunk(`${joinMeta.joinType} join`);\n\t\t\t\tconst onSql = joinMeta.on ? sql` on ${joinMeta.on}` : undefined;\n\n\t\t\t\tif (is(table, MsSqlTable)) {\n\t\t\t\t\tconst tableName = table[MsSqlTable.Symbol.Name];\n\t\t\t\t\tconst tableSchema = table[MsSqlTable.Symbol.Schema];\n\t\t\t\t\tconst origTableName = table[MsSqlTable.Symbol.OriginalName];\n\t\t\t\t\tconst alias = tableName === origTableName ? undefined : joinMeta.alias;\n\t\t\t\t\tjoinsArray.push(\n\t\t\t\t\t\tsql`${joinKeyword} ${tableSchema ? sql`${sql.identifier(tableSchema)}.` : undefined}${\n\t\t\t\t\t\t\tsql.identifier(origTableName)\n\t\t\t\t\t\t}${alias && sql` ${sql.identifier(alias)}`}${onSql}`,\n\t\t\t\t\t);\n\t\t\t\t} else if (is(table, View)) {\n\t\t\t\t\tconst viewName = table[ViewBaseConfig].name;\n\t\t\t\t\tconst viewSchema = table[ViewBaseConfig].schema;\n\t\t\t\t\tconst origViewName = table[ViewBaseConfig].originalName;\n\t\t\t\t\tconst alias = viewName === origViewName ? undefined : joinMeta.alias;\n\t\t\t\t\tjoinsArray.push(\n\t\t\t\t\t\tsql`${joinKeyword} ${viewSchema ? sql`${sql.identifier(viewSchema)}.` : undefined}${\n\t\t\t\t\t\t\tsql.identifier(origViewName)\n\t\t\t\t\t\t}${alias && sql` ${sql.identifier(alias)}`}${onSql}`,\n\t\t\t\t\t);\n\t\t\t\t} else {\n\t\t\t\t\tjoinsArray.push(\n\t\t\t\t\t\tsql`${joinKeyword} ${table}${onSql}`,\n\t\t\t\t\t);\n\t\t\t\t}\n\t\t\t\tif (index < joins.length - 1) {\n\t\t\t\t\tjoinsArray.push(new StringChunk(' '));\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\n\t\tconst joinsSql = new SQL(joinsArray);\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\tconst havingSql = having ? sql` having ${having}` : undefined;\n\n\t\tlet orderBySql;\n\t\tif (orderBy && orderBy.length > 0) {\n\t\t\torderBySql = sql` order by ${sql.join(orderBy, new StringChunk(', '))}`;\n\t\t}\n\n\t\tlet groupBySql;\n\t\tif (groupBy && groupBy.length > 0) {\n\t\t\tgroupBySql = sql` group by ${sql.join(groupBy, new StringChunk(', '))}`;\n\t\t}\n\n\t\tconst offsetSql = offset === undefined ? undefined : sql` offset ${offset} rows`;\n\n\t\tconst fetchSql = fetch === undefined ? undefined : sql` fetch next ${fetch} rows only`;\n\n\t\tlet forSQL: SQL | undefined;\n\t\tif (_for && _for.mode === 'json') {\n\t\t\tforSQL = sql` for json ${new StringChunk(_for.type)}${\n\t\t\t\t_for.options?.root\n\t\t\t\t\t? sql` root(${sql.identifier(_for.options.root)})`\n\t\t\t\t\t: undefined\n\t\t\t}${_for.options?.includeNullValues ? sql` include_null_values` : undefined}${\n\t\t\t\t_for.options?.withoutArrayWrapper\n\t\t\t\t\t? sql` without_array_wrapper`\n\t\t\t\t\t: undefined\n\t\t\t}`;\n\t\t}\n\n\t\tconst finalQuery =\n\t\t\tsql`${withSql}select${distinctSql}${topSql} ${selection} from ${tableSql}${joinsSql}${whereSql}${groupBySql}${havingSql}${orderBySql}${offsetSql}${fetchSql}${forSQL}`;\n\n\t\tif (setOperators.length > 0) {\n\t\t\treturn this.buildSetOperations(finalQuery, setOperators);\n\t\t}\n\n\t\treturn finalQuery;\n\t}\n\n\tbuildSetOperations(\n\t\tleftSelect: SQL,\n\t\tsetOperators: MsSqlSelectConfig['setOperators'],\n\t): SQL {\n\t\tconst [setOperator, ...rest] = setOperators;\n\n\t\tif (!setOperator) {\n\t\t\tthrow new Error('Cannot pass undefined values to any set operator');\n\t\t}\n\n\t\tif (rest.length === 0) {\n\t\t\treturn this.buildSetOperationQuery({ leftSelect, setOperator });\n\t\t}\n\n\t\t// Some recursive magic here\n\t\treturn this.buildSetOperations(\n\t\t\tthis.buildSetOperationQuery({ leftSelect, setOperator }),\n\t\t\trest,\n\t\t);\n\t}\n\n\tbuildSetOperationQuery({\n\t\tleftSelect,\n\t\tsetOperator: { type, isAll, rightSelect, fetch, orderBy, offset },\n\t}: {\n\t\tleftSelect: SQL;\n\t\tsetOperator: MsSqlSelectConfig['setOperators'][number];\n\t}): SQL {\n\t\tconst leftChunk = sql`(${leftSelect.getSQL()}) `;\n\t\tconst rightChunk = sql`(${rightSelect.getSQL()})`;\n\n\t\tlet orderBySql;\n\t\tif (orderBy && orderBy.length > 0) {\n\t\t\tconst orderByValues: (SQL<unknown> | Name)[] = [];\n\n\t\t\t// The next bit is necessary because the sql operator replaces ${table.column} with `table`.`column`\n\t\t\t// which is invalid MsSql syntax, Table from one of the SELECTs cannot be used in global ORDER clause\n\t\t\tfor (const orderByUnit of orderBy) {\n\t\t\t\tif (is(orderByUnit, MsSqlColumn)) {\n\t\t\t\t\torderByValues.push(sql.identifier(orderByUnit.name));\n\t\t\t\t} else if (is(orderByUnit, SQL)) {\n\t\t\t\t\tfor (let i = 0; i < orderByUnit.queryChunks.length; i++) {\n\t\t\t\t\t\tconst chunk = orderByUnit.queryChunks[i];\n\n\t\t\t\t\t\tif (is(chunk, MsSqlColumn)) {\n\t\t\t\t\t\t\torderByUnit.queryChunks[i] = sql.identifier(chunk.name);\n\t\t\t\t\t\t}\n\t\t\t\t\t}\n\n\t\t\t\t\torderByValues.push(sql`${orderByUnit}`);\n\t\t\t\t} else {\n\t\t\t\t\torderByValues.push(sql`${orderByUnit}`);\n\t\t\t\t}\n\t\t\t}\n\n\t\t\torderBySql = sql` order by ${sql.join(orderByValues, new StringChunk(', '))} `;\n\t\t}\n\n\t\tconst offsetSql = offset === undefined ? undefined : sql` offset ${offset} rows`;\n\n\t\tconst fetchSql = fetch === undefined ? undefined : sql` fetch next ${fetch} rows only`;\n\n\t\tconst operatorChunk = new StringChunk(`${type} ${isAll ? 'all ' : ''}`);\n\n\t\treturn sql`${leftChunk}${operatorChunk}${rightChunk}${orderBySql}${offsetSql}${fetchSql}`;\n\t}\n\n\tbuildInsertQuery({ table, values: valuesOrSelect, output, columnList, select }: MsSqlInsertConfig): SQL {\n\t\tconst columns: Record<string, MsSqlColumn> = table[Table.Symbol.Columns];\n\t\tconst colEntries: [string, MsSqlColumn][] = select && !is(valuesOrSelect, SQL)\n\t\t\t? Object\n\t\t\t\t.keys((valuesOrSelect as TypedQueryBuilder<any>).getSelectedFields())\n\t\t\t\t.map((key) => [key, columns[key]!] as [string, MsSqlColumn])\n\t\t\t: columnList\n\t\t\t? columnList.map((name) => [name, columns[name]!] as [string, MsSqlColumn])\n\t\t\t: Object.entries(columns).filter(\n\t\t\t\t([_, col]) => !col.shouldDisableInsert(),\n\t\t\t);\n\n\t\tif (colEntries.length === 0 && !select && (valuesOrSelect as Record<string, unknown>[]).length > 1) {\n\t\t\tthrow new DrizzleError({\n\t\t\t\tmessage: `Cannot insert ${(valuesOrSelect as Record<string, unknown>[]).length} rows into \"${\n\t\t\t\t\ttable[Table.Symbol.Name]\n\t\t\t\t}\": it has no insertable columns, so only a single all-defaults row can be inserted per statement`,\n\t\t\t});\n\t\t}\n\n\t\tconst insertOrderArr: SQLChunk[] = new Array(colEntries.length * 2 + 1);\n\t\tlet orderWriteIdx = 0;\n\t\tinsertOrderArr[orderWriteIdx++] = new StringChunk('(');\n\t\tfor (let i = 0; i < colEntries.length; ++i) {\n\t\t\tconst [, { name }] = colEntries[i]!;\n\t\t\tinsertOrderArr[orderWriteIdx++] = sql.identifier(name);\n\n\t\t\tif (i < colEntries.length - 1) insertOrderArr[orderWriteIdx++] = new StringChunk(', ');\n\t\t}\n\t\tinsertOrderArr[orderWriteIdx++] = new StringChunk(')');\n\t\tconst insertOrder = new SQL(insertOrderArr);\n\n\t\tconst valuesSqlList: SQLChunk[] = Array.from({\n\t\t\tlength: select ? 1 : (colEntries.length * 2 + 1) * (valuesOrSelect as Record<string, unknown>[]).length\n\t\t\t\t+ (valuesOrSelect as Record<string, unknown>[]).length - 1,\n\t\t});\n\n\t\tif (select) {\n\t\t\tvaluesSqlList[0] = (valuesOrSelect as AnyMsSqlSelectQueryBuilder | SQL).getSQL();\n\t\t} else {\n\t\t\tconst values = valuesOrSelect as Record<string, unknown>[];\n\n\t\t\tlet writeIdx = 0;\n\n\t\t\tfor (let valueIndex = 0; valueIndex < values.length; ++valueIndex) {\n\t\t\t\tconst value = values[valueIndex]!;\n\n\t\t\t\tvaluesSqlList[writeIdx++] = new StringChunk('(');\n\t\t\t\tfor (let i = 0; i < colEntries.length; ++i) {\n\t\t\t\t\tconst [fieldName, col] = colEntries[i]!;\n\t\t\t\t\tconst colValue = value[fieldName];\n\t\t\t\t\tif (colValue === undefined) {\n\t\t\t\t\t\tif (col.defaultFn !== undefined) {\n\t\t\t\t\t\t\tconst defaultFnResult = col.defaultFn();\n\t\t\t\t\t\t\tconst defaultValue = is(defaultFnResult, SQL)\n\t\t\t\t\t\t\t\t? defaultFnResult\n\t\t\t\t\t\t\t\t: sql.param(defaultFnResult, col);\n\t\t\t\t\t\t\tvaluesSqlList[writeIdx++] = defaultValue;\n\t\t\t\t\t\t} else if (!col.default && col.onUpdateFn !== undefined) {\n\t\t\t\t\t\t\tconst onUpdateFnResult = col.onUpdateFn();\n\t\t\t\t\t\t\tconst newValue = is(onUpdateFnResult, SQL)\n\t\t\t\t\t\t\t\t? onUpdateFnResult\n\t\t\t\t\t\t\t\t: sql.param(onUpdateFnResult, col);\n\t\t\t\t\t\t\tvaluesSqlList[writeIdx++] = newValue;\n\t\t\t\t\t\t} else {\n\t\t\t\t\t\t\tvaluesSqlList[writeIdx++] = new StringChunk(`default`);\n\t\t\t\t\t\t}\n\t\t\t\t\t} else {\n\t\t\t\t\t\tvaluesSqlList[writeIdx++] = is(colValue, SQL) ? colValue : new Param(colValue, col);\n\t\t\t\t\t}\n\n\t\t\t\t\tif (i < colEntries.length - 1) {\n\t\t\t\t\t\tvaluesSqlList[writeIdx++] = new StringChunk(', ');\n\t\t\t\t\t}\n\t\t\t\t}\n\n\t\t\t\tvaluesSqlList[writeIdx++] = new StringChunk(')');\n\n\t\t\t\tif (valueIndex < values.length - 1) {\n\t\t\t\t\tvaluesSqlList[writeIdx++] = new StringChunk(`, `);\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\n\t\tconst outputSql = output\n\t\t\t? sql` output ${this.buildSelectionOutput(output, { type: 'INSERTED' })}`\n\t\t\t: undefined;\n\n\t\tif (select) {\n\t\t\treturn sql`insert into ${table} ${insertOrder}${outputSql} ${new SQL(valuesSqlList)}`;\n\t\t}\n\n\t\tif (colEntries.length === 0) {\n\t\t\treturn sql`insert into ${table}${outputSql} default values`;\n\t\t}\n\n\t\treturn sql`insert into ${table} ${insertOrder}${outputSql} values ${new SQL(valuesSqlList)}`;\n\t}\n\n\tsqlToQuery(\n\t\tsql: SQL,\n\t\tinvokeSource?: 'indexes' | 'mssql-check' | 'mssql-view-with-schemabinding',\n\t): Query {\n\t\tconst res = sql.toQuery({\n\t\t\tescapeName: this.escapeName,\n\t\t\tescapeParam: this.escapeParam,\n\t\t\tescapeString: this.escapeString,\n\t\t\tinvokeSource,\n\t\t});\n\t\treturn res;\n\t}\n\n\tbuildRelationalQuery({\n\t\tfullSchema,\n\t\tschema,\n\t\ttableNamesMap,\n\t\ttable,\n\t\ttableConfig,\n\t\tqueryConfig: config,\n\t\ttableAlias,\n\t\tnestedQueryRelation,\n\t\tjoinOn,\n\t}: {\n\t\tfullSchema: Record<string, unknown>;\n\t\tschema: V1.TablesRelationalConfig;\n\t\ttableNamesMap: Record<string, string>;\n\t\ttable: MsSqlTable;\n\t\ttableConfig: V1.TableRelationalConfig;\n\t\tqueryConfig: true | V1.DBQueryConfig<'many', true>;\n\t\ttableAlias: string;\n\t\tnestedQueryRelation?: V1.Relation;\n\t\tjoinOn?: SQL;\n\t}): V1.BuildRelationalQueryResult<MsSqlTable, MsSqlColumn> {\n\t\tlet selection: V1.BuildRelationalQueryResult<\n\t\t\tMsSqlTable,\n\t\t\tMsSqlColumn\n\t\t>['selection'] = [];\n\t\tlet limit,\n\t\t\toffset,\n\t\t\torderBy: MsSqlSelectConfig['orderBy'] = [],\n\t\t\twhere;\n\n\t\tif (config === true) {\n\t\t\tconst selectionEntries = Object.entries(tableConfig.columns);\n\t\t\tselection = selectionEntries.map(([key, value]) => ({\n\t\t\t\tdbKey: value.name,\n\t\t\t\ttsKey: key,\n\t\t\t\tfield: aliasedTableColumn(value as MsSqlColumn, tableAlias),\n\t\t\t\trelationTableTsKey: undefined,\n\t\t\t\tisJson: false,\n\t\t\t\tselection: [],\n\t\t\t}));\n\t\t} else {\n\t\t\tconst aliasedColumns = Object.fromEntries(\n\t\t\t\tObject.entries(tableConfig.columns).map(([key, value]) => [\n\t\t\t\t\tkey,\n\t\t\t\t\taliasedTableColumn(value, tableAlias),\n\t\t\t\t]),\n\t\t\t);\n\n\t\t\tif (config.where) {\n\t\t\t\tconst whereSql = typeof config.where === 'function'\n\t\t\t\t\t? config.where(aliasedColumns, V1.getOperators())\n\t\t\t\t\t: config.where;\n\t\t\t\twhere = whereSql && mapColumnsInSQLToAlias(whereSql, tableAlias);\n\t\t\t}\n\n\t\t\tconst fieldsSelection: {\n\t\t\t\ttsKey: string;\n\t\t\t\tvalue: MsSqlColumn | SQL.Aliased;\n\t\t\t}[] = [];\n\t\t\tlet selectedColumns: string[] = [];\n\n\t\t\t// Figure out which columns to select\n\t\t\tif (config.columns) {\n\t\t\t\tlet isIncludeMode = false;\n\n\t\t\t\tfor (const [field, value] of Object.entries(config.columns)) {\n\t\t\t\t\tif (value === undefined) {\n\t\t\t\t\t\tcontinue;\n\t\t\t\t\t}\n\n\t\t\t\t\tif (field in tableConfig.columns) {\n\t\t\t\t\t\tif (!isIncludeMode && value === true) {\n\t\t\t\t\t\t\tisIncludeMode = true;\n\t\t\t\t\t\t}\n\t\t\t\t\t\tselectedColumns.push(field);\n\t\t\t\t\t}\n\t\t\t\t}\n\n\t\t\t\tif (selectedColumns.length > 0) {\n\t\t\t\t\tselectedColumns = isIncludeMode\n\t\t\t\t\t\t? selectedColumns.filter((c) => config.columns?.[c] === true)\n\t\t\t\t\t\t: Object.keys(tableConfig.columns).filter(\n\t\t\t\t\t\t\t(key) => !selectedColumns.includes(key),\n\t\t\t\t\t\t);\n\t\t\t\t}\n\t\t\t} else {\n\t\t\t\t// Select all columns if selection is not specified\n\t\t\t\tselectedColumns = Object.keys(tableConfig.columns);\n\t\t\t}\n\n\t\t\tfor (const field of selectedColumns) {\n\t\t\t\tconst column = tableConfig.columns[field]! as MsSqlColumn;\n\t\t\t\tfieldsSelection.push({ tsKey: field, value: column });\n\t\t\t}\n\n\t\t\tlet selectedRelations: {\n\t\t\t\ttsKey: string;\n\t\t\t\tqueryConfig: true | V1.DBQueryConfig<'many', false>;\n\t\t\t\trelation: V1.Relation;\n\t\t\t}[] = [];\n\n\t\t\t// Figure out which relations to select\n\t\t\tif (config.with) {\n\t\t\t\tselectedRelations = Object.entries(config.with)\n\t\t\t\t\t.filter(\n\t\t\t\t\t\t(\n\t\t\t\t\t\t\tentry,\n\t\t\t\t\t\t): entry is [(typeof entry)[0], NonNullable<(typeof entry)[1]>] => !!entry[1],\n\t\t\t\t\t)\n\t\t\t\t\t.map(([tsKey, queryConfig]) => ({\n\t\t\t\t\t\ttsKey,\n\t\t\t\t\t\tqueryConfig,\n\t\t\t\t\t\trelation: tableConfig.relations[tsKey]!,\n\t\t\t\t\t}));\n\t\t\t}\n\n\t\t\tlet extras;\n\n\t\t\t// Figure out which extras to select\n\t\t\tif (config.extras) {\n\t\t\t\textras = typeof config.extras === 'function'\n\t\t\t\t\t? config.extras(aliasedColumns, { sql })\n\t\t\t\t\t: config.extras;\n\t\t\t\tfor (const [tsKey, value] of Object.entries(extras)) {\n\t\t\t\t\tfieldsSelection.push({\n\t\t\t\t\t\ttsKey,\n\t\t\t\t\t\tvalue: mapColumnsInAliasedSQLToAlias(value, tableAlias),\n\t\t\t\t\t});\n\t\t\t\t}\n\t\t\t}\n\n\t\t\t// Transform `fieldsSelection` into `selection`\n\t\t\t// `fieldsSelection` shouldn't be used after this point\n\t\t\tfor (const { tsKey, value } of fieldsSelection) {\n\t\t\t\tselection.push({\n\t\t\t\t\tdbKey: is(value, SQL.Aliased)\n\t\t\t\t\t\t? value.fieldAlias\n\t\t\t\t\t\t: tableConfig.columns[tsKey]!.name,\n\t\t\t\t\ttsKey,\n\t\t\t\t\tfield: is(value, Column)\n\t\t\t\t\t\t? aliasedTableColumn(value, tableAlias)\n\t\t\t\t\t\t: value,\n\t\t\t\t\trelationTableTsKey: undefined,\n\t\t\t\t\tisJson: false,\n\t\t\t\t\tselection: [],\n\t\t\t\t});\n\t\t\t}\n\n\t\t\tlet orderByOrig = typeof config.orderBy === 'function'\n\t\t\t\t? config.orderBy(aliasedColumns, V1.getOrderByOperators())\n\t\t\t\t: (config.orderBy ?? []);\n\t\t\tif (!Array.isArray(orderByOrig)) {\n\t\t\t\torderByOrig = [orderByOrig];\n\t\t\t}\n\t\t\torderBy = orderByOrig.map((orderByValue) => {\n\t\t\t\tif (is(orderByValue, Column)) {\n\t\t\t\t\treturn aliasedTableColumn(orderByValue, tableAlias) as MsSqlColumn;\n\t\t\t\t}\n\t\t\t\treturn mapColumnsInSQLToAlias(orderByValue, tableAlias);\n\t\t\t});\n\n\t\t\tlimit = config.limit;\n\t\t\toffset = config.offset;\n\n\t\t\t// Process all relations\n\t\t\tfor (\n\t\t\t\tconst {\n\t\t\t\t\ttsKey: selectedRelationTsKey,\n\t\t\t\t\tqueryConfig: selectedRelationConfigValue,\n\t\t\t\t\trelation,\n\t\t\t\t} of selectedRelations\n\t\t\t) {\n\t\t\t\tconst normalizedRelation = V1.normalizeRelation(\n\t\t\t\t\tschema,\n\t\t\t\t\ttableNamesMap,\n\t\t\t\t\trelation,\n\t\t\t\t);\n\t\t\t\tconst relationTableName = getTableUniqueName(relation.referencedTable);\n\t\t\t\tconst relationTableTsName = tableNamesMap[relationTableName]!;\n\t\t\t\tconst relationTableAlias = `${tableAlias}_${selectedRelationTsKey}`;\n\t\t\t\tconst joinOn = and(\n\t\t\t\t\t...normalizedRelation.fields.map((field, i) =>\n\t\t\t\t\t\teq(\n\t\t\t\t\t\t\taliasedTableColumn(\n\t\t\t\t\t\t\t\tnormalizedRelation.references[i]!,\n\t\t\t\t\t\t\t\trelationTableAlias,\n\t\t\t\t\t\t\t),\n\t\t\t\t\t\t\taliasedTableColumn(field, tableAlias),\n\t\t\t\t\t\t)\n\t\t\t\t\t),\n\t\t\t\t);\n\t\t\t\tconst builtRelation = this.buildRelationalQuery({\n\t\t\t\t\tfullSchema,\n\t\t\t\t\tschema,\n\t\t\t\t\ttableNamesMap,\n\t\t\t\t\ttable: fullSchema[relationTableTsName] as MsSqlTable,\n\t\t\t\t\ttableConfig: schema[relationTableTsName]!,\n\t\t\t\t\tqueryConfig: is(relation, V1.One)\n\t\t\t\t\t\t? selectedRelationConfigValue === true\n\t\t\t\t\t\t\t? { limit: 1 }\n\t\t\t\t\t\t\t: { ...selectedRelationConfigValue, limit: 1 }\n\t\t\t\t\t\t: selectedRelationConfigValue,\n\t\t\t\t\ttableAlias: relationTableAlias,\n\t\t\t\t\tjoinOn,\n\t\t\t\t\tnestedQueryRelation: relation,\n\t\t\t\t});\n\t\t\t\tlet fieldSql = sql`(${builtRelation.sql} for json auto, include_null_values)${\n\t\t\t\t\tnestedQueryRelation\n\t\t\t\t\t\t? sql` as ${sql.identifier(relationTableAlias)}`\n\t\t\t\t\t\t: undefined\n\t\t\t\t}`;\n\t\t\t\tif (is(relation, V1.Many)) {\n\t\t\t\t\tfieldSql = sql`${fieldSql}`;\n\t\t\t\t}\n\t\t\t\tconst field = fieldSql.as(selectedRelationTsKey);\n\t\t\t\tselection.push({\n\t\t\t\t\tdbKey: selectedRelationTsKey,\n\t\t\t\t\ttsKey: selectedRelationTsKey,\n\t\t\t\t\tfield,\n\t\t\t\t\trelationTableTsKey: relationTableTsName,\n\t\t\t\t\tisJson: true,\n\t\t\t\t\tselection: builtRelation.selection,\n\t\t\t\t});\n\t\t\t}\n\t\t}\n\n\t\tif (selection.length === 0) {\n\t\t\tthrow new DrizzleError({\n\t\t\t\tmessage:\n\t\t\t\t\t`No fields selected for table \"${tableConfig.tsName}\" (\"${tableAlias}\"). You need to have at least one item in \"columns\", \"with\" or \"extras\". If you need to select all columns, omit the \"columns\" key or set it to undefined.`,\n\t\t\t});\n\t\t}\n\n\t\tlet result;\n\n\t\twhere = and(joinOn, where);\n\n\t\tif (nestedQueryRelation) {\n\t\t\tlet field = sql`${\n\t\t\t\tsql.join(\n\t\t\t\t\tselection.map((sel) => {\n\t\t\t\t\t\treturn is(sel.field, MsSqlColumn)\n\t\t\t\t\t\t\t? sql.identifier(sel.field.name)\n\t\t\t\t\t\t\t: is(sel.field, SQL.Aliased)\n\t\t\t\t\t\t\t? sel.isJson\n\t\t\t\t\t\t\t\t? sel.field.sql\n\t\t\t\t\t\t\t\t: sql`${sel.field.sql} as ${sql.identifier(sel.field.fieldAlias)}`\n\t\t\t\t\t\t\t: sel.field;\n\t\t\t\t\t}),\n\t\t\t\t\tnew StringChunk(', '),\n\t\t\t\t)\n\t\t\t}`;\n\t\t\tif (is(nestedQueryRelation, V1.Many)) {\n\t\t\t\tfield = sql`${field}`;\n\t\t\t}\n\t\t\tconst nestedSelection = [\n\t\t\t\t{\n\t\t\t\t\tdbKey: 'data',\n\t\t\t\t\ttsKey: 'data',\n\t\t\t\t\tfield,\n\t\t\t\t\tisJson: true,\n\t\t\t\t\trelationTableTsKey: tableConfig.tsName,\n\t\t\t\t\tselection,\n\t\t\t\t},\n\t\t\t];\n\n\t\t\tresult = aliasedTable(table, tableAlias);\n\n\t\t\tconst top = offset ? undefined : (limit ?? undefined);\n\t\t\tconst fetch = offset && limit ? limit : undefined;\n\n\t\t\t// Mssql required order by to be present in the query if using offset and fetch(limit)\n\t\t\t// With order by 1, the query will be ordered by the first column in the selection\n\t\t\tif (orderBy.length === 0 && offset !== undefined && fetch !== undefined) {\n\t\t\t\torderBy = [sql`1`];\n\t\t\t}\n\n\t\t\tresult = this.buildSelectQuery({\n\t\t\t\ttable: is(result, MsSqlTable)\n\t\t\t\t\t? result\n\t\t\t\t\t: new Subquery(result, {}, tableAlias),\n\t\t\t\tfields: {},\n\t\t\t\tfieldsFlat: nestedSelection.map(({ field }) => {\n\t\t\t\t\tconst mapped = is(field, Column) ? aliasedTableColumn(field, tableAlias) : field;\n\t\t\t\t\tconst fieldType = is(mapped, Column) ? 'Column' : is(mapped, SQL.Aliased) ? 'SQL.Aliased' : 'SQL';\n\t\t\t\t\treturn { path: [], field: mapped, fieldType } as SelectedFieldsOrdered[number];\n\t\t\t\t}),\n\t\t\t\twhere,\n\t\t\t\ttop,\n\t\t\t\toffset,\n\t\t\t\tfetch,\n\t\t\t\torderBy,\n\t\t\t\tsetOperators: [],\n\t\t\t});\n\t\t} else {\n\t\t\tconst top = offset ? undefined : (limit ?? undefined);\n\t\t\tconst fetch = offset && limit ? limit : undefined;\n\n\t\t\tif (orderBy.length === 0 && offset !== undefined && fetch !== undefined) {\n\t\t\t\torderBy = [sql`1`];\n\t\t\t}\n\t\t\tresult = this.buildSelectQuery({\n\t\t\t\ttable: aliasedTable(table, tableAlias),\n\t\t\t\tfields: {},\n\t\t\t\tfieldsFlat: selection.map(({ field }) => {\n\t\t\t\t\tconst mapped = is(field, Column) ? aliasedTableColumn(field, tableAlias) : field;\n\t\t\t\t\tconst fieldType = is(mapped, Column) ? 'Column' : is(mapped, SQL.Aliased) ? 'SQL.Aliased' : 'SQL';\n\t\t\t\t\treturn { path: [], field: mapped, fieldType } as SelectedFieldsOrdered[number];\n\t\t\t\t}),\n\t\t\t\twhere,\n\t\t\t\ttop,\n\t\t\t\toffset,\n\t\t\t\tfetch,\n\t\t\t\torderBy,\n\t\t\t\tsetOperators: [],\n\t\t\t});\n\t\t}\n\n\t\treturn {\n\t\t\ttableTsKey: tableConfig.tsName,\n\t\t\tsql: result,\n\t\t\tselection,\n\t\t};\n\t}\n}\n"],"mappings":";;;;;;;;;;;;;;;;;;;;;AAoCA,IAAa,eAAb,MAA0B;CACzB,QAAiBA,0BAAsB;CAEvC,AAAS;CAIT,YAAY,QAA6B;AACxC,OAAK,mBAAmB,EACvB,MAAM,QAAQ,gBAAgBC,gCAAqBC,mCACnD;;CAGF,MAAM,QACL,YACA,SACA,QAC2C;EAC3C,MAAM,mBAAmB,OAAO,WAAW,WACxC,YACC,OAAO,oBAAoB;EAE/B,MAAM,wBAAwB,gBAAG;;6CAEU,iBAAiB;;0BAEpCC,iBAAI,WAAW,iBAAiB,CAAC;;AAGzD,QAAM,QAAQ,QAAQ,sBAAsB;EAE5C,MAAM,kBAAkB,OAAO,WAAW,WACvC,yBACC,OAAO,mBAAmB;EAG9B,MAAM,EAAE,UAAU,oDACjB,kBACA,iBACA,SACA,WACA;AAED,MAAI,OAAO;GACV,MAAM,uBAAuB,gBAAG;;;yBAGV,gBAAgB,sBAAsB,iBAAiB;;kBAE9DA,iBAAI,WAAW,iBAAiB,CAAC,GAAGA,iBAAI,WAAW,gBAAgB,CAAC;;;;;;;;AASnF,SAAM,QAAQ,QAAQ,qBAAqB;;EAG5C,MAAM,gBACL,MAAM,QAAQ,QAQb,gBAAG,0CAA0CA,iBAAI,WAAW,iBAAiB,CAAC,GAC7EA,iBAAI,WACH,gBACA,GAEF,EACA;AAEF,MAAI,OAAO,WAAW,YAAY,OAAO,MAAM;AAC9C,OAAI,aAAa,SAAS,EACzB,QAAO,EAAE,UAAU,sBAA+B;AAGnD,OAAI,WAAW,SAAS,EACvB,QAAO,EAAE,UAAU,mBAA4B;GAGhD,MAAM,CAAC,aAAa;AAEpB,OAAI,CAAC,UAAW;AAEhB,SAAM,QAAQ,QACb,gBAAG,eAAeA,iBAAI,WAAW,iBAAiB,CAAC,GAClDA,iBAAI,WACH,gBACA,CACD,yCAAyC,UAAU,KAAK,IAAI,UAAU,aAAa,IAAI,UAAU,KAAK,GACvG;AAED;;EAGD,MAAM,8DAAqC;GAC1C,iBAAiB;GACjB;GACA,CAAC;AACF,QAAM,QAAQ,YAAY,OAAO,OAAO;AACvC,QAAK,MAAM,aAAa,iBAAiB;AACxC,SAAK,MAAM,QAAQ,UAAU,IAC5B,OAAM,GAAG,QAAQA,iBAAI,IAAI,KAAK,CAAC;AAEhC,UAAM,GAAG,QACR,gBAAG,eAAeA,iBAAI,WAAW,iBAAiB,CAAC,GAClDA,iBAAI,WACH,gBACA,CACD,yCAAyC,UAAU,KAAK,IAAI,UAAU,aAAa,IAAI,UAAU,KAAK,GACvG;;IAED;;CAGH,WAAW,MAAsB;AAChC,SAAO,IAAI,KAAK,QAAQ,OAAO,KAAK,CAAC;;CAGtC,YAAY,MAAsB;AACjC,SAAO,OAAO;;CAGf,aAAa,KAAqB;AACjC,SAAO,IAAI,IAAI,QAAQ,MAAM,KAAK,CAAC;;CAGpC,iBAAiB,EAAE,OAAO,OAAO,UAAkC;AAOlE,SAAO,gBAAG,eAAe,QANP,SACf,gBAAG,WAAW,KAAK,qBAAqB,QAAQ,EAAE,MAAM,WAAW,CAAC,KACpE,SAEc,QAAQ,gBAAG,UAAU,UAAU;;CAKjD,eAAe,OAAmB,KAAqB;EACtD,MAAM,eAAe,MAAMC,iBAAM,OAAO;EAExC,MAAM,cAAc,OAAO,KAAK,aAAa,CAAC,QAC5C,YACA,IAAI,aAAa,UACd,aAAa,UAAU,eAAe,OAC1C;EAED,MAAM,YAAY,YAAY;EAC9B,MAAM,SAAqB,IAAI,MAAM,UAAU;AAE/C,OAAK,IAAI,IAAI,GAAG,IAAI,YAAY,QAAQ,EAAE,GAAG;GAC5C,MAAM,UAAU,YAAY;GAC5B,MAAM,MAAM,aAAa;GAEzB,IAAI;AACJ,OAAI,IAAI,aAAa,OACpB,SAAQ,IAAI;QACN;IACN,MAAM,YAAY,IAAI,cAAc;AACpC,gCAAW,WAAWC,iBAAI,GAAG,YAAYF,iBAAI,MAAM,WAAW,IAAI;;AAGnE,UAAO,KAAK,IAAI,YAAY,IACzB,gBAAG,GAAGA,iBAAI,WAAW,IAAI,KAAK,CAAC,KAAK,MAAM,MAC1C,gBAAG,GAAGA,iBAAI,WAAW,IAAI,KAAK,CAAC,KAAK;;AAGxC,SAAO,IAAIE,iBAAI,OAAO;;CAiBvB,iBAAiB,EAAE,OAAO,KAAK,OAAO,UAAkC;EACvE,MAAM,SAAS,KAAK,eAAe,OAAO,IAAI;EAE9C,MAAM,YAAY,gBAAG;AAErB,MAAI,QAAQ;AACX,aAAU,OAAO,gBAAG,WAAW;AAE/B,OAAI,OAAO,SACV,WAAU,OACT,KAAK,qBAAqB,OAAO,UAAU,EAAE,MAAM,YAAY,CAAC,CAChE;AAGF,OAAI,OAAO,SAAS;AACnB,QAAI,OAAO,SAAU,WAAU,OAAO,gBAAG,KAAK;AAC9C,cAAU,OACT,KAAK,qBAAqB,OAAO,SAAS,EAAE,MAAM,WAAW,CAAC,CAC9D;;;AAMH,SAAO,gBAAG,UAAU,MAAM,OAAO,SAAS,YAFzB,QAAQ,gBAAG,UAAU,UAAU;;;;;;;;;;;;;CAgBjD,AAAQ,eACP,QACA,EAAE,gBAAgB,OAAO,UAGrB,EAAE,EACA;EACN,MAAM,EAAE,QAAQ,eAAe;EAC/B,MAAM,SAAqB,EAAE;EAC7B,MAAM,YAAY,4BACZ,OAAOA,iBAAI,wBAAO,OAAOC,uBAAS,GACpC,SACC,MAAMF,iBAAM,OAAO,YAAY,MAAMA,iBAAM,OAAO,YAAY,SAC9D,MAAMA,iBAAM,OAAO,QACnB,GAAG,MAAMA,iBAAM,OAAO,QAAQ,GAAG,MAAMA,iBAAM,OAAO,UACtD;AAEH,OAAK,IAAI,IAAI,GAAG,IAAI,YAAY,EAAE,GAAG;GACpC,MAAM,EAAE,OAAO,cAAc,OAAO;AAEpC,WAAQ,WAAR;IACC,KAAK;AACJ,SAAI,cACH,QAAO,KACN,MAAM,UACH,gBAAG,GAAGD,iBAAI,sDAAsC,MAAM,CAAC,KAAK,CAAC,MAAM,UACnEA,iBAAI,WAAW,MAAM,KAAK,CAC7B;SAED,QAAO,KACN,MAAM,UACH,gBAAG,8CAA8B,MAAM,CAAC,MAAM,UAC9C,MACH;AAGF;IAED,KAAK;AACJ,SAAI,MAAM,kBAAkB;AAC3B,UAAI,CAAC,iBAAiB,MAAM,WAAW,OACtC,QAAO,KAAKA,iBAAI,WAAW,MAAM,OAAO,EAAE,IAAII,yBAAY,IAAI,CAAC;AAEhE,aAAO,KAAKJ,iBAAI,WAAW,MAAM,WAAW,CAAC;YACvC;AACN,UAAI,iBAAiB,cAAc,QAAW;OAC7C,MAAM,EAAE,gBAAgB,MAAM;OAC9B,MAAM,YAAwB,IAAI,MAAM,YAAY,OAAO;OAC3D,IAAI,QAAQ;AAEZ,YAAK,IAAI,IAAI,GAAG,IAAI,YAAY,QAAQ,EAAE,GAAG;QAC5C,MAAM,IAAI,YAAY;AACtB,gCAAO,GAAGK,mBAAO,EAAE;SAClB,MAAM,EAAE,UAAU;AAIlB,cAHwB,MAAMJ,iBAAM,OAAO,YAAY,MAAMA,iBAAM,OAAO,YAAY,SACnF,MAAMA,iBAAM,OAAO,QACnB,GAAG,MAAMA,iBAAM,OAAO,QAAQ,GAAG,MAAMA,iBAAM,OAAO,aAC/B,WAAW;AAClC,kBAAQ;AACR;;AAGD,mBAAU,KAAKD,iBAAI,WAAW,EAAE,KAAK;cAErC,WAAU,KAAK;;AAIjB,WAAI,MACH,QAAO,KAAK,MAAM,IAAI;YAChB;QACN,MAAM,SAAS,IAAIE,iBAAI,UAAU;AACjC,YAAI,MAAM,IAAI,mBAAoB,QAAO,cAAc;AACvD,eAAO,KAAK,OAAO;;YAGpB,QAAO,KAAK,MAAM,IAAI;AAGvB,aAAO,KAAK,gBAAG,OAAOF,iBAAI,WAAW,MAAM,WAAW,GAAG;;AAG1D;IAED,KAAK;AACJ,SAAI,iBAAiB,cAAc,QAAW;MAC7C,MAAM,EAAE,gBAAgB;MACxB,MAAM,YAAwB,IAAI,MAAM,YAAY,OAAO;MAC3D,IAAI,QAAQ;AAEZ,WAAK,IAAI,IAAI,GAAG,IAAI,YAAY,QAAQ,EAAE,GAAG;OAC5C,MAAM,IAAI,YAAY;AACtB,+BAAO,GAAGK,mBAAO,EAAE;QAClB,MAAM,EAAE,UAAU;AAIlB,aAHwB,MAAMJ,iBAAM,OAAO,YAAY,MAAMA,iBAAM,OAAO,YAAY,SACnF,MAAMA,iBAAM,OAAO,QACnB,GAAG,MAAMA,iBAAM,OAAO,QAAQ,GAAG,MAAMA,iBAAM,OAAO,aAC/B,WAAW;AAClC,iBAAQ;AACR;;AAGD,kBAAU,KAAKD,iBAAI,WAAW,EAAE,KAAK;aAErC,WAAU,KAAK;;AAIjB,UAAI,MACH,QAAO,KAAK,MAAM;WACZ;OACN,MAAM,SAAS,IAAIE,iBAAI,UAAU;AACjC,WAAI,MAAM,mBAAoB,QAAO,cAAc;AACnD,cAAO,KAAK,OAAO;;WAEd,QAAO,KAAK,MAAM;AAEzB;IAED,KAAK;AACJ,SAAI,CAAC,MAAM,EAAE,OACZ,QAAO,KAAK,gBAAG,IAAI,MAAM,EAAE,IAAI,IAAIF,iBAAI,WAAW,MAAM,EAAE,MAAM,GAAG;SAEnE,QAAO,KAAK,MAAM;AAGnB;;AAIF,OAAI,IAAI,aAAa,EACpB,QAAO,KAAK,IAAII,yBAAY,KAAK,CAAC;;AAIpC,SAAO,IAAIF,iBAAI,OAAO;;CAGvB,AAAQ,qBACP,QACA,EAAE,QACI;EACN,MAAM,EAAE,QAAQ,eAAe;EAC/B,MAAM,SAAqB,EAAE;AAE7B,OAAK,IAAI,IAAI,GAAG,IAAI,YAAY,EAAE,GAAG;GACpC,MAAM,EAAE,OAAO,cAAc,OAAO;AAEpC,WAAQ,WAAR;IACC,KAAK;AACJ,YAAO,KACNF,iBAAI,KAAK,CACR,IAAII,yBAAY,GAAG,KAAK,GAAG,EAC3B,MAAM,UACH,gBAAG,GAAGJ,iBAAI,sDAAsC,MAAM,CAAC,KAAK,CAAC,MAAM,UACnEA,iBAAI,WAAW,MAAM,KAAK,CAC7B,CAAC,CACF;AAED;IAED,KAAK;AACJ,SAAI,MAAM,iBACT,QAAO,KACNA,iBAAI,KAAK,CAAC,IAAII,yBAAY,GAAG,KAAK,GAAG,EAAEJ,iBAAI,WAAW,MAAM,WAAW,CAAC,CAAC,CACzE;UACK;MACN,MAAM,QAAQ,MAAM;AAEpB,aAAO,KACN,IAAIE,iBACH,MAAM,YAAY,KAAK,MAAM;AAC5B,+BAAO,GAAGI,8CAAY,CACrB,QAAON,iBAAI,KAAK,CACf,IAAII,yBAAY,GAAG,KAAK,GAAG,EAC3BJ,iBAAI,WAAW,EAAE,KAAK,CACtB,CAAC;AAEH,cAAO;QACN,CACF,CACD;AAED,aAAO,KAAK,gBAAG,OAAOA,iBAAI,WAAW,MAAM,WAAW,GAAG;;AAG1D;IAED,KAAK,OAAO;KACX,MAAM,QAAQ;AAEd,YAAO,KACN,IAAIE,iBACH,MAAM,YAAY,KAAK,MAAM;AAC5B,8BAAO,GAAGI,8CAAY,CACrB,QAAON,iBAAI,KAAK,CACf,IAAII,yBAAY,GAAG,KAAK,GAAG,EAC3BJ,iBAAI,WAAW,EAAE,KAAK,CACtB,CAAC;AAEH,aAAO;OACN,CACF,CACD;AAED;;;AAIF,OAAI,IAAI,aAAa,EACpB,QAAO,KAAK,IAAII,yBAAY,KAAK,CAAC;;AAIpC,SAAO,IAAIF,iBAAI,OAAO;;CAGvB,iBAAiB,EAChB,UACA,YACA,OACA,QACA,OACA,OACA,SACA,SACA,OACA,KAAK,MACL,KACA,QACA,UACA,gBAC0B;AAC1B,MAAI,CAAC,WACJ,OAAM,IAAI,MAAM,2FAA2F;EAE5G,MAAM,aAAa;AACnB,OAAK,MAAM,KAAK,WACf,yBACI,EAAE,OAAOG,mBAAO,iCACH,EAAE,MAAM,MAAM,0BACrB,OAAOF,uBAAS,GACrB,MAAM,EAAE,4BACL,OAAOI,2CAAc,GACxB,MAAMC,oCAAgB,2BACnB,OAAON,iBAAI,GACd,sCACa,MAAM,KACpB,GAAG,UACL,OAAO,MACL,EAAE,YACF,WACM,MAAMD,iBAAM,OAAO,wCACR,MAAM,GACnB,MAAMA,iBAAM,OAAO,WACxB,EAAE,EAAE,MAAM,MAAM,EACjB;GACD,MAAM,yCAAyB,EAAE,MAAM,MAAM;AAC7C,SAAM,IAAI,MACT,SACC,EAAE,KAAK,KACN,KACA,CACD,+BAA+B,UAAU,KAAK,EAAE,MAAM,KAAK,oBAAoB,UAAU,wDAC1F;;EAIH,MAAM,gBAAgB,CAAC,SAAS,MAAM,WAAW;EAEjD,IAAI;AACJ,MAAI,UAAU,QAAQ;GACrB,MAAM,cAAc,SAAS;GAC7B,MAAM,gBAA4B,IAAI,MAAM,cAAc,EAAE;GAC5D,IAAI,WAAW;AACf,iBAAc,cAAc,IAAIG,yBAAY,QAAQ;AAEpD,QAAK,IAAI,IAAI,GAAG,IAAI,aAAa,EAAE,GAAG;IACrC,MAAM,IAAI,SAAS;AACnB,kBAAc,cAAe,IAAI,cAAc,IAC5C,gBAAG,GAAGJ,iBAAI,WAAW,EAAE,EAAE,MAAM,CAAC,OAAO,EAAE,EAAE,IAAI,OAC/C,gBAAG,GAAGA,iBAAI,WAAW,EAAE,EAAE,MAAM,CAAC,OAAO,EAAE,EAAE,IAAI;;AAGnD,aAAU,IAAIE,iBAAI,cAAc;;EAGjC,MAAM,cAAc,WAAW,gBAAG,cAAc;EAEhD,MAAM,SAAS,MAAM,gBAAG,QAAQ,IAAI,KAAK;EAEzC,MAAM,YAAY,KAAK,eAAe,YAAY;GAAE;GAAe;GAAO,CAAC;EAE3E,MAAM,kBAAkB;AACvB,2BACI,OAAOD,iBAAM,IACb,MAAMA,iBAAM,OAAO,kBAAkB,MAAMA,iBAAM,OAAO,OAC1D;IACD,IAAI,WAAW,gBAAG,GAAGD,iBAAI,WAAW,MAAMC,iBAAM,OAAO,cAAc,CAAC,GACrED,iBAAI,WACH,MAAMC,iBAAM,OAAO,MACnB;AAEF,QAAI,MAAMA,iBAAM,OAAO,QACtB,YAAW,gBAAG,GAAGD,iBAAI,WAAW,MAAMC,iBAAM,OAAO,QAAS,CAAC,GAAG;AAEjE,WAAO;;AAGR,2BAAO,OAAOQ,kBAAK,IAAI,MAAMD,oCAAgB,SAAS;IACrD,IAAI,WAAW,gBAAG,GAAGR,iBAAI,WAAW,MAAMQ,oCAAgB,aAAa;AACvE,QAAI,MAAMA,oCAAgB,OACzB,YAAW,gBAAG,GAAGR,iBAAI,WAAW,MAAMQ,oCAAgB,OAAO,CAAC,GAAG;AAElE,WAAO,gBAAG,GAAG,SAAS,GAAGR,iBAAI,WAAW,MAAMQ,oCAAgB,KAAK;;AAGpE,UAAO;MACJ;EAEJ,MAAM,aAAyB,EAAE;AAEjC,MAAI,MACH,MAAK,MAAM,CAAC,OAAO,aAAa,MAAM,SAAS,EAAE;AAChD,OAAI,UAAU,EACb,YAAW,KAAK,IAAIJ,yBAAY,IAAI,CAAC;GAEtC,MAAM,QAAQ,SAAS;GACvB,MAAM,cAAc,SAAS,UAC1B,IAAIA,yBAAY,SAAS,aAAa,SAAS,gBAAgB,cAAc,GAC7E,IAAIA,yBAAY,GAAG,SAAS,SAAS,OAAO;GAC/C,MAAM,QAAQ,SAAS,KAAK,gBAAG,OAAO,SAAS,OAAO;AAEtD,2BAAO,OAAOM,oCAAW,EAAE;IAC1B,MAAM,YAAY,MAAMA,oCAAW,OAAO;IAC1C,MAAM,cAAc,MAAMA,oCAAW,OAAO;IAC5C,MAAM,gBAAgB,MAAMA,oCAAW,OAAO;IAC9C,MAAM,QAAQ,cAAc,gBAAgB,SAAY,SAAS;AACjE,eAAW,KACV,gBAAG,GAAG,YAAY,GAAG,cAAc,gBAAG,GAAGV,iBAAI,WAAW,YAAY,CAAC,KAAK,SACzEA,iBAAI,WAAW,cAAc,GAC3B,SAAS,gBAAG,IAAIA,iBAAI,WAAW,MAAM,KAAK,QAC7C;kCACY,OAAOS,kBAAK,EAAE;IAC3B,MAAM,WAAW,MAAMD,oCAAgB;IACvC,MAAM,aAAa,MAAMA,oCAAgB;IACzC,MAAM,eAAe,MAAMA,oCAAgB;IAC3C,MAAM,QAAQ,aAAa,eAAe,SAAY,SAAS;AAC/D,eAAW,KACV,gBAAG,GAAG,YAAY,GAAG,aAAa,gBAAG,GAAGR,iBAAI,WAAW,WAAW,CAAC,KAAK,SACvEA,iBAAI,WAAW,aAAa,GAC1B,SAAS,gBAAG,IAAIA,iBAAI,WAAW,MAAM,KAAK,QAC7C;SAED,YAAW,KACV,gBAAG,GAAG,YAAY,GAAG,QAAQ,QAC7B;AAEF,OAAI,QAAQ,MAAM,SAAS,EAC1B,YAAW,KAAK,IAAII,yBAAY,IAAI,CAAC;;EAKxC,MAAM,WAAW,IAAIF,iBAAI,WAAW;EAEpC,MAAM,WAAW,QAAQ,gBAAG,UAAU,UAAU;EAEhD,MAAM,YAAY,SAAS,gBAAG,WAAW,WAAW;EAEpD,IAAI;AACJ,MAAI,WAAW,QAAQ,SAAS,EAC/B,cAAa,gBAAG,aAAaF,iBAAI,KAAK,SAAS,IAAII,yBAAY,KAAK,CAAC;EAGtE,IAAI;AACJ,MAAI,WAAW,QAAQ,SAAS,EAC/B,cAAa,gBAAG,aAAaJ,iBAAI,KAAK,SAAS,IAAII,yBAAY,KAAK,CAAC;EAGtE,MAAM,YAAY,WAAW,SAAY,SAAY,gBAAG,WAAW,OAAO;EAE1E,MAAM,WAAW,UAAU,SAAY,SAAY,gBAAG,eAAe,MAAM;EAE3E,IAAI;AACJ,MAAI,QAAQ,KAAK,SAAS,OACzB,UAAS,gBAAG,aAAa,IAAIA,yBAAY,KAAK,KAAK,GAClD,KAAK,SAAS,OACX,gBAAG,SAASJ,iBAAI,WAAW,KAAK,QAAQ,KAAK,CAAC,KAC9C,SACD,KAAK,SAAS,oBAAoB,gBAAG,yBAAyB,SAChE,KAAK,SAAS,sBACX,gBAAG,2BACH;EAIL,MAAM,aACL,gBAAG,GAAG,QAAQ,QAAQ,cAAc,OAAO,GAAG,UAAU,QAAQ,WAAW,WAAW,WAAW,aAAa,YAAY,aAAa,YAAY,WAAW;AAE/J,MAAI,aAAa,SAAS,EACzB,QAAO,KAAK,mBAAmB,YAAY,aAAa;AAGzD,SAAO;;CAGR,mBACC,YACA,cACM;EACN,MAAM,CAAC,aAAa,GAAG,QAAQ;AAE/B,MAAI,CAAC,YACJ,OAAM,IAAI,MAAM,mDAAmD;AAGpE,MAAI,KAAK,WAAW,EACnB,QAAO,KAAK,uBAAuB;GAAE;GAAY;GAAa,CAAC;AAIhE,SAAO,KAAK,mBACX,KAAK,uBAAuB;GAAE;GAAY;GAAa,CAAC,EACxD,KACA;;CAGF,uBAAuB,EACtB,YACA,aAAa,EAAE,MAAM,OAAO,aAAa,OAAO,SAAS,YAIlD;EACP,MAAM,YAAY,gBAAG,IAAI,WAAW,QAAQ,CAAC;EAC7C,MAAM,aAAa,gBAAG,IAAI,YAAY,QAAQ,CAAC;EAE/C,IAAI;AACJ,MAAI,WAAW,QAAQ,SAAS,GAAG;GAClC,MAAM,gBAAyC,EAAE;AAIjD,QAAK,MAAM,eAAe,QACzB,yBAAO,aAAaM,8CAAY,CAC/B,eAAc,KAAKN,iBAAI,WAAW,YAAY,KAAK,CAAC;gCACvC,aAAaE,iBAAI,EAAE;AAChC,SAAK,IAAI,IAAI,GAAG,IAAI,YAAY,YAAY,QAAQ,KAAK;KACxD,MAAM,QAAQ,YAAY,YAAY;AAEtC,6BAAO,OAAOI,8CAAY,CACzB,aAAY,YAAY,KAAKN,iBAAI,WAAW,MAAM,KAAK;;AAIzD,kBAAc,KAAK,gBAAG,GAAG,cAAc;SAEvC,eAAc,KAAK,gBAAG,GAAG,cAAc;AAIzC,gBAAa,gBAAG,aAAaA,iBAAI,KAAK,eAAe,IAAII,yBAAY,KAAK,CAAC,CAAC;;EAG7E,MAAM,YAAY,WAAW,SAAY,SAAY,gBAAG,WAAW,OAAO;EAE1E,MAAM,WAAW,UAAU,SAAY,SAAY,gBAAG,eAAe,MAAM;AAI3E,SAAO,gBAAG,GAAG,YAFS,IAAIA,yBAAY,GAAG,KAAK,GAAG,QAAQ,SAAS,KAAK,GAE9B,aAAa,aAAa,YAAY;;CAGhF,iBAAiB,EAAE,OAAO,QAAQ,gBAAgB,QAAQ,YAAY,UAAkC;EACvG,MAAM,UAAuC,MAAMH,iBAAM,OAAO;EAChE,MAAM,aAAsC,UAAU,qBAAI,gBAAgBC,iBAAI,GAC3E,OACA,KAAM,eAA0C,mBAAmB,CAAC,CACpE,KAAK,QAAQ,CAAC,KAAK,QAAQ,KAAM,CAA0B,GAC3D,aACA,WAAW,KAAK,SAAS,CAAC,MAAM,QAAQ,MAAO,CAA0B,GACzE,OAAO,QAAQ,QAAQ,CAAC,QACxB,CAAC,GAAG,SAAS,CAAC,IAAI,qBAAqB,CACxC;AAEF,MAAI,WAAW,WAAW,KAAK,CAAC,UAAW,eAA6C,SAAS,EAChG,OAAM,IAAIS,4BAAa,EACtB,SAAS,iBAAkB,eAA6C,OAAO,cAC9E,MAAMV,iBAAM,OAAO,MACnB,mGACD,CAAC;EAGH,MAAM,iBAA6B,IAAI,MAAM,WAAW,SAAS,IAAI,EAAE;EACvE,IAAI,gBAAgB;AACpB,iBAAe,mBAAmB,IAAIG,yBAAY,IAAI;AACtD,OAAK,IAAI,IAAI,GAAG,IAAI,WAAW,QAAQ,EAAE,GAAG;GAC3C,MAAM,GAAG,EAAE,UAAU,WAAW;AAChC,kBAAe,mBAAmBJ,iBAAI,WAAW,KAAK;AAEtD,OAAI,IAAI,WAAW,SAAS,EAAG,gBAAe,mBAAmB,IAAII,yBAAY,KAAK;;AAEvF,iBAAe,mBAAmB,IAAIA,yBAAY,IAAI;EACtD,MAAM,cAAc,IAAIF,iBAAI,eAAe;EAE3C,MAAM,gBAA4B,MAAM,KAAK,EAC5C,QAAQ,SAAS,KAAK,WAAW,SAAS,IAAI,KAAM,eAA6C,SAC7F,eAA6C,SAAS,GAC1D,CAAC;AAEF,MAAI,OACH,eAAc,KAAM,eAAoD,QAAQ;OAC1E;GACN,MAAM,SAAS;GAEf,IAAI,WAAW;AAEf,QAAK,IAAI,aAAa,GAAG,aAAa,OAAO,QAAQ,EAAE,YAAY;IAClE,MAAM,QAAQ,OAAO;AAErB,kBAAc,cAAc,IAAIE,yBAAY,IAAI;AAChD,SAAK,IAAI,IAAI,GAAG,IAAI,WAAW,QAAQ,EAAE,GAAG;KAC3C,MAAM,CAAC,WAAW,OAAO,WAAW;KACpC,MAAM,WAAW,MAAM;AACvB,SAAI,aAAa,OAChB,KAAI,IAAI,cAAc,QAAW;MAChC,MAAM,kBAAkB,IAAI,WAAW;MACvC,MAAM,mCAAkB,iBAAiBF,iBAAI,GAC1C,kBACAF,iBAAI,MAAM,iBAAiB,IAAI;AAClC,oBAAc,cAAc;gBAClB,CAAC,IAAI,WAAW,IAAI,eAAe,QAAW;MACxD,MAAM,mBAAmB,IAAI,YAAY;MACzC,MAAM,+BAAc,kBAAkBE,iBAAI,GACvC,mBACAF,iBAAI,MAAM,kBAAkB,IAAI;AACnC,oBAAc,cAAc;WAE5B,eAAc,cAAc,IAAII,yBAAY,UAAU;SAGvD,eAAc,kCAAiB,UAAUF,iBAAI,GAAG,WAAW,IAAIU,mBAAM,UAAU,IAAI;AAGpF,SAAI,IAAI,WAAW,SAAS,EAC3B,eAAc,cAAc,IAAIR,yBAAY,KAAK;;AAInD,kBAAc,cAAc,IAAIA,yBAAY,IAAI;AAEhD,QAAI,aAAa,OAAO,SAAS,EAChC,eAAc,cAAc,IAAIA,yBAAY,KAAK;;;EAKpD,MAAM,YAAY,SACf,gBAAG,WAAW,KAAK,qBAAqB,QAAQ,EAAE,MAAM,YAAY,CAAC,KACrE;AAEH,MAAI,OACH,QAAO,gBAAG,eAAe,MAAM,GAAG,cAAc,UAAU,GAAG,IAAIF,iBAAI,cAAc;AAGpF,MAAI,WAAW,WAAW,EACzB,QAAO,gBAAG,eAAe,QAAQ,UAAU;AAG5C,SAAO,gBAAG,eAAe,MAAM,GAAG,cAAc,UAAU,UAAU,IAAIA,iBAAI,cAAc;;CAG3F,WACC,KACA,cACQ;AAOR,SANY,IAAI,QAAQ;GACvB,YAAY,KAAK;GACjB,aAAa,KAAK;GAClB,cAAc,KAAK;GACnB;GACA,CAAC;;CAIH,qBAAqB,EACpB,YACA,QACA,eACA,OACA,aACA,aAAa,QACb,YACA,qBACA,UAW0D;EAC1D,IAAI,YAGa,EAAE;EACnB,IAAI,OACH,QACA,UAAwC,EAAE,EAC1C;AAED,MAAI,WAAW,KAEd,aADyB,OAAO,QAAQ,YAAY,QAAQ,CAC/B,KAAK,CAAC,KAAK,YAAY;GACnD,OAAO,MAAM;GACb,OAAO;GACP,0CAA0B,OAAsB,WAAW;GAC3D,oBAAoB;GACpB,QAAQ;GACR,WAAW,EAAE;GACb,EAAE;OACG;GACN,MAAM,iBAAiB,OAAO,YAC7B,OAAO,QAAQ,YAAY,QAAQ,CAAC,KAAK,CAAC,KAAK,WAAW,CACzD,wCACmB,OAAO,WAAW,CACrC,CAAC,CACF;AAED,OAAI,OAAO,OAAO;IACjB,MAAM,WAAW,OAAO,OAAO,UAAU,aACtC,OAAO,MAAM,gBAAgBW,gBAAG,cAAc,CAAC,GAC/C,OAAO;AACV,YAAQ,mDAAmC,UAAU,WAAW;;GAGjE,MAAM,kBAGA,EAAE;GACR,IAAI,kBAA4B,EAAE;AAGlC,OAAI,OAAO,SAAS;IACnB,IAAI,gBAAgB;AAEpB,SAAK,MAAM,CAAC,OAAO,UAAU,OAAO,QAAQ,OAAO,QAAQ,EAAE;AAC5D,SAAI,UAAU,OACb;AAGD,SAAI,SAAS,YAAY,SAAS;AACjC,UAAI,CAAC,iBAAiB,UAAU,KAC/B,iBAAgB;AAEjB,sBAAgB,KAAK,MAAM;;;AAI7B,QAAI,gBAAgB,SAAS,EAC5B,mBAAkB,gBACf,gBAAgB,QAAQ,MAAM,OAAO,UAAU,OAAO,KAAK,GAC3D,OAAO,KAAK,YAAY,QAAQ,CAAC,QACjC,QAAQ,CAAC,gBAAgB,SAAS,IAAI,CACvC;SAIH,mBAAkB,OAAO,KAAK,YAAY,QAAQ;AAGnD,QAAK,MAAM,SAAS,iBAAiB;IACpC,MAAM,SAAS,YAAY,QAAQ;AACnC,oBAAgB,KAAK;KAAE,OAAO;KAAO,OAAO;KAAQ,CAAC;;GAGtD,IAAI,oBAIE,EAAE;AAGR,OAAI,OAAO,KACV,qBAAoB,OAAO,QAAQ,OAAO,KAAK,CAC7C,QAEC,UACkE,CAAC,CAAC,MAAM,GAC3E,CACA,KAAK,CAAC,OAAO,kBAAkB;IAC/B;IACA;IACA,UAAU,YAAY,UAAU;IAChC,EAAE;GAGL,IAAI;AAGJ,OAAI,OAAO,QAAQ;AAClB,aAAS,OAAO,OAAO,WAAW,aAC/B,OAAO,OAAO,gBAAgB,EAAE,uBAAK,CAAC,GACtC,OAAO;AACV,SAAK,MAAM,CAAC,OAAO,UAAU,OAAO,QAAQ,OAAO,CAClD,iBAAgB,KAAK;KACpB;KACA,qDAAqC,OAAO,WAAW;KACvD,CAAC;;AAMJ,QAAK,MAAM,EAAE,OAAO,WAAW,gBAC9B,WAAU,KAAK;IACd,2BAAU,OAAOX,iBAAI,QAAQ,GAC1B,MAAM,aACN,YAAY,QAAQ,OAAQ;IAC/B;IACA,2BAAU,OAAOG,mBAAO,sCACF,OAAO,WAAW,GACrC;IACH,oBAAoB;IACpB,QAAQ;IACR,WAAW,EAAE;IACb,CAAC;GAGH,IAAI,cAAc,OAAO,OAAO,YAAY,aACzC,OAAO,QAAQ,gBAAgBQ,gBAAG,qBAAqB,CAAC,GACvD,OAAO,WAAW,EAAE;AACxB,OAAI,CAAC,MAAM,QAAQ,YAAY,CAC9B,eAAc,CAAC,YAAY;AAE5B,aAAU,YAAY,KAAK,iBAAiB;AAC3C,4BAAO,cAAcR,mBAAO,CAC3B,2CAA0B,cAAc,WAAW;AAEpD,kDAA8B,cAAc,WAAW;KACtD;AAEF,WAAQ,OAAO;AACf,YAAS,OAAO;AAGhB,QACC,MAAM,EACL,OAAO,uBACP,aAAa,6BACb,cACI,mBACJ;IACD,MAAM,qBAAqBQ,gBAAG,kBAC7B,QACA,eACA,SACA;IAED,MAAM,sBAAsB,iDADiB,SAAS,gBAAgB;IAEtE,MAAM,qBAAqB,GAAG,WAAW,GAAG;IAC5C,MAAM,SAASC,uCACd,GAAG,mBAAmB,OAAO,KAAK,OAAO,MACxCC,yEAEE,mBAAmB,WAAW,IAC9B,mBACA,qCACkB,OAAO,WAAW,CACrC,CACD,CACD;IACD,MAAM,gBAAgB,KAAK,qBAAqB;KAC/C;KACA;KACA;KACA,OAAO,WAAW;KAClB,aAAa,OAAO;KACpB,iCAAgB,UAAUF,gBAAG,IAAI,GAC9B,gCAAgC,OAC/B,EAAE,OAAO,GAAG,GACZ;MAAE,GAAG;MAA6B,OAAO;MAAG,GAC7C;KACH,YAAY;KACZ;KACA,qBAAqB;KACrB,CAAC;IACF,IAAI,WAAW,gBAAG,IAAI,cAAc,IAAI,sCACvC,sBACG,gBAAG,OAAOb,iBAAI,WAAW,mBAAmB,KAC5C;AAEJ,4BAAO,UAAUa,gBAAG,KAAK,CACxB,YAAW,gBAAG,GAAG;IAElB,MAAM,QAAQ,SAAS,GAAG,sBAAsB;AAChD,cAAU,KAAK;KACd,OAAO;KACP,OAAO;KACP;KACA,oBAAoB;KACpB,QAAQ;KACR,WAAW,cAAc;KACzB,CAAC;;;AAIJ,MAAI,UAAU,WAAW,EACxB,OAAM,IAAIF,4BAAa,EACtB,SACC,iCAAiC,YAAY,OAAO,MAAM,WAAW,6JACtE,CAAC;EAGH,IAAI;AAEJ,UAAQG,uCAAI,QAAQ,MAAM;AAE1B,MAAI,qBAAqB;GACxB,IAAI,QAAQ,gBAAG,GACdd,iBAAI,KACH,UAAU,KAAK,QAAQ;AACtB,+BAAU,IAAI,OAAOM,8CAAY,GAC9BN,iBAAI,WAAW,IAAI,MAAM,KAAK,uBAC3B,IAAI,OAAOE,iBAAI,QAAQ,GAC1B,IAAI,SACH,IAAI,MAAM,MACV,gBAAG,GAAG,IAAI,MAAM,IAAI,MAAMF,iBAAI,WAAW,IAAI,MAAM,WAAW,KAC/D,IAAI;KACN,EACF,IAAII,yBAAY,KAAK,CACrB;AAEF,2BAAO,qBAAqBS,gBAAG,KAAK,CACnC,SAAQ,gBAAG,GAAG;GAEf,MAAM,kBAAkB,CACvB;IACC,OAAO;IACP,OAAO;IACP;IACA,QAAQ;IACR,oBAAoB,YAAY;IAChC;IACA,CACD;AAED,yCAAsB,OAAO,WAAW;GAExC,MAAM,MAAM,SAAS,SAAa,SAAS;GAC3C,MAAM,QAAQ,UAAU,QAAQ,QAAQ;AAIxC,OAAI,QAAQ,WAAW,KAAK,WAAW,UAAa,UAAU,OAC7D,WAAU,CAAC,gBAAG,IAAI;AAGnB,YAAS,KAAK,iBAAiB;IAC9B,2BAAU,QAAQH,oCAAW,GAC1B,SACA,IAAIP,uBAAS,QAAQ,EAAE,EAAE,WAAW;IACvC,QAAQ,EAAE;IACV,YAAY,gBAAgB,KAAK,EAAE,YAAY;KAC9C,MAAM,6BAAY,OAAOE,mBAAO,sCAAsB,OAAO,WAAW,GAAG;AAE3E,YAAO;MAAE,MAAM,EAAE;MAAE,OAAO;MAAQ,+BADb,QAAQA,mBAAO,GAAG,+BAAc,QAAQH,iBAAI,QAAQ,GAAG,gBAAgB;MAC/C;MAC5C;IACF;IACA;IACA;IACA;IACA;IACA,cAAc,EAAE;IAChB,CAAC;SACI;GACN,MAAM,MAAM,SAAS,SAAa,SAAS;GAC3C,MAAM,QAAQ,UAAU,QAAQ,QAAQ;AAExC,OAAI,QAAQ,WAAW,KAAK,WAAW,UAAa,UAAU,OAC7D,WAAU,CAAC,gBAAG,IAAI;AAEnB,YAAS,KAAK,iBAAiB;IAC9B,oCAAoB,OAAO,WAAW;IACtC,QAAQ,EAAE;IACV,YAAY,UAAU,KAAK,EAAE,YAAY;KACxC,MAAM,6BAAY,OAAOG,mBAAO,sCAAsB,OAAO,WAAW,GAAG;AAE3E,YAAO;MAAE,MAAM,EAAE;MAAE,OAAO;MAAQ,+BADb,QAAQA,mBAAO,GAAG,+BAAc,QAAQH,iBAAI,QAAQ,GAAG,gBAAgB;MAC/C;MAC5C;IACF;IACA;IACA;IACA;IACA;IACA,cAAc,EAAE;IAChB,CAAC;;AAGH,SAAO;GACN,YAAY,YAAY;GACxB,KAAK;GACL;GACA"}