JSONB support

[beautyfree]

I get error cannot assign to field \"1\" of column \"content\" because its type jsonb is not a composite type when i try to use jsonb field of postgresql database

related: SoftwareBrothers/adminjs#1690

[roma-glushko]

Have got the same error when trying to use key-value property type for a JSONB field.

What seems to help me is to use this before hook to convert the property value as a JSON string:

const encodePropertyValue = async (request) => {
        if (request.payload) {
            const payload = request.payload
            const propertyValueObject = flat.get(payload, property)

            request.payload = {
                ...flat.filterOutParams(payload, [property]),
                [property]: propertyValueObject ? JSON.stringify(propertyValueObject) : '{}',
            }
        }

        return request;
    }

actions: {
            edit: {
                before: [encodePropertyValue],
            },
            new: {
                before: [encodePropertyValue],
            },
        },