Custom MikroORM type for Postgres 'jsonb[]'

JsonArrayType.ts

import { Type, ValidationError } from '@mikro-orm/core';

export default class JsonArrayType extends Type<Record<string, any>[], string> {
  convertToDatabaseValue(value: Record<string, any>[]): string {
    if (!Array.isArray(value)) {
      throw ValidationError.invalidType(JsonArrayType, value, 'JS');
    }

    const resultValue = JSON.stringify(value)
      .replace(/"/g, '\\"')
      .replace(/({.*?})/g, '"$&"')
      .replace(/^\[/, '{')
      .replace(/\]$/, '}');

    return resultValue;
  }

  convertToJSValue(value: Record<string, any>[] | string): Record<string, any>[] {
    if (typeof value !== 'string') {
      return value;
    }

    const preparedValue = value
      .replace(/^\{/, '[')
      .replace(/\}$/, ']')
      .replace(/"({.*?})"/g, '$&')
      .replace(/\\\\"/, '"');

    return JSON.parse(preparedValue) as Record<string, any>[];
  }
}