Custom jsonb wrapper for Drizzle ORM when used with Postgresql

to-jsonb.ts

import { SQL, sql } from 'drizzle-orm';

/**
 * Converts a raw object or array to a jsonb object for postgres
 *
 * @export
 * @template T
 * @param {(T | T[])} raw
 * @return {*}  {SQL<unknown>}
 *
 * Usage:
 * ```typescript
 * import { db } from '<your-drizzle-client>';
 * import * as schema from '<your-schemas>';
 *
 * await db
      .insert(schema.events)
      .values({
        messageLogs: toJsonb([
          {
            message: "Some message",
            createdAt: new Date().toISOString(),
          }
        ])
      })
 * ```
 */
export function toJsonb<T>(raw: T | T[]): SQL<unknown> {
  const convert = (
    value: undefined | null | string | number | bigint | boolean | object,
  ): string | null => {
    if (value === undefined) return `""`;

    if (value === null) return null;

    if (typeof value === 'string') return `"${value}"`;

    if (
      typeof value === 'number' ||
      typeof value === 'bigint' ||
      typeof value === 'boolean'
    ) {
      return `${value}`;
    }

    if (Array.isArray(value)) {
      return `[${value.map((t) => {
        return convert(t);
      })}]`;
    }

    if (typeof value === 'object') {
      let objElements = '';
      Object.keys(value as object).forEach((i) => {
        objElements += `"${i}": ${convert(value![i])},`;
      });
      return `{${objElements.slice(0, -1)}}`;
    }

    throw new Error('Invalid data type for jsonb');
  };

  if (Array.isArray(raw)) {
    return sql.raw(`'${convert(raw)}'::jsonb`);
  }

  if (typeof raw === 'object') {
    return sql.raw(`'${convert(raw)}'::jsonb`);
  }

  throw new Error('Invalid data type for jsonb');
}

should we take care of escaping here? like "'" to "''"