Function toExpression

packages/db/src/query/builder/ref-proxy.ts:294–334

(value: any)

export function toExpression<T = any>(value: T): BasicExpression<T>
export function toExpression(value: RefProxy<any>): BasicExpression<any>
export function toExpression(value: any): BasicExpression<any> {
  if (isRefProxy(value)) {
    return new PropRef(value.__path)
  }
  // toArray(), concat(toArray()), and materialize() must be used as direct
  // select fields, not inside expressions
  if (
    value &&
    typeof value === `object` &&
    (value.__brand === `ToArrayWrapper` ||
      value.__brand === `ConcatToArrayWrapper` ||
      value.__brand === `CaseWhenWrapper` ||
      value.__brand === `MaterializeWrapper`)
  ) {
    const name =
      value.__brand === `ToArrayWrapper`
        ? `toArray()`
        : value.__brand === `ConcatToArrayWrapper`
          ? `concat(toArray())`
          : value.__brand === `CaseWhenWrapper`
            ? `caseWhen()`
            : `materialize()`
    throw new Error(
      `${name} cannot be used inside expressions (e.g., coalesce(), eq(), not()). ` +
        `Use ${name} directly as a select field value instead.`,
    )
  }
  // If it's already an Expression (Func, Ref, Value) or Agg, return it directly
  if (
    value &&
    typeof value === `object` &&
    `type` in value &&
    (value.type === `func` ||
      value.type === `ref` ||
      value.type === `val` ||
      value.type === `agg`)
  ) {
    return value
  }
  return new Value(value)
}

/**
 * Type guard to check if a value is a RefProxy