mpellegrini · August 28, 2024 21:27
diff --git a/drizzle-utils.ts b/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(','))})`
 }
	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(','))})`
	}