Drizzle Utility Functions

drizzle-utils.ts

import { type AnyColumn, type SQL, sql } from 'drizzle-orm'

/**
 * The Coalesce function evaluates the arguments in the specified order
 * and always returns the first non-null value from the argument list.
 *
 * @template T - The type of the value being coalesced.
 * @param args - The value to be coalesced.
 * @returns - The SQL expression representing the coalesced value.
 */
export const coalesce = <T>(
  ...args: (AnyColumn | SQL.Aliased<T> | SQL<T> | T)[]
): SQL<T | null> => {
  const sqlArgs = args.map((arg) => sql`${arg}`)
  return sql`coalesce(${sql.join(sqlArgs, sql.raw(','))})`
}