{"version":3,"file":"dialect.cjs","names":["entityKind","makeJitQueryMapper","makeJitRqbMapper","makeDefaultQueryMapper","makeDefaultRqbMapper","StringChunk","sql","SQL","Table","Subquery","Column","SQLiteTable","View","ViewBaseConfig","SQLiteViewBase","SQLiteColumn","Param","DrizzleError","TableColumns"],"sources":["../../src/sqlite-core/dialect.ts"],"sourcesContent":["import { aliasedTable, getOriginalColumnFromAlias } from '~/alias.ts';\nimport { Column } from '~/column.ts';\nimport { entityKind, is } from '~/entity.ts';\nimport { DrizzleError } from '~/errors.ts';\nimport type { TypedQueryBuilder } from '~/query-builders/query-builder.ts';\nimport {\n\ttype AnyOne,\n\t// AggregatedField,\n\ttype BuildRelationalQueryResult,\n\ttype ColumnWithTSName,\n\ttype DBQueryConfig,\n\tgetTableAsAliasSQL,\n\tmakeDefaultRqbMapper,\n\tmakeJitRqbMapper,\n\ttype RelationalRowsMapperGenerator,\n\trelationExtrasToSQL,\n\trelationsFilterToSQL,\n\trelationsOrderToSQL,\n\trelationToSQL,\n\ttype TableRelationalConfig,\n\ttype TablesRelationalConfig,\n\ttype WithContainer,\n} from '~/relations.ts';\nimport type { Name, Placeholder, SQLWrapper } from '~/sql/index.ts';\nimport { and, isSQLWrapper } from '~/sql/index.ts';\nimport { Param, type Query, SQL, sql, type SQLChunk, StringChunk, View } from '~/sql/sql.ts';\nimport { SQLiteColumn, type SQLiteCustomColumn } from '~/sqlite-core/columns/index.ts';\nimport type {\n\tAnySQLiteSelectQueryBuilder,\n\tSQLiteDeleteConfig,\n\tSQLiteInsertConfig,\n\tSQLiteUpdateConfig,\n} from '~/sqlite-core/query-builders/index.ts';\nimport { SQLiteTable } from '~/sqlite-core/table.ts';\nimport { Subquery } from '~/subquery.ts';\nimport { getTableName, Table, TableColumns } from '~/table.ts';\nimport {\n\tmakeDefaultQueryMapper,\n\tmakeJitQueryMapper,\n\torderSelectedFields,\n\ttype RowsMapperGenerator,\n\ttype UpdateSet,\n} from '~/utils.ts';\nimport { ViewBaseConfig } from '~/view-common.ts';\nimport type {\n\tSelectedFieldsOrdered,\n\tSQLiteSelectConfig,\n\tSQLiteSelectJoinConfig,\n} from './query-builders/select.types.ts';\nimport { SQLiteViewBase } from './view-base.ts';\nimport type { SQLiteView } from './view.ts';\n\nexport interface SQLiteDialectConfig {\n\tuseJitMappers?: boolean;\n}\n\nexport class SQLiteDialect {\n\tstatic readonly [entityKind]: string = 'SQLiteDialect';\n\n\treadonly mapperGenerators: {\n\t\trows: RowsMapperGenerator;\n\t\trelationalRows: RelationalRowsMapperGenerator;\n\t};\n\n\tconstructor(config?: SQLiteDialectConfig) {\n\t\tthis.mapperGenerators = config?.useJitMappers\n\t\t\t? {\n\t\t\t\trows: makeJitQueryMapper,\n\t\t\t\trelationalRows: makeJitRqbMapper,\n\t\t\t}\n\t\t\t: {\n\t\t\t\trows: makeDefaultQueryMapper,\n\t\t\t\trelationalRows: makeDefaultRqbMapper,\n\t\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 '?';\n\t}\n\n\tescapeString(str: string): string {\n\t\treturn `'${str.replace(/'/g, \"''\")}'`;\n\t}\n\n\tprivate buildWithCTE(queries: Subquery[] | undefined): SQL | undefined {\n\t\tif (!queries?.length) return undefined;\n\n\t\tconst queriesLen = queries.length;\n\t\tconst withSqlChunks: SQLChunk[] = new Array(queriesLen + 1);\n\t\tlet writeIdx = 0;\n\t\twithSqlChunks[writeIdx++] = new StringChunk('with ');\n\n\t\tfor (let i = 0; i < queriesLen; ++i) {\n\t\t\tconst w = queries[i]!;\n\t\t\twithSqlChunks[writeIdx++] = (i < queriesLen - 1)\n\t\t\t\t? sql`${sql.identifier(w._.alias)} as (${w._.sql}), `\n\t\t\t\t: sql`${sql.identifier(w._.alias)} as (${w._.sql}) `;\n\t\t}\n\n\t\treturn new SQL(withSqlChunks);\n\t}\n\n\tbuildDeleteQuery({\n\t\ttable,\n\t\twhere,\n\t\treturning,\n\t\twithList,\n\t\tlimit,\n\t\torderBy,\n\t}: SQLiteDeleteConfig): SQL {\n\t\tconst withSql = this.buildWithCTE(withList);\n\n\t\tconst returningSql = returning\n\t\t\t? sql` returning ${this.buildSelection(returning, { isSingleTable: true, table })}`\n\t\t\t: undefined;\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\tconst orderBySql = this.buildOrderBy(orderBy);\n\n\t\tconst limitSql = this.buildLimit(limit);\n\n\t\treturn sql`${withSql}delete from ${table}${whereSql}${returningSql}${orderBySql}${limitSql}`;\n\t}\n\n\tbuildUpdateSet(table: SQLiteTable, 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}\n\n\tbuildUpdateQuery({\n\t\ttable,\n\t\tset,\n\t\twhere,\n\t\treturning,\n\t\twithList,\n\t\tjoins,\n\t\tfrom,\n\t\tlimit,\n\t\torderBy,\n\t}: SQLiteUpdateConfig): SQL {\n\t\tconst withSql = this.buildWithCTE(withList);\n\n\t\tconst setSql = this.buildUpdateSet(table, set);\n\n\t\tconst fromSql = from && new SQL([new StringChunk(' from '), this.buildFromTable(from)]);\n\n\t\tconst joinsSql = this.buildJoins(joins);\n\n\t\tconst returningSql = returning\n\t\t\t? sql` returning ${this.buildSelection(returning, { isSingleTable: true, table })}`\n\t\t\t: undefined;\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\tconst orderBySql = this.buildOrderBy(orderBy);\n\n\t\tconst limitSql = this.buildLimit(limit);\n\n\t\treturn sql`${withSql}update ${table} set ${setSql}${fromSql}${joinsSql}${whereSql}${returningSql}${orderBySql}${limitSql}`;\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?: SQLiteTable | SQLiteViewBase | 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\t// TODO: remove after implementing codecs\n\t\t\t\t\tif (field.columnType === 'SQLiteNumericBigInt' || field.columnType === 'SQLiteNumeric') {\n\t\t\t\t\t\tif (isSingleTable) {\n\t\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t\t? sql`cast(${sql.identifier(getOriginalColumnFromAlias(field).name)} as text) as ${field}`\n\t\t\t\t\t\t\t\t\t: sql`cast(${sql.identifier(field.name)} as text)`,\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(\n\t\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t\t? sql`cast(${getOriginalColumnFromAlias(field)} as text) as ${field}`\n\t\t\t\t\t\t\t\t\t: sql`cast(${field} as text)`,\n\t\t\t\t\t\t\t);\n\t\t\t\t\t\t}\n\t\t\t\t\t} else {\n\t\t\t\t\t\tif (isSingleTable) {\n\t\t\t\t\t\t\tchunks.push(\n\t\t\t\t\t\t\t\tfield.isAlias\n\t\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\t: sql.identifier(field.name),\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(\n\t\t\t\t\t\t\t\tfield.isAlias\n\t\t\t\t\t\t\t\t\t? sql`${getOriginalColumnFromAlias(field)} as ${field}`\n\t\t\t\t\t\t\t\t\t: field,\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\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 buildJoins(\n\t\tjoins: SQLiteSelectJoinConfig[] | undefined,\n\t): SQL | undefined {\n\t\tif (!joins || joins.length === 0) {\n\t\t\treturn undefined;\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 onSql = joinMeta.on ? sql` on ${joinMeta.on}` : undefined;\n\n\t\t\t\tif (is(table, SQLiteTable)) {\n\t\t\t\t\tconst tableName = table[SQLiteTable.Symbol.Name];\n\t\t\t\t\tconst tableSchema = table[SQLiteTable.Symbol.Schema];\n\t\t\t\t\tconst origTableName = table[SQLiteTable.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`${new StringChunk(joinMeta.joinType)} join ${\n\t\t\t\t\t\t\ttableSchema ? sql`${sql.identifier(tableSchema)}.` : undefined\n\t\t\t\t\t\t}${\n\t\t\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\t\t\torigTableName,\n\t\t\t\t\t\t\t)\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`${new StringChunk(joinMeta.joinType)} join ${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\treturn new SQL(joinsArray);\n\t}\n\n\tprivate buildLimit(limit: number | Placeholder | undefined): SQL | undefined {\n\t\treturn typeof limit === 'object'\n\t\t\t\t|| (typeof limit === 'number' && limit >= 0)\n\t\t\t? sql` limit ${limit}`\n\t\t\t: undefined;\n\t}\n\n\tprivate buildOrderBy(\n\t\torderBy: (SQLiteColumn | SQL | SQL.Aliased)[] | undefined,\n\t): SQL | undefined {\n\t\tconst orderByList: SQLChunk[] = [];\n\n\t\tif (orderBy) {\n\t\t\tfor (const [index, orderByValue] of orderBy.entries()) {\n\t\t\t\torderByList.push(orderByValue);\n\n\t\t\t\tif (index < orderBy.length - 1) {\n\t\t\t\t\torderByList.push(new StringChunk(', '));\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\n\t\treturn orderByList.length > 0\n\t\t\t? sql` order by ${sql.join(orderByList)}`\n\t\t\t: undefined;\n\t}\n\n\tprivate buildFromTable(\n\t\ttable: SQL | Subquery | SQLiteViewBase | SQLiteTable | undefined,\n\t): SQL | Subquery | SQLiteViewBase | SQLiteTable | undefined {\n\t\tif (is(table, Table) && table[Table.Symbol.IsAlias]) {\n\t\t\treturn sql`${sql`${sql.identifier(table[Table.Symbol.Schema] ?? '')}.`.if(table[Table.Symbol.Schema])}${\n\t\t\t\tsql.identifier(\n\t\t\t\t\ttable[Table.Symbol.OriginalName],\n\t\t\t\t)\n\t\t\t} ${sql.identifier(table[Table.Symbol.Name])}`;\n\t\t}\n\n\t\tif (is(table, View) && table[ViewBaseConfig].isAlias) {\n\t\t\tlet fullName = sql`${sql.identifier(table[ViewBaseConfig].originalName)}`;\n\t\t\tif (table[ViewBaseConfig].schema) {\n\t\t\t\tfullName = sql`${sql.identifier(table[ViewBaseConfig].schema)}.${fullName}`;\n\t\t\t}\n\t\t\treturn sql`${fullName} ${sql.identifier(table[ViewBaseConfig].name)}`;\n\t\t}\n\n\t\treturn table;\n\t}\n\n\tbuildSelectQuery({\n\t\twithList,\n\t\tfields,\n\t\tfieldsFlat,\n\t\twhere,\n\t\thaving,\n\t\ttable,\n\t\tjoins,\n\t\torderBy,\n\t\tgroupBy,\n\t\tlimit,\n\t\toffset,\n\t\tdistinct,\n\t\tsetOperators,\n\t}: SQLiteSelectConfig): SQL {\n\t\tconst fieldsList = fieldsFlat ?? orderSelectedFields<SQLiteColumn>(fields);\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, SQLiteViewBase)\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\tconst withSql = this.buildWithCTE(withList);\n\n\t\tconst distinctSql = distinct ? sql` distinct` : undefined;\n\n\t\tconst selection = this.buildSelection(fieldsList, { isSingleTable, table });\n\n\t\tconst tableSql = this.buildFromTable(table);\n\n\t\tconst joinsSql = this.buildJoins(joins);\n\n\t\tconst whereSql = where ? sql` where ${where}` : undefined;\n\n\t\tconst havingSql = having ? sql` having ${having}` : undefined;\n\n\t\tconst groupByList: SQLChunk[] = [];\n\t\tif (groupBy) {\n\t\t\tfor (const [index, groupByValue] of groupBy.entries()) {\n\t\t\t\tgroupByList.push(groupByValue);\n\n\t\t\t\tif (index < groupBy.length - 1) {\n\t\t\t\t\tgroupByList.push(new StringChunk(', '));\n\t\t\t\t}\n\t\t\t}\n\t\t}\n\n\t\tconst groupBySql = groupByList.length > 0\n\t\t\t? sql` group by ${sql.join(groupByList)}`\n\t\t\t: undefined;\n\n\t\tconst orderBySql = this.buildOrderBy(orderBy);\n\n\t\tconst limitSql = this.buildLimit(limit);\n\n\t\tconst offsetSql = offset ? sql` offset ${offset}` : undefined;\n\n\t\tconst finalQuery =\n\t\t\tsql`${withSql}select${distinctSql} ${selection} from ${tableSql}${joinsSql}${whereSql}${groupBySql}${havingSql}${orderBySql}${limitSql}${offsetSql}`;\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: SQLiteSelectConfig['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, limit, orderBy, offset },\n\t}: {\n\t\tleftSelect: SQL;\n\t\tsetOperator: SQLiteSelectConfig['setOperators'][number];\n\t}): SQL {\n\t\t// SQLite doesn't support parenthesis in set operations\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 Sql syntax, Table from one of the SELECTs cannot be used in global ORDER clause\n\t\t\tfor (const singleOrderBy of orderBy) {\n\t\t\t\tif (is(singleOrderBy, SQLiteColumn)) {\n\t\t\t\t\torderByValues.push(sql.identifier(singleOrderBy.name));\n\t\t\t\t} else if (is(singleOrderBy, SQL)) {\n\t\t\t\t\tfor (let i = 0; i < singleOrderBy.queryChunks.length; i++) {\n\t\t\t\t\t\tconst chunk = singleOrderBy.queryChunks[i];\n\n\t\t\t\t\t\tif (is(chunk, SQLiteColumn)) {\n\t\t\t\t\t\t\tsingleOrderBy.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`${singleOrderBy}`);\n\t\t\t\t} else {\n\t\t\t\t\torderByValues.push(sql`${singleOrderBy}`);\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 limitSql = typeof limit === 'object' || (typeof limit === 'number' && limit >= 0)\n\t\t\t? sql` limit ${limit}`\n\t\t\t: undefined;\n\n\t\tconst operatorChunk = new StringChunk(`${type} ${isAll ? 'all ' : ''}`);\n\n\t\tconst offsetSql = offset ? sql` offset ${offset}` : undefined;\n\n\t\treturn sql`${leftChunk}${operatorChunk}${rightChunk}${orderBySql}${limitSql}${offsetSql}`;\n\t}\n\n\tbuildInsertQuery({\n\t\ttable,\n\t\tvalues: valuesOrSelect,\n\t\tonConflict,\n\t\treturning,\n\t\twithList,\n\t\tselect,\n\t\tcolumnList,\n\t}: SQLiteInsertConfig): SQL {\n\t\t// const isSingleValue = values.length === 1;\n\t\tconst columns: Record<string, SQLiteColumn> = table[Table.Symbol.Columns];\n\n\t\tconst colEntries: [string, SQLiteColumn][] = columnList\n\t\t\t? columnList.map((name) => [name, columns[name]!])\n\t\t\t: Object.entries(columns);\n\t\tconst colEntriesFiltered: [string, SQLiteColumn][] = 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, SQLiteColumn])\n\t\t\t: colEntries.filter(([_, col]) => !col.shouldDisableInsert());\n\n\t\tconst insertOrderArr: SQLChunk[] = new Array(colEntriesFiltered.length * 2 + 1);\n\t\tlet writeIdx = 0;\n\t\tinsertOrderArr[writeIdx++] = new StringChunk('(');\n\t\tfor (let i = 0; i < colEntriesFiltered.length; ++i) {\n\t\t\tconst [, { name }] = colEntriesFiltered[i]!;\n\t\t\tinsertOrderArr[writeIdx++] = sql.identifier(name);\n\n\t\t\tif (i < colEntriesFiltered.length - 1) insertOrderArr[writeIdx++] = new StringChunk(', ');\n\t\t}\n\t\tinsertOrderArr[writeIdx++] = new StringChunk(')');\n\t\tconst insertOrder = new SQL(insertOrderArr);\n\n\t\tconst valuesSqlList: SQLChunk[] = Array.from({\n\t\t\tlength: select\n\t\t\t\t? 1\n\t\t\t\t: (colEntriesFiltered.length * 2 + 1) * (valuesOrSelect as Record<string, unknown>[]).length\n\t\t\t\t\t+ (valuesOrSelect as Record<string, unknown>[]).length,\n\t\t});\n\n\t\tif (select) {\n\t\t\tvaluesSqlList[0] = (valuesOrSelect as AnySQLiteSelectQueryBuilder | SQL).getSQL();\n\t\t} else {\n\t\t\tconst values = valuesOrSelect as Record<string, unknown>[];\n\n\t\t\tlet writeIdx = 0;\n\t\t\tvaluesSqlList[writeIdx++] = new StringChunk('values ');\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 < colEntriesFiltered.length; ++i) {\n\t\t\t\t\tconst [fieldName, col] = colEntriesFiltered[i]!;\n\t\t\t\t\tconst colValue = value[fieldName];\n\t\t\t\t\tif (colValue === undefined) {\n\t\t\t\t\t\tlet defaultValue;\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\tdefaultValue = 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\t// eslint-disable-next-line unicorn/no-negated-condition\n\t\t\t\t\t\t} else if (col.default !== null && col.default !== undefined) {\n\t\t\t\t\t\t\tdefaultValue = is(col.default, SQL)\n\t\t\t\t\t\t\t\t? col.default\n\t\t\t\t\t\t\t\t: sql.param(col.default, col);\n\t\t\t\t\t\t\t// eslint-disable-next-line unicorn/no-negated-condition\n\t\t\t\t\t\t} else if (col.onUpdateFn !== undefined) {\n\t\t\t\t\t\t\tconst onUpdateFnResult = col.onUpdateFn();\n\t\t\t\t\t\t\tdefaultValue = 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} else {\n\t\t\t\t\t\t\tdefaultValue = new StringChunk('null');\n\t\t\t\t\t\t}\n\t\t\t\t\t\tvaluesSqlList[writeIdx++] = defaultValue;\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 < colEntriesFiltered.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 withSql = this.buildWithCTE(withList);\n\n\t\tconst valuesSql = new SQL(valuesSqlList);\n\n\t\tconst returningSql = returning\n\t\t\t? sql` returning ${this.buildSelection(returning, { isSingleTable: true, table })}`\n\t\t\t: undefined;\n\n\t\tconst onConflictSql = onConflict?.length ? sql.join(onConflict) : undefined;\n\n\t\t// if (isSingleValue && valuesSqlList.length === 0){\n\t\t// \treturn sql`insert into ${table} default values ${onConflictSql}${returningSql}`;\n\t\t// }\n\n\t\treturn sql`${withSql}insert into ${table} ${insertOrder} ${valuesSql}${onConflictSql}${returningSql}`;\n\t}\n\n\tsqlToQuery(sql: SQL, invokeSource?: 'indexes' | undefined): Query {\n\t\treturn 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}\n\n\tprivate buildRqbColumn(\n\t\ttable: Table | View,\n\t\tfield: unknown,\n\t\tkey: string,\n\t\tinJson: boolean,\n\t\tselection: BuildRelationalQueryResult['selection'],\n\t\ttableTsName: string,\n\t) {\n\t\tlet fieldType: BuildRelationalQueryResult['selection'][number]['fieldType'];\n\t\tlet output: SQL;\n\n\t\tif (is(field, Column)) {\n\t\t\tfieldType = 'Column';\n\t\t\tconst name = sql`${table}.${sql.identifier(field.name)}`;\n\n\t\t\tswitch (field.columnType) {\n\t\t\t\tcase 'SQLiteBigInt':\n\t\t\t\tcase 'SQLiteBlobJson':\n\t\t\t\tcase 'SQLiteBlobBuffer': {\n\t\t\t\t\toutput = !inJson ? sql`${name} as ${sql.identifier(key)}` : sql`hex(${name}) as ${sql.identifier(key)}`;\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\n\t\t\t\tcase 'SQLiteNumeric':\n\t\t\t\tcase 'SQLiteNumericNumber':\n\t\t\t\tcase 'SQLiteNumericBigInt': {\n\t\t\t\t\t// Special case - needs casting in root of query as well for drivers chop it down to number by default\n\t\t\t\t\t// TODO: handle with codecs\n\t\t\t\t\toutput = sql`cast(${name} as text) as ${sql.identifier(key)}`;\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\n\t\t\t\tcase 'SQLiteCustomColumn': {\n\t\t\t\t\toutput = !inJson\n\t\t\t\t\t\t? sql`${name} as ${sql.identifier(key)}`\n\t\t\t\t\t\t: sql`${(<SQLiteCustomColumn<any>> field).jsonSelectIdentifier(name, sql)} as ${sql.identifier(key)}`;\n\t\t\t\t\tbreak;\n\t\t\t\t}\n\n\t\t\t\tdefault: {\n\t\t\t\t\toutput = sql`${name} as ${sql.identifier(key)}`;\n\t\t\t\t}\n\t\t\t}\n\t\t} else if (is(field, SQL)) {\n\t\t\tfieldType = 'SQL';\n\t\t\toutput = sql`${table}.${sql.identifier(key)} as ${sql.identifier(key)}`;\n\t\t} else if (is(field, SQL.Aliased)) {\n\t\t\tfieldType = 'SQL.Aliased';\n\t\t\toutput = sql`${table}.${sql.identifier(field.fieldAlias)} as ${sql.identifier(key)}`;\n\t\t} else if (isSQLWrapper(field)) {\n\t\t\tfieldType = 'SQLWrapper';\n\t\t\toutput = sql`${table}.${sql.identifier(key)} as ${sql.identifier(key)}`;\n\t\t} else {\n\t\t\tthrow new DrizzleError({\n\t\t\t\tmessage: field === undefined\n\t\t\t\t\t? `Unknown column: \"${tableTsName}\".\"${key}\"`\n\t\t\t\t\t: `Views with nested selections are not supported by the relational query builder`,\n\t\t\t});\n\t\t}\n\n\t\tselection.push({ key, field, fieldType } as BuildRelationalQueryResult['selection'][number]);\n\n\t\treturn output;\n\t}\n\n\tprivate getSelectedTableColumns = (\n\t\ttable: Table | View,\n\t\tcolumns: Record<string, boolean | undefined>,\n\t) => {\n\t\tconst selectedColumns: ColumnWithTSName[] = [];\n\t\tconst columnContainer = table[TableColumns];\n\t\tconst entries = Object.entries(columns);\n\n\t\tlet colSelectionMode: boolean | undefined;\n\t\tfor (const [k, v] of entries) {\n\t\t\tif (v === undefined) continue;\n\t\t\tcolSelectionMode = colSelectionMode || v;\n\n\t\t\tif (v) {\n\t\t\t\tconst column = columnContainer[k]!;\n\n\t\t\t\tselectedColumns.push({\n\t\t\t\t\tcolumn: column as Column | SQL | SQLWrapper | SQL.Aliased,\n\t\t\t\t\ttsName: k,\n\t\t\t\t});\n\t\t\t}\n\t\t}\n\n\t\tif (colSelectionMode === false) {\n\t\t\tfor (const [k, v] of Object.entries(columnContainer)) {\n\t\t\t\tif (columns[k] === false) continue;\n\n\t\t\t\tselectedColumns.push({\n\t\t\t\t\tcolumn: v as Column | SQL | SQLWrapper | SQL.Aliased | Table,\n\t\t\t\t\ttsName: k,\n\t\t\t\t});\n\t\t\t}\n\t\t}\n\n\t\treturn selectedColumns;\n\t};\n\n\tprivate buildColumns = (\n\t\ttable: SQLiteTable | SQLiteView,\n\t\tselection: BuildRelationalQueryResult['selection'],\n\t\tinJson: boolean,\n\t\ttableTsName: string,\n\t\tconfig?: DBQueryConfig<'many'>,\n\t) => {\n\t\tif (!config?.columns) {\n\t\t\treturn sql.join(\n\t\t\t\tObject.entries(table[TableColumns]).map(([k, v]) => {\n\t\t\t\t\treturn this.buildRqbColumn(table, v, k, inJson, selection, tableTsName);\n\t\t\t\t}),\n\t\t\t\tnew StringChunk(', '),\n\t\t\t);\n\t\t}\n\n\t\tconst columnIdentifiers: SQL[] = [];\n\n\t\tconst selectedColumns = this.getSelectedTableColumns(\n\t\t\ttable,\n\t\t\tconfig?.columns,\n\t\t);\n\n\t\tfor (const { column, tsName } of selectedColumns) {\n\t\t\tcolumnIdentifiers.push(this.buildRqbColumn(table, column, tsName, inJson, selection, tableTsName));\n\t\t}\n\n\t\treturn columnIdentifiers.length\n\t\t\t? sql.join(columnIdentifiers, new StringChunk(', '))\n\t\t\t: undefined;\n\t};\n\n\tbuildRelationalQuery({\n\t\tschema,\n\t\ttable,\n\t\ttableConfig,\n\t\tqueryConfig: config,\n\t\trelationWhere,\n\t\tmode,\n\t\tisNested,\n\t\terrorPath,\n\t\tdepth,\n\t\tthroughJoin,\n\t\tjsonb,\n\t}: {\n\t\tschema: TablesRelationalConfig;\n\t\ttable: SQLiteTable | SQLiteView;\n\t\ttableConfig: TableRelationalConfig;\n\t\tqueryConfig?: DBQueryConfig<'many'> | true;\n\t\trelationWhere?: SQL;\n\t\tmode: 'first' | 'many';\n\t\tisNested?: boolean;\n\t\terrorPath?: string;\n\t\tdepth?: number;\n\t\tthroughJoin?: SQL;\n\t\tjsonb: SQL;\n\t}): BuildRelationalQueryResult {\n\t\tconst selection: BuildRelationalQueryResult['selection'] = [];\n\t\tconst isSingle = mode === 'first';\n\t\tconst params = config === true ? undefined : config;\n\t\tconst currentPath = errorPath ?? '';\n\t\tconst currentDepth = depth ?? 0;\n\t\tif (!currentDepth) table = aliasedTable(table, `d${currentDepth}`);\n\n\t\tconst limit = isSingle ? 1 : params?.limit;\n\t\tconst offset = params?.offset;\n\n\t\tconst columns = this.buildColumns(table, selection, !!isNested, tableConfig.name, params);\n\n\t\tconst where: SQL | undefined = params && 'where' in params && relationWhere\n\t\t\t? and(\n\t\t\t\trelationsFilterToSQL(\n\t\t\t\t\ttable,\n\t\t\t\t\tparams.where,\n\t\t\t\t\ttableConfig.relations,\n\t\t\t\t\tschema,\n\t\t\t\t),\n\t\t\t\trelationWhere,\n\t\t\t)\n\t\t\t: params && 'where' in params\n\t\t\t? relationsFilterToSQL(\n\t\t\t\ttable,\n\t\t\t\tparams.where,\n\t\t\t\ttableConfig.relations,\n\t\t\t\tschema,\n\t\t\t)\n\t\t\t: relationWhere;\n\t\tconst order = params?.orderBy\n\t\t\t? relationsOrderToSQL(table, params.orderBy)\n\t\t\t: undefined;\n\t\tconst extras = params?.extras\n\t\t\t? relationExtrasToSQL(table, params.extras)\n\t\t\t: undefined;\n\t\tif (extras) selection.push(...extras.selection);\n\n\t\tlet joins: SQL | undefined;\n\t\tswitch (params) {\n\t\t\tcase undefined:\n\t\t\t\tbreak;\n\t\t\tdefault: {\n\t\t\t\tconst { with: withParam } = params as WithContainer;\n\t\t\t\tif (!withParam) break;\n\n\t\t\t\tconst withEntries = Object.entries(withParam).filter(([_, v]) => v);\n\t\t\t\tif (!withEntries.length) break;\n\n\t\t\t\tconst joinChunks: SQLChunk[] = new Array(withEntries.length * 2 - 1);\n\t\t\t\tfor (let readIdx = 0, writeIdx = 0; readIdx < withEntries.length; ++readIdx) {\n\t\t\t\t\tconst [k, join] = withEntries[readIdx]!;\n\n\t\t\t\t\tconst relation = tableConfig.relations[k];\n\t\t\t\t\tif (!relation) throw new DrizzleError({ message: `Unknown relation \"${tableConfig.name}\" -> \"${k}\"` });\n\t\t\t\t\tconst isSingle = relation.relationType === 'one';\n\t\t\t\t\tconst targetTable = aliasedTable(\n\t\t\t\t\t\trelation.targetTable,\n\t\t\t\t\t\t`d${currentDepth + 1}`,\n\t\t\t\t\t);\n\t\t\t\t\tconst throughTable = relation.throughTable\n\t\t\t\t\t\t? aliasedTable(relation.throughTable, `tr${currentDepth}`)\n\t\t\t\t\t\t: undefined;\n\t\t\t\t\tconst { filter, joinCondition } = relationToSQL(\n\t\t\t\t\t\trelation,\n\t\t\t\t\t\ttable,\n\t\t\t\t\t\ttargetTable,\n\t\t\t\t\t\tthroughTable,\n\t\t\t\t\t);\n\n\t\t\t\t\tconst throughJoin = throughTable\n\t\t\t\t\t\t? sql` inner join ${getTableAsAliasSQL(throughTable)} on ${joinCondition!}`\n\t\t\t\t\t\t: undefined;\n\n\t\t\t\t\tconst innerQuery = this.buildRelationalQuery({\n\t\t\t\t\t\ttable: targetTable as SQLiteTable | SQLiteView,\n\t\t\t\t\t\tmode: isSingle ? 'first' : 'many',\n\t\t\t\t\t\tschema,\n\t\t\t\t\t\tqueryConfig: join as DBQueryConfig,\n\t\t\t\t\t\ttableConfig: schema[relation.targetTableName]!,\n\t\t\t\t\t\trelationWhere: filter,\n\t\t\t\t\t\tisNested: true,\n\t\t\t\t\t\terrorPath: `${currentPath.length ? `${currentPath}.` : ''}${k}`,\n\t\t\t\t\t\tdepth: currentDepth + 1,\n\t\t\t\t\t\tthroughJoin,\n\t\t\t\t\t\tjsonb,\n\t\t\t\t\t});\n\n\t\t\t\t\tselection.push({\n\t\t\t\t\t\tfield: targetTable,\n\t\t\t\t\t\tfieldType: 'Nested',\n\t\t\t\t\t\tkey: k,\n\t\t\t\t\t\tselection: innerQuery.selection,\n\t\t\t\t\t\tisArray: !isSingle,\n\t\t\t\t\t\tisOptional: ((relation as AnyOne).optional ?? false)\n\t\t\t\t\t\t\t|| (join !== true\n\t\t\t\t\t\t\t\t&& !!(join as Exclude<typeof join, boolean | undefined>)\n\t\t\t\t\t\t\t\t\t.where),\n\t\t\t\t\t});\n\n\t\t\t\t\tconst jsonColumns = sql.join(\n\t\t\t\t\t\tinnerQuery.selection.map((s) => {\n\t\t\t\t\t\t\treturn sql`${new StringChunk(this.escapeString(s.key))}, ${\n\t\t\t\t\t\t\t\ts.selection\n\t\t\t\t\t\t\t\t\t? sql`${jsonb}(${sql.identifier(s.key)})`\n\t\t\t\t\t\t\t\t\t: sql.identifier(s.key)\n\t\t\t\t\t\t\t}`;\n\t\t\t\t\t\t}),\n\t\t\t\t\t\tnew StringChunk(', '),\n\t\t\t\t\t);\n\n\t\t\t\t\tconst json = isNested ? jsonb : sql`json`;\n\n\t\t\t\t\tconst joinQuery = isSingle\n\t\t\t\t\t\t? sql`(select ${json}_object(${jsonColumns}) as ${sql.identifier('r')} from (${innerQuery.sql}) as ${\n\t\t\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\t\t\t't',\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t}) as ${sql.identifier(k)}`\n\t\t\t\t\t\t: sql`coalesce((select ${json}_group_array(json_object(${jsonColumns})) as ${\n\t\t\t\t\t\t\tsql.identifier(\n\t\t\t\t\t\t\t\t'r',\n\t\t\t\t\t\t\t)\n\t\t\t\t\t\t} from (${innerQuery.sql}) as ${sql.identifier('t')}), ${jsonb}_array()) as ${sql.identifier(k)}`;\n\n\t\t\t\t\tjoinChunks[writeIdx++] = joinQuery;\n\t\t\t\t\tif (readIdx < withEntries.length - 1) joinChunks[writeIdx++] = new StringChunk(', ');\n\t\t\t\t}\n\n\t\t\t\tjoins = new SQL(joinChunks);\n\n\t\t\t\tbreak;\n\t\t\t}\n\t\t}\n\n\t\tconst selectionArr = [columns, extras?.sql, joins].filter(\n\t\t\t(e) => e !== undefined,\n\t\t);\n\t\tif (!selectionArr.length) {\n\t\t\tthrow new DrizzleError({\n\t\t\t\tmessage: `No fields selected for table \"${tableConfig.name}\"${currentPath ? ` (\"${currentPath}\")` : ''}`,\n\t\t\t});\n\t\t}\n\t\tconst selectionSet = sql.join(selectionArr, new StringChunk(', '));\n\n\t\tconst query = sql`select ${selectionSet} from ${getTableAsAliasSQL(table)}${throughJoin}${\n\t\t\tsql` where ${where}`.if(\n\t\t\t\twhere,\n\t\t\t)\n\t\t}${sql` order by ${order}`.if(order)}${sql` limit ${limit}`.if(limit !== undefined)}${\n\t\t\tsql` offset ${offset}`.if(\n\t\t\t\toffset !== undefined,\n\t\t\t)\n\t\t}`;\n\n\t\treturn {\n\t\t\tsql: query,\n\t\t\tselection,\n\t\t};\n\t}\n}\n"],"mappings":";;;;;;;;;;;;;;;;;;AAwDA,IAAa,gBAAb,MAA2B;CAC1B,QAAiBA,0BAAsB;CAEvC,AAAS;CAKT,YAAY,QAA8B;AACzC,OAAK,mBAAmB,QAAQ,gBAC7B;GACD,MAAMC;GACN,gBAAgBC;GAChB,GACC;GACD,MAAMC;GACN,gBAAgBC;GAChB;;CAGH,WAAW,MAAsB;AAChC,SAAO,IAAI,KAAK,QAAQ,MAAM,OAAK,CAAC;;CAGrC,YAAY,MAAsB;AACjC,SAAO;;CAGR,aAAa,KAAqB;AACjC,SAAO,IAAI,IAAI,QAAQ,MAAM,KAAK,CAAC;;CAGpC,AAAQ,aAAa,SAAkD;AACtE,MAAI,CAAC,SAAS,OAAQ,QAAO;EAE7B,MAAM,aAAa,QAAQ;EAC3B,MAAM,gBAA4B,IAAI,MAAM,aAAa,EAAE;EAC3D,IAAI,WAAW;AACf,gBAAc,cAAc,IAAIC,yBAAY,QAAQ;AAEpD,OAAK,IAAI,IAAI,GAAG,IAAI,YAAY,EAAE,GAAG;GACpC,MAAM,IAAI,QAAQ;AAClB,iBAAc,cAAe,IAAI,aAAa,IAC3C,gBAAG,GAAGC,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,SAAO,IAAIC,iBAAI,cAAc;;CAG9B,iBAAiB,EAChB,OACA,OACA,WACA,UACA,OACA,WAC2B;EAC3B,MAAM,UAAU,KAAK,aAAa,SAAS;EAE3C,MAAM,eAAe,YAClB,gBAAG,cAAc,KAAK,eAAe,WAAW;GAAE,eAAe;GAAM;GAAO,CAAC,KAC/E;AAQH,SAAO,gBAAG,GAAG,QAAQ,cAAc,QANlB,QAAQ,gBAAG,UAAU,UAAU,SAMM,eAJnC,KAAK,aAAa,QAAQ,GAE5B,KAAK,WAAW,MAAM;;CAKxC,eAAe,OAAoB,KAAqB;EACvD,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,WAAWD,iBAAI,GAAG,YAAYD,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,IAAIC,iBAAI,OAAO;;CAGvB,iBAAiB,EAChB,OACA,KACA,OACA,WACA,UACA,OACA,MACA,OACA,WAC2B;EAC3B,MAAM,UAAU,KAAK,aAAa,SAAS;EAE3C,MAAM,SAAS,KAAK,eAAe,OAAO,IAAI;EAE9C,MAAM,UAAU,QAAQ,IAAIA,iBAAI,CAAC,IAAIF,yBAAY,SAAS,EAAE,KAAK,eAAe,KAAK,CAAC,CAAC;EAEvF,MAAM,WAAW,KAAK,WAAW,MAAM;EAEvC,MAAM,eAAe,YAClB,gBAAG,cAAc,KAAK,eAAe,WAAW;GAAE,eAAe;GAAM;GAAO,CAAC,KAC/E;AAQH,SAAO,gBAAG,GAAG,QAAQ,SAAS,MAAM,OAAO,SAAS,UAAU,WAN7C,QAAQ,gBAAG,UAAU,UAAU,SAMoC,eAJjE,KAAK,aAAa,QAAQ,GAE5B,KAAK,WAAW,MAAM;;;;;;;;;;;;;CAgBxC,AAAQ,eACP,QACA,EAAE,gBAAgB,OAAO,UAGrB,EAAE,EACA;EACN,MAAM,EAAE,QAAQ,eAAe;EAC/B,MAAM,SAAqB,EAAE;EAC7B,MAAM,YAAY,4BACZ,OAAOE,iBAAI,wBAAO,OAAOE,uBAAS,GACpC,SACC,MAAMD,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;AAEJ,SAAI,MAAM,eAAe,yBAAyB,MAAM,eAAe,gBACtE,KAAI,cACH,QAAO,KACN,MAAM,UACH,gBAAG,QAAQF,iBAAI,sDAAsC,MAAM,CAAC,KAAK,CAAC,eAAe,UACjF,gBAAG,QAAQA,iBAAI,WAAW,MAAM,KAAK,CAAC,WACzC;SAED,QAAO,KACN,MAAM,UACH,gBAAG,mDAAmC,MAAM,CAAC,eAAe,UAC5D,gBAAG,QAAQ,MAAM,WACpB;cAGE,cACH,QAAO,KACN,MAAM,UACH,gBAAG,GAAGA,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;AAIH;IAED,KAAK;AACJ,SAAI,MAAM,kBAAkB;AAC3B,UAAI,CAAC,iBAAiB,MAAM,WAAW,OACtC,QAAO,KAAKA,iBAAI,WAAW,MAAM,OAAO,EAAE,IAAID,yBAAY,IAAI,CAAC;AAEhE,aAAO,KAAKC,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,GAAGI,mBAAO,EAAE;SAClB,MAAM,EAAE,UAAU;AAIlB,cAHwB,MAAMF,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,KAAKF,iBAAI,WAAW,EAAE,KAAK;cAErC,WAAU,KAAK;;AAIjB,WAAI,MACH,QAAO,KAAK,MAAM,IAAI;YAChB;QACN,MAAM,SAAS,IAAIC,iBAAI,UAAU;AACjC,YAAI,MAAM,IAAI,mBAAoB,QAAO,cAAc;AACvD,eAAO,KAAK,OAAO;;YAGpB,QAAO,KAAK,MAAM,IAAI;AAGvB,aAAO,KAAK,gBAAG,OAAOD,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,GAAGI,mBAAO,EAAE;QAClB,MAAM,EAAE,UAAU;AAIlB,aAHwB,MAAMF,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,KAAKF,iBAAI,WAAW,EAAE,KAAK;aAErC,WAAU,KAAK;;AAIjB,UAAI,MACH,QAAO,KAAK,MAAM;WACZ;OACN,MAAM,SAAS,IAAIC,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,IAAID,iBAAI,WAAW,MAAM,EAAE,MAAM,GAAG;SAEnE,QAAO,KAAK,MAAM;AAGnB;;AAIF,OAAI,IAAI,aAAa,EACpB,QAAO,KAAK,IAAID,yBAAY,KAAK,CAAC;;AAIpC,SAAO,IAAIE,iBAAI,OAAO;;CAGvB,AAAQ,WACP,OACkB;AAClB,MAAI,CAAC,SAAS,MAAM,WAAW,EAC9B;EAGD,MAAM,aAAyB,EAAE;AAEjC,MAAI,MACH,MAAK,MAAM,CAAC,OAAO,aAAa,MAAM,SAAS,EAAE;AAChD,OAAI,UAAU,EACb,YAAW,KAAK,IAAIF,yBAAY,IAAI,CAAC;GAEtC,MAAM,QAAQ,SAAS;GACvB,MAAM,QAAQ,SAAS,KAAK,gBAAG,OAAO,SAAS,OAAO;AAEtD,2BAAO,OAAOM,mCAAY,EAAE;IAC3B,MAAM,YAAY,MAAMA,mCAAY,OAAO;IAC3C,MAAM,cAAc,MAAMA,mCAAY,OAAO;IAC7C,MAAM,gBAAgB,MAAMA,mCAAY,OAAO;IAC/C,MAAM,QAAQ,cAAc,gBAAgB,SAAY,SAAS;AACjE,eAAW,KACV,gBAAG,GAAG,IAAIN,yBAAY,SAAS,SAAS,CAAC,QACxC,cAAc,gBAAG,GAAGC,iBAAI,WAAW,YAAY,CAAC,KAAK,SAErDA,iBAAI,WACH,cACA,GACC,SAAS,gBAAG,IAAIA,iBAAI,WAAW,MAAM,KAAK,QAC7C;SAED,YAAW,KACV,gBAAG,GAAG,IAAID,yBAAY,SAAS,SAAS,CAAC,QAAQ,QAAQ,QACzD;AAEF,OAAI,QAAQ,MAAM,SAAS,EAC1B,YAAW,KAAK,IAAIA,yBAAY,IAAI,CAAC;;AAKxC,SAAO,IAAIE,iBAAI,WAAW;;CAG3B,AAAQ,WAAW,OAA0D;AAC5E,SAAO,OAAO,UAAU,YAClB,OAAO,UAAU,YAAY,SAAS,IACzC,gBAAG,UAAU,UACb;;CAGJ,AAAQ,aACP,SACkB;EAClB,MAAM,cAA0B,EAAE;AAElC,MAAI,QACH,MAAK,MAAM,CAAC,OAAO,iBAAiB,QAAQ,SAAS,EAAE;AACtD,eAAY,KAAK,aAAa;AAE9B,OAAI,QAAQ,QAAQ,SAAS,EAC5B,aAAY,KAAK,IAAIF,yBAAY,KAAK,CAAC;;AAK1C,SAAO,YAAY,SAAS,IACzB,gBAAG,aAAaC,iBAAI,KAAK,YAAY,KACrC;;CAGJ,AAAQ,eACP,OAC4D;AAC5D,0BAAO,OAAOE,iBAAM,IAAI,MAAMA,iBAAM,OAAO,SAC1C,QAAO,gBAAG,GAAG,gBAAG,GAAGF,iBAAI,WAAW,MAAME,iBAAM,OAAO,WAAW,GAAG,CAAC,GAAG,GAAG,MAAMA,iBAAM,OAAO,QAAQ,GACpGF,iBAAI,WACH,MAAME,iBAAM,OAAO,cACnB,CACD,GAAGF,iBAAI,WAAW,MAAME,iBAAM,OAAO,MAAM;AAG7C,0BAAO,OAAOI,kBAAK,IAAI,MAAMC,iCAAgB,SAAS;GACrD,IAAI,WAAW,gBAAG,GAAGP,iBAAI,WAAW,MAAMO,iCAAgB,aAAa;AACvE,OAAI,MAAMA,iCAAgB,OACzB,YAAW,gBAAG,GAAGP,iBAAI,WAAW,MAAMO,iCAAgB,OAAO,CAAC,GAAG;AAElE,UAAO,gBAAG,GAAG,SAAS,GAAGP,iBAAI,WAAW,MAAMO,iCAAgB,KAAK;;AAGpE,SAAO;;CAGR,iBAAiB,EAChB,UACA,QACA,YACA,OACA,QACA,OACA,OACA,SACA,SACA,OACA,QACA,UACA,gBAC2B;EAC3B,MAAM,aAAa,kDAAgD,OAAO;AAC1E,OAAK,MAAM,KAAK,WACf,yBACI,EAAE,OAAOH,mBAAO,iCACH,EAAE,MAAM,MAAM,0BACrB,OAAOD,uBAAS,GACrB,MAAM,EAAE,4BACL,OAAOK,6CAAe,GACzB,MAAMD,iCAAgB,2BACnB,OAAON,iBAAI,GACd,sCACa,MAAM,KACpB,GAAG,UACL,OAAO,MACL,EAAE,YACF,WACM,MAAMC,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,MAAM,UAAU,KAAK,aAAa,SAAS;EAE3C,MAAM,cAAc,WAAW,gBAAG,cAAc;EAEhD,MAAM,YAAY,KAAK,eAAe,YAAY;GAAE;GAAe;GAAO,CAAC;EAE3E,MAAM,WAAW,KAAK,eAAe,MAAM;EAE3C,MAAM,WAAW,KAAK,WAAW,MAAM;EAEvC,MAAM,WAAW,QAAQ,gBAAG,UAAU,UAAU;EAEhD,MAAM,YAAY,SAAS,gBAAG,WAAW,WAAW;EAEpD,MAAM,cAA0B,EAAE;AAClC,MAAI,QACH,MAAK,MAAM,CAAC,OAAO,iBAAiB,QAAQ,SAAS,EAAE;AACtD,eAAY,KAAK,aAAa;AAE9B,OAAI,QAAQ,QAAQ,SAAS,EAC5B,aAAY,KAAK,IAAIH,yBAAY,KAAK,CAAC;;EAe1C,MAAM,aACL,gBAAG,GAAG,QAAQ,QAAQ,YAAY,GAAG,UAAU,QAAQ,WAAW,WAAW,WAX3D,YAAY,SAAS,IACrC,gBAAG,aAAaC,iBAAI,KAAK,YAAY,KACrC,SASmG,YAPnF,KAAK,aAAa,QAAQ,GAE5B,KAAK,WAAW,MAAM,GAErB,SAAS,gBAAG,WAAW,WAAW;AAKpD,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;EAEP,MAAM,YAAY,gBAAG,GAAG,WAAW,QAAQ,CAAC;EAC5C,MAAM,aAAa,gBAAG,GAAG,YAAY,QAAQ;EAE7C,IAAI;AACJ,MAAI,WAAW,QAAQ,SAAS,GAAG;GAClC,MAAM,gBAAyC,EAAE;AAIjD,QAAK,MAAM,iBAAiB,QAC3B,yBAAO,eAAeS,4CAAa,CAClC,eAAc,KAAKT,iBAAI,WAAW,cAAc,KAAK,CAAC;gCACzC,eAAeC,iBAAI,EAAE;AAClC,SAAK,IAAI,IAAI,GAAG,IAAI,cAAc,YAAY,QAAQ,KAAK;KAC1D,MAAM,QAAQ,cAAc,YAAY;AAExC,6BAAO,OAAOQ,4CAAa,CAC1B,eAAc,YAAY,KAAKT,iBAAI,WAAW,MAAM,KAAK;;AAI3D,kBAAc,KAAK,gBAAG,GAAG,gBAAgB;SAEzC,eAAc,KAAK,gBAAG,GAAG,gBAAgB;AAI3C,gBAAa,gBAAG,aAAaA,iBAAI,KAAK,eAAe,IAAID,yBAAY,KAAK,CAAC;;EAG5E,MAAM,WAAW,OAAO,UAAU,YAAa,OAAO,UAAU,YAAY,SAAS,IAClF,gBAAG,UAAU,UACb;EAEH,MAAM,gBAAgB,IAAIA,yBAAY,GAAG,KAAK,GAAG,QAAQ,SAAS,KAAK;EAEvE,MAAM,YAAY,SAAS,gBAAG,WAAW,WAAW;AAEpD,SAAO,gBAAG,GAAG,YAAY,gBAAgB,aAAa,aAAa,WAAW;;CAG/E,iBAAiB,EAChB,OACA,QAAQ,gBACR,YACA,WACA,UACA,QACA,cAC2B;EAE3B,MAAM,UAAwC,MAAMG,iBAAM,OAAO;EAEjE,MAAM,aAAuC,aAC1C,WAAW,KAAK,SAAS,CAAC,MAAM,QAAQ,MAAO,CAAC,GAChD,OAAO,QAAQ,QAAQ;EAC1B,MAAM,qBAA+C,UAAU,qBAAI,gBAAgBD,iBAAI,GACpF,OACA,KAAM,eAA0C,mBAAmB,CAAC,CACpE,KAAK,QAAQ,CAAC,KAAK,QAAQ,KAAK,CAA2B,GAC3D,WAAW,QAAQ,CAAC,GAAG,SAAS,CAAC,IAAI,qBAAqB,CAAC;EAE9D,MAAM,iBAA6B,IAAI,MAAM,mBAAmB,SAAS,IAAI,EAAE;EAC/E,IAAI,WAAW;AACf,iBAAe,cAAc,IAAIF,yBAAY,IAAI;AACjD,OAAK,IAAI,IAAI,GAAG,IAAI,mBAAmB,QAAQ,EAAE,GAAG;GACnD,MAAM,GAAG,EAAE,UAAU,mBAAmB;AACxC,kBAAe,cAAcC,iBAAI,WAAW,KAAK;AAEjD,OAAI,IAAI,mBAAmB,SAAS,EAAG,gBAAe,cAAc,IAAID,yBAAY,KAAK;;AAE1F,iBAAe,cAAc,IAAIA,yBAAY,IAAI;EACjD,MAAM,cAAc,IAAIE,iBAAI,eAAe;EAE3C,MAAM,gBAA4B,MAAM,KAAK,EAC5C,QAAQ,SACL,KACC,mBAAmB,SAAS,IAAI,KAAM,eAA6C,SAClF,eAA6C,QAClD,CAAC;AAEF,MAAI,OACH,eAAc,KAAM,eAAqD,QAAQ;OAC3E;GACN,MAAM,SAAS;GAEf,IAAI,WAAW;AACf,iBAAc,cAAc,IAAIF,yBAAY,UAAU;AAEtD,QAAK,IAAI,aAAa,GAAG,aAAa,OAAO,QAAQ,EAAE,YAAY;IAClE,MAAM,QAAQ,OAAO;AAErB,kBAAc,cAAc,IAAIA,yBAAY,IAAI;AAChD,SAAK,IAAI,IAAI,GAAG,IAAI,mBAAmB,QAAQ,EAAE,GAAG;KACnD,MAAM,CAAC,WAAW,OAAO,mBAAmB;KAC5C,MAAM,WAAW,MAAM;AACvB,SAAI,aAAa,QAAW;MAC3B,IAAI;AACJ,UAAI,IAAI,cAAc,QAAW;OAChC,MAAM,kBAAkB,IAAI,WAAW;AACvC,0CAAkB,iBAAiBE,iBAAI,GACpC,kBACAD,iBAAI,MAAM,iBAAiB,IAAI;iBAExB,IAAI,YAAY,QAAQ,IAAI,YAAY,OAClD,oCAAkB,IAAI,SAASC,iBAAI,GAChC,IAAI,UACJD,iBAAI,MAAM,IAAI,SAAS,IAAI;eAEpB,IAAI,eAAe,QAAW;OACxC,MAAM,mBAAmB,IAAI,YAAY;AACzC,0CAAkB,kBAAkBC,iBAAI,GACrC,mBACAD,iBAAI,MAAM,kBAAkB,IAAI;YAEnC,gBAAe,IAAID,yBAAY,OAAO;AAEvC,oBAAc,cAAc;WAE5B,eAAc,kCAAiB,UAAUE,iBAAI,GAAG,WAAW,IAAIS,mBAAM,UAAU,IAAI;AAGpF,SAAI,IAAI,mBAAmB,SAAS,EACnC,eAAc,cAAc,IAAIX,yBAAY,KAAK;;AAInD,kBAAc,cAAc,IAAIA,yBAAY,IAAI;AAEhD,QAAI,aAAa,OAAO,SAAS,EAChC,eAAc,cAAc,IAAIA,yBAAY,KAAK;;;EAKpD,MAAM,UAAU,KAAK,aAAa,SAAS;EAE3C,MAAM,YAAY,IAAIE,iBAAI,cAAc;EAExC,MAAM,eAAe,YAClB,gBAAG,cAAc,KAAK,eAAe,WAAW;GAAE,eAAe;GAAM;GAAO,CAAC,KAC/E;AAQH,SAAO,gBAAG,GAAG,QAAQ,cAAc,MAAM,GAAG,YAAY,GAAG,YANrC,YAAY,SAASD,iBAAI,KAAK,WAAW,GAAG,SAMqB;;CAGxF,WAAW,KAAU,cAA6C;AACjE,SAAO,IAAI,QAAQ;GAClB,YAAY,KAAK;GACjB,aAAa,KAAK;GAClB,cAAc,KAAK;GACnB;GACA,CAAC;;CAGH,AAAQ,eACP,OACA,OACA,KACA,QACA,WACA,aACC;EACD,IAAI;EACJ,IAAI;AAEJ,0BAAO,OAAOI,mBAAO,EAAE;AACtB,eAAY;GACZ,MAAM,OAAO,gBAAG,GAAG,MAAM,GAAGJ,iBAAI,WAAW,MAAM,KAAK;AAEtD,WAAQ,MAAM,YAAd;IACC,KAAK;IACL,KAAK;IACL,KAAK;AACJ,cAAS,CAAC,SAAS,gBAAG,GAAG,KAAK,MAAMA,iBAAI,WAAW,IAAI,KAAK,gBAAG,OAAO,KAAK,OAAOA,iBAAI,WAAW,IAAI;AACrG;IAGD,KAAK;IACL,KAAK;IACL,KAAK;AAGJ,cAAS,gBAAG,QAAQ,KAAK,eAAeA,iBAAI,WAAW,IAAI;AAC3D;IAGD,KAAK;AACJ,cAAS,CAAC,SACP,gBAAG,GAAG,KAAK,MAAMA,iBAAI,WAAW,IAAI,KACpC,gBAAG,GAA8B,MAAO,qBAAqB,MAAMA,iBAAI,CAAC,MAAMA,iBAAI,WAAW,IAAI;AACpG;IAGD,QACC,UAAS,gBAAG,GAAG,KAAK,MAAMA,iBAAI,WAAW,IAAI;;iCAGlC,OAAOC,iBAAI,EAAE;AAC1B,eAAY;AACZ,YAAS,gBAAG,GAAG,MAAM,GAAGD,iBAAI,WAAW,IAAI,CAAC,MAAMA,iBAAI,WAAW,IAAI;iCACxD,OAAOC,iBAAI,QAAQ,EAAE;AAClC,eAAY;AACZ,YAAS,gBAAG,GAAG,MAAM,GAAGD,iBAAI,WAAW,MAAM,WAAW,CAAC,MAAMA,iBAAI,WAAW,IAAI;8CAC3D,MAAM,EAAE;AAC/B,eAAY;AACZ,YAAS,gBAAG,GAAG,MAAM,GAAGA,iBAAI,WAAW,IAAI,CAAC,MAAMA,iBAAI,WAAW,IAAI;QAErE,OAAM,IAAIW,yBAAa,EACtB,SAAS,UAAU,SAChB,oBAAoB,YAAY,KAAK,IAAI,KACzC,kFACH,CAAC;AAGH,YAAU,KAAK;GAAE;GAAK;GAAO;GAAW,CAAoD;AAE5F,SAAO;;CAGR,AAAQ,2BACP,OACA,YACI;EACJ,MAAM,kBAAsC,EAAE;EAC9C,MAAM,kBAAkB,MAAMC;EAC9B,MAAM,UAAU,OAAO,QAAQ,QAAQ;EAEvC,IAAI;AACJ,OAAK,MAAM,CAAC,GAAG,MAAM,SAAS;AAC7B,OAAI,MAAM,OAAW;AACrB,sBAAmB,oBAAoB;AAEvC,OAAI,GAAG;IACN,MAAM,SAAS,gBAAgB;AAE/B,oBAAgB,KAAK;KACZ;KACR,QAAQ;KACR,CAAC;;;AAIJ,MAAI,qBAAqB,MACxB,MAAK,MAAM,CAAC,GAAG,MAAM,OAAO,QAAQ,gBAAgB,EAAE;AACrD,OAAI,QAAQ,OAAO,MAAO;AAE1B,mBAAgB,KAAK;IACpB,QAAQ;IACR,QAAQ;IACR,CAAC;;AAIJ,SAAO;;CAGR,AAAQ,gBACP,OACA,WACA,QACA,aACA,WACI;AACJ,MAAI,CAAC,QAAQ,QACZ,QAAOZ,iBAAI,KACV,OAAO,QAAQ,MAAMY,yBAAc,CAAC,KAAK,CAAC,GAAG,OAAO;AACnD,UAAO,KAAK,eAAe,OAAO,GAAG,GAAG,QAAQ,WAAW,YAAY;IACtE,EACF,IAAIb,yBAAY,KAAK,CACrB;EAGF,MAAM,oBAA2B,EAAE;EAEnC,MAAM,kBAAkB,KAAK,wBAC5B,OACA,QAAQ,QACR;AAED,OAAK,MAAM,EAAE,QAAQ,YAAY,gBAChC,mBAAkB,KAAK,KAAK,eAAe,OAAO,QAAQ,QAAQ,QAAQ,WAAW,YAAY,CAAC;AAGnG,SAAO,kBAAkB,SACtBC,iBAAI,KAAK,mBAAmB,IAAID,yBAAY,KAAK,CAAC,GAClD;;CAGJ,qBAAqB,EACpB,QACA,OACA,aACA,aAAa,QACb,eACA,MACA,UACA,WACA,OACA,aACA,SAa8B;EAC9B,MAAM,YAAqD,EAAE;EAC7D,MAAM,WAAW,SAAS;EAC1B,MAAM,SAAS,WAAW,OAAO,SAAY;EAC7C,MAAM,cAAc,aAAa;EACjC,MAAM,eAAe,SAAS;AAC9B,MAAI,CAAC,aAAc,sCAAqB,OAAO,IAAI,eAAe;EAElE,MAAM,QAAQ,WAAW,IAAI,QAAQ;EACrC,MAAM,SAAS,QAAQ;EAEvB,MAAM,UAAU,KAAK,aAAa,OAAO,WAAW,CAAC,CAAC,UAAU,YAAY,MAAM,OAAO;EAEzF,MAAM,QAAyB,UAAU,WAAW,UAAU,iFAG3D,OACA,OAAO,OACP,YAAY,WACZ,OACA,EACD,cACA,GACC,UAAU,WAAW,kDAEtB,OACA,OAAO,OACP,YAAY,WACZ,OACA,GACC;EACH,MAAM,QAAQ,QAAQ,kDACC,OAAO,OAAO,QAAQ,GAC1C;EACH,MAAM,SAAS,QAAQ,iDACA,OAAO,OAAO,OAAO,GACzC;AACH,MAAI,OAAQ,WAAU,KAAK,GAAG,OAAO,UAAU;EAE/C,IAAI;AACJ,UAAQ,QAAR;GACC,KAAK,OACJ;GACD,SAAS;IACR,MAAM,EAAE,MAAM,cAAc;AAC5B,QAAI,CAAC,UAAW;IAEhB,MAAM,cAAc,OAAO,QAAQ,UAAU,CAAC,QAAQ,CAAC,GAAG,OAAO,EAAE;AACnE,QAAI,CAAC,YAAY,OAAQ;IAEzB,MAAM,aAAyB,IAAI,MAAM,YAAY,SAAS,IAAI,EAAE;AACpE,SAAK,IAAI,UAAU,GAAG,WAAW,GAAG,UAAU,YAAY,QAAQ,EAAE,SAAS;KAC5E,MAAM,CAAC,GAAG,QAAQ,YAAY;KAE9B,MAAM,WAAW,YAAY,UAAU;AACvC,SAAI,CAAC,SAAU,OAAM,IAAIY,yBAAa,EAAE,SAAS,qBAAqB,YAAY,KAAK,QAAQ,EAAE,IAAI,CAAC;KACtG,MAAM,WAAW,SAAS,iBAAiB;KAC3C,MAAM,2CACL,SAAS,aACT,IAAI,eAAe,IACnB;KACD,MAAM,eAAe,SAAS,4CACd,SAAS,cAAc,KAAK,eAAe,GACxD;KACH,MAAM,EAAE,QAAQ,oDACf,UACA,OACA,aACA,aACA;KAED,MAAM,cAAc,eACjB,gBAAG,sDAAkC,aAAa,CAAC,MAAM,kBACzD;KAEH,MAAM,aAAa,KAAK,qBAAqB;MAC5C,OAAO;MACP,MAAM,WAAW,UAAU;MAC3B;MACA,aAAa;MACb,aAAa,OAAO,SAAS;MAC7B,eAAe;MACf,UAAU;MACV,WAAW,GAAG,YAAY,SAAS,GAAG,YAAY,KAAK,KAAK;MAC5D,OAAO,eAAe;MACtB;MACA;MACA,CAAC;AAEF,eAAU,KAAK;MACd,OAAO;MACP,WAAW;MACX,KAAK;MACL,WAAW,WAAW;MACtB,SAAS,CAAC;MACV,aAAc,SAAoB,YAAY,UACzC,SAAS,QACT,CAAC,CAAE,KACJ;MACJ,CAAC;KAEF,MAAM,cAAcX,iBAAI,KACvB,WAAW,UAAU,KAAK,MAAM;AAC/B,aAAO,gBAAG,GAAG,IAAID,yBAAY,KAAK,aAAa,EAAE,IAAI,CAAC,CAAC,IACtD,EAAE,YACC,gBAAG,GAAG,MAAM,GAAGC,iBAAI,WAAW,EAAE,IAAI,CAAC,KACrCA,iBAAI,WAAW,EAAE,IAAI;OAExB,EACF,IAAID,yBAAY,KAAK,CACrB;KAED,MAAM,OAAO,WAAW,QAAQ,gBAAG;KAEnC,MAAM,YAAY,WACf,gBAAG,WAAW,KAAK,UAAU,YAAY,OAAOC,iBAAI,WAAW,IAAI,CAAC,SAAS,WAAW,IAAI,OAC7FA,iBAAI,WACH,IACA,CACD,OAAOA,iBAAI,WAAW,EAAE,KACvB,gBAAG,oBAAoB,KAAK,2BAA2B,YAAY,QACpEA,iBAAI,WACH,IACA,CACD,SAAS,WAAW,IAAI,OAAOA,iBAAI,WAAW,IAAI,CAAC,KAAK,MAAM,eAAeA,iBAAI,WAAW,EAAE;AAEhG,gBAAW,cAAc;AACzB,SAAI,UAAU,YAAY,SAAS,EAAG,YAAW,cAAc,IAAID,yBAAY,KAAK;;AAGrF,YAAQ,IAAIE,iBAAI,WAAW;AAE3B;;;EAIF,MAAM,eAAe;GAAC;GAAS,QAAQ;GAAK;GAAM,CAAC,QACjD,MAAM,MAAM,OACb;AACD,MAAI,CAAC,aAAa,OACjB,OAAM,IAAIU,yBAAa,EACtB,SAAS,iCAAiC,YAAY,KAAK,GAAG,cAAc,MAAM,YAAY,MAAM,MACpG,CAAC;AAcH,SAAO;GACN,KAXa,gBAAG,UAFIX,iBAAI,KAAK,cAAc,IAAID,yBAAY,KAAK,CAAC,CAE1B,+CAA2B,MAAM,GAAG,cAC3E,gBAAG,UAAU,QAAQ,GACpB,MACA,GACC,gBAAG,aAAa,QAAQ,GAAG,MAAM,GAAG,gBAAG,UAAU,QAAQ,GAAG,UAAU,OAAU,GAClF,gBAAG,WAAW,SAAS,GACtB,WAAW,OACX;GAKD;GACA"}