import { Collection, CollectionImpl } from '../../collection/index.js';
import { SingleResult, StringCollationConfig } from '../../types.js';
import { Aggregate, BasicExpression, Func, OrderByDirection, PropRef, Value } from '../ir.js';
import { InitialQueryBuilder, QueryBuilder } from './index.js';
import { VirtualRowProps, WithVirtualProps } from '../../virtual-props.js';
import { CaseWhenWrapper, ConcatToArrayWrapper, ToArrayWrapper } from './functions.js';
/**
 * Context - The central state container for query builder operations
 *
 * This interface tracks all the information needed to build and type-check queries:
 *
 * **Schema Management**:
 * - `baseSchema`: The original tables/collections from the `from()` clause
 * - `schema`: Current available tables (expands with joins, contracts with subqueries)
 *
 * **Query State**:
 * - `fromSourceName`: Which table was used in `from()` or the first
 *   `unionAll()` source - needed for optionality logic
 * - `hasJoins`: Whether any joins have been added (affects result type inference)
 * - `joinTypes`: Maps table aliases to their join types for optionality calculations
 *
 * **Result Tracking**:
 * - `result`: The final shape after `select()` - undefined until select is called
 *
 * The context evolves through the query builder chain:
 * 1. `from()` sets baseSchema and schema to the same thing
 * 2. `join()` expands schema and sets hasJoins/joinTypes
 * 3. `select()` sets result to the projected shape
 */
export interface Context {
    baseSchema: ContextSchema;
    schema: ContextSchema;
    refsSchema?: ContextSchema;
    fromSourceName: string;
    fromSourceNames?: ReadonlyArray<string>;
    hasUnionFrom?: true;
    hasJoins?: boolean;
    joinTypes?: Record<string, `inner` | `left` | `right` | `full` | `outer` | `cross`>;
    result?: any;
    hasResult?: true;
    singleResult?: boolean;
}
/**
 * ContextSchema - The shape of available tables/collections in a query context
 *
 * This is simply a record mapping table aliases to their TypeScript types.
 * It evolves as the query progresses:
 * - Initial: Just the `from()` table
 * - After joins: Includes all joined tables with proper optionality
 * - In subqueries: May be a subset of the outer query's schema
 */
export type ContextSchema = Record<string, unknown>;
/**
 * Source - Input definition for query builder `from()` and `unionAll()` clauses
 *
 * Maps table aliases to either:
 * - `CollectionImpl`: A database collection/table
 * - `QueryBuilder`: A subquery that can be used as a table
 *
 * Example: `{ users: usersCollection }`
 */
export type Source = {
    [alias: string]: CollectionImpl<any, any> | QueryBuilder<Context>;
};
/**
 * InferCollectionType - Extracts the TypeScript type from a CollectionImpl
 *
 * This helper ensures we get the same type that was used when creating the collection itself.
 * This can be an explicit type passed by the user or the schema output type.
 */
export type InferCollectionType<T> = T extends CollectionImpl<infer TOutput, infer TKey, any, any, any> ? WithVirtualProps<TOutput, TKey> : never;
/**
 * SchemaFromSource - Converts a Source definition into a ContextSchema
 *
 * This transforms the input to `from()` into the schema format used throughout
 * the query builder. For each alias in the source:
 * - Collections → their inferred TypeScript type
 * - Subqueries → their result type (what they would return if executed)
 *
 * The `Prettify` wrapper ensures clean type display in IDEs.
 */
export type SchemaFromSource<T extends Source> = Prettify<{
    [K in keyof T]: T[K] extends CollectionImpl<any, any, any, any, any> ? InferCollectionType<T[K]> : T[K] extends QueryBuilder<infer TContext> ? GetResult<TContext> : never;
}>;
export type UnionRefsSchema<TSchema extends ContextSchema> = Prettify<{
    [K in keyof TSchema]: TSchema[K] | undefined;
}>;
type IsUnion<T, U = T> = T extends unknown ? [U] extends [T] ? false : true : false;
export type SingleSource<TSource extends Source> = IsUnion<keyof TSource & string> extends true ? never : TSource;
export type ContextFromSource<TSource extends Source> = {
    baseSchema: SchemaFromSource<TSource>;
    schema: SchemaFromSource<TSource>;
    fromSourceName: keyof TSource & string;
    hasJoins: false;
};
export type ContextFromUnionSource<TSource extends Source> = IsUnion<keyof TSource & string> extends true ? {
    baseSchema: SchemaFromSource<TSource>;
    schema: UnionRefsSchema<SchemaFromSource<TSource>>;
    fromSourceName: keyof TSource & string;
    fromSourceNames: ReadonlyArray<keyof TSource & string>;
    hasUnionFrom: true;
    hasJoins: false;
} : ContextFromSource<TSource>;
type ResultFromBranch<TBranch> = TBranch extends QueryBuilder<infer TContext> ? GetResult<TContext> : never;
type UnionBranchResult<TBranches extends ReadonlyArray<QueryBuilder<any>>> = ResultFromBranch<TBranches[number]>;
type UnionBranchSchema<TBranches extends ReadonlyArray<QueryBuilder<any>>> = UnionBranchResult<TBranches> extends infer TResult ? {
    [K in KeysOfUnion<TResult>]: ValueOfUnion<TResult, K>;
} : never;
export type ContextFromUnionBranches<TBranches extends readonly [QueryBuilder<any>, ...Array<QueryBuilder<any>>]> = {
    baseSchema: UnionBranchSchema<TBranches> & ContextSchema;
    schema: UnionBranchSchema<TBranches> & ContextSchema;
    refsSchema: UnionBranchSchema<TBranches>;
    fromSourceName: keyof UnionBranchSchema<TBranches> & string;
    hasJoins: false;
    result: PrettifyIfPlainObject<UnionBranchResult<TBranches>>;
    hasResult: true;
};
/**
 * GetAliases - Extracts all table aliases available in a query context
 *
 * Simple utility type that returns the keys of the schema, representing
 * all table/source aliases that can be referenced in the current query.
 */
export type GetAliases<TContext extends Context> = keyof TContext[`schema`];
/**
 * WhereCallback - Type for where/having clause callback functions
 *
 * These callbacks receive a `refs` object containing RefProxy instances for
 * all available tables. The callback should return a boolean expression
 * that will be used to filter query results.
 *
 * Example: `(refs) => eq(refs.users.age, 25)`
 */
export type WhereCallback<TContext extends Context> = (refs: RefsForContext<TContext>) => any;
/**
 * SelectValue - Union of all valid values in a select clause
 *
 * This type defines what can be used as values in the object passed to `select()`.
 *
 * **Core Expression Types**:
 * - `BasicExpression`: Function calls like `upper(users.name)`
 * - `Aggregate`: Aggregations like `count()`, `avg()`
 * - `RefProxy/Ref`: Direct field references like `users.name`
 *
 * **JavaScript Literals** (for constant values in projections):
 * - `string`: String literals like `'active'`, `'N/A'`
 * - `number`: Numeric literals like `0`, `42`, `3.14`
 * - `boolean`: Boolean literals `true`, `false`
 * - `null`: Explicit null values
 *
 * **Advanced Features**:
 * - `undefined`: Allows optional projection values
 * - `{ [key: string]: SelectValue }`: Nested object projection
 *
 * The clean Ref type ensures no internal properties are visible to users.
 *
 * Examples:
 * ```typescript
 * select({
 *   id: users.id,
 *   name: users.name,
 *   status: 'active',        // string literal
 *   priority: 1,             // number literal
 *   verified: true,          // boolean literal
 *   notes: null,             // explicit null
 *   profile: {
 *     name: users.name,
 *     email: users.email
 *   }
 * })
 * ```
 */
type SelectValue = BasicExpression | Aggregate | Ref | RefLeaf<any> | string | number | boolean | null | undefined | {
    [key: string]: SelectValue;
} | Array<RefLeaf<any>> | ToArrayWrapper | ConcatToArrayWrapper | CaseWhenWrapper | QueryBuilder<any>;
type SelectShape = {
    [key: string]: SelectValue | SelectShape;
};
export type ScalarSelectValue = BasicExpression | Aggregate | Ref | RefLeaf<any> | string | number | boolean | null | undefined;
export type StringifiableScalar = string | number | boolean | null | undefined;
/**
 * SelectObject - Wrapper type for select clause objects
 *
 * This ensures that objects passed to `select()` have valid SelectValue types
 * for all their properties. It's a simple wrapper that provides better error
 * messages when invalid selections are attempted.
 */
export type SelectObject<T extends SelectShape = SelectShape> = T;
type RefBrandKeys = typeof RefBrand | typeof NullableBrand;
type HasNamedSelectKeys<T> = Exclude<keyof T, RefBrandKeys> extends never ? false : true;
type IsScalarSelectLike<T> = T extends BasicExpression | Aggregate ? true : T extends string | number | boolean | null | undefined ? true : typeof RefBrand extends keyof T ? HasNamedSelectKeys<T> extends true ? false : true : false;
export type NonScalarSelectObject<T> = T extends SelectObject ? IsScalarSelectLike<T> extends true ? never : T : never;
export type ResultTypeFromSelectValue<TSelectValue> = IsAny<TSelectValue> extends true ? any : WithoutRefBrand<NeedsExtraction<TSelectValue> extends true ? ExtractExpressionType<TSelectValue> : TSelectValue extends ToArrayWrapper<infer T> ? Array<T> : TSelectValue extends ConcatToArrayWrapper<any> ? string : TSelectValue extends {
    readonly __brand: `CaseWhenWrapper`;
    readonly _result?: infer T;
} ? ResultTypeFromCaseWhen<T> : TSelectValue extends QueryBuilder<infer TChildContext> ? Collection<GetResult<TChildContext>> : TSelectValue extends Ref<infer _T> ? ExtractRef<TSelectValue> : TSelectValue extends RefLeaf<infer T> ? IsNullableRef<TSelectValue> extends true ? T | undefined : T : TSelectValue extends RefLeaf<infer T> | undefined ? T | undefined : TSelectValue extends RefLeaf<infer T> | null ? IsNullableRef<Exclude<TSelectValue, null>> extends true ? T | null | undefined : T | null : TSelectValue extends Ref<infer _T> | undefined ? ExtractRef<Exclude<TSelectValue, undefined>> | undefined : TSelectValue extends Ref<infer _T> | null ? ExtractRef<Exclude<TSelectValue, null>> | null : TSelectValue extends Aggregate<infer T> ? T : TSelectValue extends string | number | boolean | null | undefined ? TSelectValue : TSelectValue extends Record<string, any> ? ResultTypeFromSelect<TSelectValue> : never>;
/**
 * ResultTypeFromSelect - Infers the result type from a select object
 *
 * This complex type transforms the input to `select()` into the actual TypeScript
 * type that the query will return. It handles all the different kinds of values
 * that can appear in a select clause:
 *
 * **Ref/RefProxy Extraction**:
 * - `RefProxy<T>` → `T`: Extracts the underlying type
 * - `Ref<T> | undefined` → `T | undefined`: Preserves optionality
 * - `Ref<T> | null` → `T | null`: Preserves nullability
 *
 * **Expression Types**:
 * - `BasicExpression<T>` → `T`: Function results like `upper()` → `string`
 * - `Aggregate<T>` → `T`: Aggregation results like `count()` → `number`
 *
 * **JavaScript Literals** (pass through as-is):
 * - `string` → `string`: String literals remain strings
 * - `number` → `number`: Numeric literals remain numbers
 * - `boolean` → `boolean`: Boolean literals remain booleans
 * - `null` → `null`: Explicit null remains null
 * - `undefined` → `undefined`: Direct undefined values
 *
 * **Nested Objects** (recursive):
 * - Plain objects are recursively processed to handle nested projections
 * - RefProxy objects are detected and their types extracted
 *
 * Example transformation:
 * ```typescript
 * // Input:
 * { id: Ref<number>, name: Ref<string>, status: 'active', count: 42, profile: { bio: Ref<string> } }
 *
 * // Output:
 * { id: number, name: string, status: 'active', count: 42, profile: { bio: string } }
 * ```
 */
export type ResultTypeFromSelect<TSelectObject> = IsAny<TSelectObject> extends true ? any : WithoutRefBrand<Prettify<{
    [K in keyof TSelectObject]: NeedsExtraction<TSelectObject[K]> extends true ? ExtractExpressionType<TSelectObject[K]> : TSelectObject[K] extends ToArrayWrapper<infer T> ? Array<T> : TSelectObject[K] extends ConcatToArrayWrapper<any> ? string : TSelectObject[K] extends {
        readonly __brand: `CaseWhenWrapper`;
        readonly _result?: infer T;
    } ? ResultTypeFromCaseWhen<T> : TSelectObject[K] extends QueryBuilder<infer TChildContext> ? Collection<GetResult<TChildContext>> : TSelectObject[K] extends Ref<infer _T> ? ExtractRef<TSelectObject[K]> : TSelectObject[K] extends RefLeaf<infer T> ? IsNullableRef<TSelectObject[K]> extends true ? T | undefined : T : TSelectObject[K] extends RefLeaf<infer T> | undefined ? T | undefined : TSelectObject[K] extends RefLeaf<infer T> | null ? IsNullableRef<Exclude<TSelectObject[K], null>> extends true ? T | null | undefined : T | null : TSelectObject[K] extends Ref<infer _T> | undefined ? ExtractRef<Exclude<TSelectObject[K], undefined>> | undefined : TSelectObject[K] extends Ref<infer _T> | null ? ExtractRef<Exclude<TSelectObject[K], null>> | null : TSelectObject[K] extends Aggregate<infer T> ? T : TSelectObject[K] extends string | number | boolean | null | undefined ? TSelectObject[K] : TSelectObject[K] extends Record<string, any> ? ResultTypeFromSelect<TSelectObject[K]> : never;
}>>;
export type SelectResult<TSelect> = IsPlainObject<TSelect> extends true ? ResultTypeFromSelect<TSelect> : ResultTypeFromSelectValue<TSelect>;
type ResultTypeFromCaseWhen<T> = T extends unknown ? ResultTypeFromSelectValue<T> : never;
type ExtractRef<T> = Prettify<ResultTypeFromSelect<WithoutRefBrand<T>>>;
type ExtractExpressionType<T> = T extends PropRef<infer U> ? U : T extends Value<infer U> ? U : T extends Func<infer U> ? U : T extends Aggregate<infer U> ? U : T extends BasicExpression<infer U> ? U : T;
type NeedsExtraction<T> = T extends PropRef<any> | Value<any> | Func<any> | Aggregate<any> | BasicExpression<any> ? true : false;
/**
 * OrderByCallback - Type for orderBy clause callback functions
 *
 * Similar to WhereCallback, these receive refs for all available tables
 * and should return expressions that will be used for sorting.
 *
 * Example: `(refs) => refs.users.createdAt`
 */
export type OrderByCallback<TContext extends Context> = (refs: RefsForContext<TContext>) => any;
/**
 * OrderByOptions - Configuration for orderBy operations
 *
 * Combines direction and null handling with string-specific sorting options.
 * The intersection with StringSortOpts allows for either simple lexical sorting
 * or locale-aware sorting with customizable options.
 */
export type OrderByOptions = {
    direction?: OrderByDirection;
    nulls?: `first` | `last`;
} & StringCollationConfig;
/**
 * CompareOptions - Final resolved options for comparison operations
 *
 * This is the internal type used after all orderBy options have been resolved
 * to their concrete values. Unlike OrderByOptions, all fields are required
 * since defaults have been applied.
 */
export type CompareOptions = StringCollationConfig & {
    direction: OrderByDirection;
    nulls: `first` | `last`;
};
/**
 * GroupByCallback - Type for groupBy clause callback functions
 *
 * These callbacks receive refs for all available tables and should return
 * expressions that will be used for grouping query results.
 *
 * Example: `(refs) => refs.orders.status`
 */
export type GroupByCallback<TContext extends Context> = (refs: RefsForContext<TContext>) => any;
/**
 * JoinOnCallback - Type for join condition callback functions
 *
 * These callbacks receive refs for all available tables (including the newly
 * joined table) and should return a boolean expression defining the join condition.
 *
 * Important: The newly joined table is NOT marked as optional in this callback,
 * even for left/right/full joins, because optionality is applied AFTER the join
 * condition is evaluated.
 *
 * Example: `(refs) => eq(refs.users.id, refs.orders.userId)`
 */
export type JoinOnCallback<TContext extends Context> = (refs: RefsForContext<TContext>) => any;
/**
 * FunctionalHavingRow - Type for the row parameter in functional having callbacks
 *
 * Functional having callbacks receive a namespaced row that includes:
 * - Table data from the schema (when available)
 * - $selected: The SELECT result fields (when select() has been called)
 *
 * After `select()` is called, this type includes `$selected` which provides access
 * to the SELECT result fields via `$selected.fieldName` syntax.
 *
 * Note: When used with GROUP BY, functional having receives `{ $selected: ... }` with the
 * aggregated SELECT results. When used without GROUP BY, it receives the full namespaced row
 * which includes both table data and `$selected`.
 *
 * Example: `({ $selected }) => $selected.sessionCount > 2`
 * Example (no GROUP BY): `(row) => row.user.salary > 70000 && row.$selected.user_count > 2`
 */
export type FunctionalHavingRow<TContext extends Context> = TContext[`schema`] & (TContext[`hasResult`] extends true ? {
    $selected: TContext[`result`];
} : {});
/**
 * RefsForContext - Creates ref proxies for all tables/collections in a query context
 *
 * This is the main entry point for creating ref objects in query builder callbacks.
 * For nullable join sides (left/right/full joins), it produces `Ref<T, true>` instead
 * of `Ref<T> | undefined`. This accurately reflects that the proxy object is always
 * present at build time (it's a truthy proxy that records property access paths),
 * while the `Nullable` flag ensures the result type correctly includes `| undefined`.
 *
 * Examples:
 * - Required field: `Ref<User>` → user.name works, result is T
 * - Nullable join side: `Ref<User, true>` → user.name works, result is T | undefined
 *
 * After `select()` is called, this type also includes `$selected` which provides access
 * to the SELECT result fields via `$selected.fieldName` syntax.
 */
type KeysOfUnion<T> = T extends unknown ? keyof T : never;
type ValueOfUnion<T, K extends PropertyKey> = T extends unknown ? K extends keyof T ? T[K] : never : never;
type RefForContextValue<T, Nullable extends boolean = false> = IsPlainObject<T> extends true ? Ref<T, Nullable> : RefLeaf<T, Nullable>;
type RefsSchemaForContext<TContext extends Context> = IsExactlyUndefined<TContext[`refsSchema`]> extends true ? TContext[`schema`] : NonUndefined<TContext[`refsSchema`]> extends ContextSchema ? NonUndefined<TContext[`refsSchema`]> : TContext[`schema`];
export type RefsForContext<TContext extends Context> = {
    [K in KeysOfUnion<RefsSchemaForContext<TContext>>]: IsNonExactOptional<ValueOfUnion<RefsSchemaForContext<TContext>, K>> extends true ? IsNonExactNullable<ValueOfUnion<RefsSchemaForContext<TContext>, K>> extends true ? RefForContextValue<NonNullable<ValueOfUnion<RefsSchemaForContext<TContext>, K>>, true> : RefForContextValue<NonUndefined<ValueOfUnion<RefsSchemaForContext<TContext>, K>>, true> : IsNonExactNullable<ValueOfUnion<RefsSchemaForContext<TContext>, K>> extends true ? RefForContextValue<NonNull<ValueOfUnion<RefsSchemaForContext<TContext>, K>>, true> : RefForContextValue<ValueOfUnion<RefsSchemaForContext<TContext>, K>>;
} & (TContext[`hasResult`] extends true ? {
    $selected: Ref<TContext[`result`]>;
} : {});
/**
 * Type Detection Helpers
 *
 * These helpers distinguish between different kinds of optionality/nullability:
 * - IsExactlyUndefined: T is literally `undefined` (not `string | undefined`)
 * - IsOptional: T includes undefined (like `string | undefined`)
 * - IsExactlyNull: T is literally `null` (not `string | null`)
 * - IsNullable: T includes null (like `string | null`)
 * - IsNonExactOptional: T includes undefined but is not exactly undefined
 * - IsNonExactNullable: T includes null but is not exactly null
 *
 * The [T] extends [undefined] pattern prevents distributive conditional types,
 * ensuring we check the exact type rather than distributing over union members.
 */
type IsExactlyUndefined<T> = [T] extends [undefined] ? true : false;
type IsExactlyNull<T> = [T] extends [null] ? true : false;
type IsOptional<T> = undefined extends T ? true : false;
type IsNullable<T> = null extends T ? true : false;
type IsNonExactOptional<T> = IsOptional<T> extends true ? IsExactlyUndefined<T> extends false ? true : false : false;
type IsNonExactNullable<T> = IsNullable<T> extends true ? IsExactlyNull<T> extends false ? true : false : false;
/**
 * Type Extraction Helpers
 *
 * These helpers extract the "useful" part of a type by removing null/undefined:
 * - NonUndefined: `string | undefined` → `string` (preserves null if present)
 * - NonNull: `string | null` → `string` (preserves undefined if present)
 *
 * These are used when we need to handle optional and nullable types separately.
 * For cases where both null and undefined should be removed, use TypeScript's
 * built-in NonNullable<T> instead.
 */
type NonUndefined<T> = T extends undefined ? never : T;
type NonNull<T> = T extends null ? never : T;
/**
 * Virtual properties available on all Ref types in query builders.
 * These allow querying on sync status, origin, key, and collection ID.
 *
 * @example
 * ```typescript
 * // Filter by sync status
 * .where(({ user }) => eq(user.$synced, true))
 *
 * // Filter by origin
 * .where(({ order }) => eq(order.$origin, 'local'))
 *
 * // Access key in select
 * .select(({ user }) => ({
 *   key: user.$key,
 *   collectionId: user.$collectionId,
 * }))
 * ```
 */
type VirtualPropsRef<TKey extends string | number = string | number> = {
    readonly [K in keyof VirtualRowProps<TKey>]: RefLeaf<VirtualRowProps<TKey>[K]>;
};
/**
 * Ref - The user-facing ref interface for the query builder
 *
 * This is a clean type that represents a reference to a value in the query,
 * designed for optimal IDE experience without internal implementation details.
 * It provides a recursive interface that allows nested property access while
 * preserving optionality and nullability correctly.
 *
 * The `Nullable` parameter indicates whether this ref comes from a nullable
 * join side (left/right/full). When `true`, the `Nullable` flag propagates
 * through all nested property accesses, ensuring the result type includes
 * `| undefined` for all fields accessed through this ref.
 *
 * Includes virtual properties ($synced, $origin, $key, $collectionId) for
 * querying on sync status and row metadata.
 *
 * Example usage:
 * ```typescript
 * // Clean interface - no internal properties visible
 * const users: Ref<{ id: number; profile?: { bio: string } }> = { ... }
 * users.id // Ref<number> - clean display
 * users.profile?.bio // Ref<string> - nested optional access works
 * users.$synced // RefLeaf<boolean> - virtual property access
 *
 * // Nullable ref (left/right/full join side):
 * select(({ dept }) => ({ name: dept.name })) // result: string | undefined
 *
 * // Spread operations work cleanly:
 * select(({ user }) => ({ ...user })) // Returns User type, not Ref types
 * ```
 */
export type Ref<T = any, Nullable extends boolean = false> = {
    [K in keyof T]: IsNonExactOptional<T[K]> extends true ? IsNonExactNullable<T[K]> extends true ? IsPlainObject<NonNullable<T[K]>> extends true ? Ref<NonNullable<T[K]>, Nullable> | undefined : RefLeaf<NonNullable<T[K]>, Nullable> | undefined : IsPlainObject<NonUndefined<T[K]>> extends true ? Ref<NonUndefined<T[K]>, Nullable> | undefined : RefLeaf<NonUndefined<T[K]>, Nullable> | undefined : IsNonExactNullable<T[K]> extends true ? IsPlainObject<NonNull<T[K]>> extends true ? Ref<NonNull<T[K]>, Nullable> | null : RefLeaf<NonNull<T[K]>, Nullable> | null : IsPlainObject<T[K]> extends true ? Ref<T[K], Nullable> : RefLeaf<T[K], Nullable>;
} & RefLeaf<T, Nullable> & VirtualPropsRef;
/**
 * Ref - The user-facing ref type with clean IDE display
 *
 * An opaque branded type that represents a reference to a value in a query.
 * This shows as `Ref<T>` in the IDE without exposing internal structure.
 *
 * Example usage:
 * - Ref<number> displays as `Ref<number>` in IDE
 * - Ref<string> displays as `Ref<string>` in IDE
 * - No internal properties like __refProxy, __path, __type are visible
 */
declare const RefBrand: unique symbol;
declare const NullableBrand: unique symbol;
export type RefLeaf<T = any, Nullable extends boolean = false> = {
    readonly [RefBrand]?: T;
} & ([Nullable] extends [true] ? {
    readonly [NullableBrand]?: true;
} : {});
type IsNullableRef<T> = typeof NullableBrand extends keyof T ? true : false;
type WithoutRefBrand<T> = IsPlainObject<T> extends true ? Omit<T, typeof RefBrand | typeof NullableBrand> : T;
/**
 * PreserveSingleResultFlag - Conditionally includes the singleResult flag
 *
 * This helper type ensures the singleResult flag is only added to the context when it's
 * explicitly true. It uses a non-distributive conditional (tuple wrapper) to prevent
 * unexpected behavior when TFlag is a union type.
 *
 * @template TFlag - The singleResult flag value to check
 * @returns { singleResult: true } if TFlag is true, otherwise {}
 */
type PreserveSingleResultFlag<TFlag> = [TFlag] extends [true] ? {
    singleResult: true;
} : {};
type PreserveHasResultFlag<TFlag> = [TFlag] extends [true] ? {
    hasResult: true;
} : {};
type PreserveUnionFromFlag<TFlag> = [TFlag] extends [true] ? {
    hasUnionFrom: true;
} : {};
type PreserveFromSourceNames<TNames> = [TNames] extends [ReadonlyArray<string>] ? {
    fromSourceNames: TNames;
} : {};
/**
 * MergeContextWithJoinType - Creates a new context after a join operation
 *
 * This is the core type that handles the complex logic of merging schemas
 * when tables are joined, applying the correct optionality based on join type.
 *
 * **Key Responsibilities**:
 * 1. **Schema Merging**: Combines existing schema with newly joined tables
 * 2. **Optionality Logic**: Applies join-specific optionality rules:
 *    - `LEFT JOIN`: New table becomes optional
 *    - `RIGHT JOIN`: Existing tables become optional
 *    - `FULL JOIN`: Both existing and new become optional
 *    - `INNER JOIN`: No tables become optional
 * 3. **State Tracking**: Updates hasJoins and joinTypes for future operations
 *
 * **Context Evolution**:
 * - `baseSchema`: Unchanged (always the original `from()` tables)
 * - `schema`: Expanded with new tables and proper optionality
 * - `hasJoins`: Set to true
 * - `joinTypes`: Updated to track this join type
 * - `result`: Preserved from previous operations
 * - `singleResult`: Preserved only if already true (via PreserveSingleResultFlag)
 */
export type MergeContextWithJoinType<TContext extends Context, TNewSchema extends ContextSchema, TJoinType extends `inner` | `left` | `right` | `full` | `outer` | `cross`> = {
    baseSchema: TContext[`baseSchema`];
    schema: ApplyJoinOptionalityToMergedSchema<TContext[`schema`], TNewSchema, TJoinType, FromSourceNamesForOptionality<TContext>>;
    refsSchema: ApplyJoinOptionalityToMergedSchema<RefsSchemaForContext<TContext>, TNewSchema, TJoinType, FromSourceNamesForOptionality<TContext>>;
    fromSourceName: TContext[`fromSourceName`];
    hasJoins: true;
    joinTypes: (TContext[`joinTypes`] extends Record<string, any> ? TContext[`joinTypes`] : {}) & {
        [K in keyof TNewSchema & string]: TJoinType;
    };
    result: TContext[`result`];
} & PreserveSingleResultFlag<TContext[`singleResult`]> & PreserveHasResultFlag<TContext[`hasResult`]> & PreserveUnionFromFlag<TContext[`hasUnionFrom`]> & PreserveFromSourceNames<TContext[`fromSourceNames`]>;
/**
 * ApplyJoinOptionalityToMergedSchema - Applies optionality rules when merging schemas
 *
 * This type implements the SQL join optionality semantics:
 *
 * **For Existing Tables**:
 * - `RIGHT JOIN` or `FULL JOIN`: Main table (from fromSourceName) becomes optional
 * - Other join types: Existing tables keep their current optionality
 * - Previously joined tables: Keep their already-applied optionality
 *
 * **For New Tables**:
 * - `LEFT JOIN` or `FULL JOIN`: New table becomes optional
 * - `INNER JOIN` or `RIGHT JOIN`: New table remains required
 *
 * **Examples**:
 * ```sql
 * FROM users LEFT JOIN orders  -- orders becomes optional
 * FROM users RIGHT JOIN orders -- users becomes optional
 * FROM users FULL JOIN orders  -- both become optional
 * FROM users INNER JOIN orders -- both remain required
 * ```
 *
 * The intersection (&) ensures both existing and new schemas are merged
 * into a single type while preserving all table references.
 */
export type ApplyJoinOptionalityToMergedSchema<TExistingSchema extends ContextSchema, TNewSchema extends ContextSchema, TJoinType extends `inner` | `left` | `right` | `full` | `outer` | `cross`, TFromSourceNames extends string> = {
    [K in keyof TExistingSchema]: K extends TFromSourceNames ? TJoinType extends `right` | `full` ? TExistingSchema[K] | undefined : TExistingSchema[K] : TExistingSchema[K];
} & {
    [K in keyof TNewSchema]: TJoinType extends `left` | `full` ? // New table becomes optional for left and full joins
    TNewSchema[K] | undefined : TNewSchema[K];
};
/**
 * Utility type to infer the query result size (single row or an array)
 */
export type InferResultType<TContext extends Context> = TContext extends SingleResult ? GetResult<TContext> | undefined : Array<GetResult<TContext>>;
type WithVirtualPropsIfObject<TResult> = TResult extends object ? WithVirtualProps<TResult, string | number> : TResult;
type PrettifyIfPlainObject<T> = IsPlainObject<T> extends true ? Prettify<T> : T;
type FromSourceNamesForOptionality<TContext extends Context> = TContext[`fromSourceNames`] extends ReadonlyArray<infer TName> ? TName & string : TContext[`fromSourceName`];
type HasRightOrFullJoin<TContext extends Context> = TContext[`joinTypes`] extends Record<string, infer TJoinType> ? Extract<TJoinType, `right` | `full`> extends never ? false : true : false;
type JoinedOnlyUnionFromResult<TBaseSchema extends ContextSchema, TSchema extends ContextSchema> = Prettify<{
    [P in keyof TBaseSchema]?: undefined;
} & {
    [P in Exclude<keyof TSchema, keyof TBaseSchema>]: TSchema[P];
}>;
type UnionFromResult<TBaseSchema extends ContextSchema, TSchema extends ContextSchema, THasJoinedOnlyBranch extends boolean = false> = {
    [K in keyof TBaseSchema]: Prettify<{
        [P in K]: NonUndefined<TSchema[Extract<P, keyof TSchema>]>;
    } & {
        [P in Exclude<keyof TBaseSchema, K>]?: undefined;
    } & {
        [P in Exclude<keyof TSchema, keyof TBaseSchema>]: TSchema[P];
    }>;
}[keyof TBaseSchema] | (THasJoinedOnlyBranch extends true ? JoinedOnlyUnionFromResult<TBaseSchema, TSchema> : never);
type ResultValue<TContext extends Context> = TContext[`hasResult`] extends true ? WithVirtualPropsIfObject<TContext[`result`]> : TContext[`hasUnionFrom`] extends true ? UnionFromResult<TContext[`baseSchema`], TContext[`schema`], HasRightOrFullJoin<TContext>> : TContext[`hasJoins`] extends true ? TContext[`schema`] : TContext[`schema`][TContext[`fromSourceName`]];
/**
 * GetResult - Determines the final result type of a query
 *
 * This type implements the logic for what a query returns based on its current state:
 *
 * **Priority Order**:
 * 1. **Explicit Result**: If `select()` was called, use the projected type
 * 2. **Join Query**: If joins exist, return all tables with proper optionality
 * 3. **Single Table**: Return just the main table from `from()`
 *
 * **Examples**:
 * ```typescript
 * // Single table query:
 * from({ users }).where(...) // → User[]
 *
 * // Join query without select:
 * from({ users }).leftJoin({ orders }, ...) // → { users: User, orders: Order | undefined }[]
 *
 * // Query with select:
 * from({ users }).select({ id: users.id, name: users.name }) // → { id: number, name: string }[]
 * ```
 *
 * The `Prettify` wrapper ensures clean type display in IDEs by flattening
 * complex intersection types into readable object types.
 */
export type GetRawResult<TContext extends Context> = ResultValue<TContext>;
export type GetResult<TContext extends Context> = Prettify<ResultValue<TContext>>;
type IsExactlyContext<TContext extends Context> = [Context] extends [TContext] ? [TContext] extends [Context] ? true : false : false;
type RootScalarResultError = {
    readonly __tanstackDbRootQueryError__: `Top-level scalar results are not supported by createLiveQueryCollection() or queryOnce(). Return an object, or use the scalar query inside toArray(...) or concat(toArray(...)).`;
};
export type RootObjectResultConstraint<TContext extends Context> = IsExactlyContext<TContext> extends true ? unknown : GetResult<TContext> extends object ? unknown : RootScalarResultError;
type ContextFromQueryBuilder<TQuery extends QueryBuilder<any>> = TQuery extends QueryBuilder<infer TContext> ? TContext : never;
export type RootQueryBuilder<TQuery extends QueryBuilder<any>> = TQuery & RootObjectResultConstraint<ContextFromQueryBuilder<TQuery>>;
export type RootQueryFn<TQuery extends QueryBuilder<any>> = (q: InitialQueryBuilder) => RootQueryBuilder<TQuery>;
export type RootQueryResult<TContext extends Context> = IsExactlyContext<TContext> extends true ? any : GetResult<TContext> extends object ? GetResult<TContext> : never;
/**
 * ApplyJoinOptionalityToSchema - Legacy helper for complex join scenarios
 *
 * This type was designed to handle complex scenarios with multiple joins
 * where the optionality of tables might be affected by subsequent joins.
 * Currently used in advanced join logic, but most cases are handled by
 * the simpler `ApplyJoinOptionalityToMergedSchema`.
 *
 * **Logic**:
 * 1. **Main Table**: Becomes optional if ANY right or full join exists in the chain
 * 2. **Joined Tables**: Check their specific join type for optionality
 * 3. **Complex Cases**: Handle scenarios where subsequent joins affect earlier tables
 *
 * This is primarily used for edge cases and may be simplified in future versions
 * as the simpler merge-based approach covers most real-world scenarios.
 */
export type ApplyJoinOptionalityToSchema<TSchema extends ContextSchema, TJoinTypes extends Record<string, string>, TFromSourceName extends string> = {
    [K in keyof TSchema]: K extends TFromSourceName ? HasJoinType<TJoinTypes, `right` | `full`> extends true ? TSchema[K] | undefined : TSchema[K] : K extends keyof TJoinTypes ? TJoinTypes[K] extends `left` | `full` ? TSchema[K] | undefined : IsTableMadeOptionalBySubsequentJoins<K, TJoinTypes, TFromSourceName> extends true ? TSchema[K] | undefined : TSchema[K] : TSchema[K];
};
/**
 * IsTableMadeOptionalBySubsequentJoins - Checks if later joins affect table optionality
 *
 * This helper determines if a table that was initially required becomes optional
 * due to joins that happen later in the query chain.
 *
 * **Current Implementation**:
 * - Main table: Becomes optional if any right/full joins exist
 * - Joined tables: Not affected by subsequent joins (simplified model)
 *
 * This is a conservative approach that may be extended in the future to handle
 * more complex join interaction scenarios.
 */
type IsTableMadeOptionalBySubsequentJoins<TTableAlias extends string | number | symbol, TJoinTypes extends Record<string, string>, TFromSourceName extends string> = TTableAlias extends TFromSourceName ? HasJoinType<TJoinTypes, `right` | `full`> : false;
/**
 * HasJoinType - Utility to check if any join in a chain matches target types
 *
 * This type searches through all recorded join types to see if any match
 * the specified target types. It's used to implement logic like "becomes optional
 * if ANY right or full join exists in the chain".
 *
 * **How it works**:
 * 1. Maps over all join types, checking each against target types
 * 2. Creates a union of boolean results
 * 3. Uses `true extends Union` pattern to check if any were true
 *
 * **Example**:
 * ```typescript
 * HasJoinType<{ orders: 'left', products: 'right' }, 'right' | 'full'>
 * // → true (because products is a right join)
 * ```
 */
export type HasJoinType<TJoinTypes extends Record<string, string>, TTargetTypes extends string> = true extends {
    [K in keyof TJoinTypes]: TJoinTypes[K] extends TTargetTypes ? true : false;
}[keyof TJoinTypes] ? true : false;
/**
 * MergeContextForJoinCallback - Special context for join condition callbacks
 *
 * This type creates a context specifically for the `onCallback` parameter of join operations.
 * The key difference from `MergeContextWithJoinType` is that NO optionality is applied here.
 *
 * **Why No Optionality?**
 * In SQL, join conditions are evaluated BEFORE optionality is determined. Both tables
 * must be treated as available (non-optional) within the join condition itself.
 * Optionality is only applied to the result AFTER the join logic executes.
 *
 * **Example**:
 * ```typescript
 * .from({ users })
 * .leftJoin({ orders }, ({ users, orders }) => {
 *   // users is NOT optional here - we can access users.id directly
 *   // orders is NOT optional here - we can access orders.userId directly
 *   return eq(users.id, orders.userId)
 * })
 * .where(({ orders }) => {
 *   // NOW orders is optional because it's after the LEFT JOIN
 *   return orders?.status === 'pending'
 * })
 * ```
 *
 * The simple intersection (&) merges schemas without any optionality transformation.
 */
export type MergeContextForJoinCallback<TContext extends Context, TNewSchema extends ContextSchema> = {
    baseSchema: TContext[`baseSchema`];
    schema: TContext[`schema`] & TNewSchema;
    refsSchema: RefsSchemaForContext<TContext> & TNewSchema;
    fromSourceName: TContext[`fromSourceName`];
    hasJoins: true;
    joinTypes: TContext[`joinTypes`] extends Record<string, any> ? TContext[`joinTypes`] : {};
    result: TContext[`result`];
} & PreserveHasResultFlag<TContext[`hasResult`]> & PreserveUnionFromFlag<TContext[`hasUnionFrom`]> & PreserveFromSourceNames<TContext[`fromSourceNames`]>;
/**
 * WithResult - Updates a context with a new result type after select()
 *
 * This utility type is used internally when the `select()` method is called
 * to update the context with the projected result type. It preserves all
 * other context properties while replacing the `result` field.
 *
 * **Usage**:
 * When `select()` is called, the query builder uses this type to create
 * a new context where `result` contains the shape of the selected fields.
 *
 * The double `Prettify` ensures both the overall context and the nested
 * result type display cleanly in IDEs.
 */
export type WithResult<TContext extends Context, TResult> = Prettify<Omit<TContext, `result` | `hasResult`> & {
    result: PrettifyIfPlainObject<TResult>;
    hasResult: true;
}>;
/**
 * Prettify - Utility type for clean IDE display
 */
export type Prettify<T> = {
    [K in keyof T]: T[K];
} & {};
/**
 * IsPlainObject - Utility type to check if T is a plain object
 *
 * Returns `false` for:
 * - Arrays (ReadonlyArray)
 * - JavaScript built-ins (Date, Map, Set, etc.)
 * - Objects with `Symbol.toStringTag` (class instances like Temporal types,
 *   TypedArrays not already in JsBuiltIns, etc.) — these are not plain data objects
 */
type IsPlainObject<T> = T extends unknown ? T extends object ? T extends ReadonlyArray<any> ? false : T extends JsBuiltIns ? false : T extends {
    readonly [Symbol.toStringTag]: string;
} ? false : true : false : false;
type IsAny<T> = 0 extends 1 & T ? true : false;
/**
 * JsBuiltIns - List of JavaScript built-ins
 */
type JsBuiltIns = ArrayBuffer | ArrayBufferLike | AsyncGenerator<any, any, any> | BigInt64Array | BigUint64Array | DataView | Date | Error | Float32Array | Float64Array | Function | Generator<any, any, any> | Int16Array | Int32Array | Int8Array | Map<any, any> | Promise<any> | RegExp | Set<any> | string | Uint16Array | Uint32Array | Uint8Array | Uint8ClampedArray | WeakMap<any, any> | WeakSet<any>;
export {};