Knex JSON parser to/from SQLite

bruh.ts

function parseToDatabaseJson<T>(obj: Record<string, unknown>): T;
function parseToDatabaseJson<T>(obj: Record<string, unknown>): string | T | Record<string, unknown> {
  if (obj._tableName) delete obj._tableName;
  if (Object.prototype.toString.call(obj) === "[object Array]") {
    return JSON.stringify(obj);
  } else if (typeof obj === "object") {
    const newObj: Record<string, unknown> = {};
    for (const key in obj) {
      // eslint-disable-next-line @typescript-eslint/naming-convention
      const type_ = Object.prototype.toString.call(obj[key]);
      if (["[object Array]", "[object Object]"].includes(type_)) {
        newObj[key] = JSON.stringify(obj[key]);
        continue;
      }
      newObj[key] = obj[key];
    }
    return newObj;
  } else {
    return obj;
  }
}

function parseFromDatabaseJson<T>(obj: T): T {
  if (typeof obj === "string") {
    try {
      if (Number.parseInt(obj)) {
        return obj;
      }
      obj = JSON.parse(obj) || obj;
    } catch {
      return obj;
    }
  }

  if ((obj === undefined || obj === null) && obj !== false) {
    // eslint-disable-next-line unicorn/no-null
    return null as typeof obj;
  }

  if (Array.isArray(obj)) {
    return obj.map((item) => {
      // eslint-disable-next-line @typescript-eslint/no-unsafe-return
      return parseFromDatabaseJson(item);
    }) as T;
  } else if (typeof obj === "object") {
    const newObj: Record<string, unknown> = {};
    for (const key in obj) {
      newObj[key] = parseFromDatabaseJson(obj[key]);
    }
    return newObj as T;
  } else {
    return obj;
  }
}