feat: JSON type coercion

[nasdf]

Relevant issue(s)

Resolves #3097

Description

This PR fixes JSON type coercion and makes it much simpler to filter, create, and update JSON fields.

Tasks

• [x] I made sure the code is well commented, particularly hard-to-understand areas.
• [x] I made sure the repository-held documentation is changed accordingly.
• [x] I made sure the pull request title adheres to the conventional commit style (the subset used in the project can be found in tools/configs/chglog/config.yml).
• [x] I made sure to discuss its limitations such as threats to validity, vulnerability to mistake and misuse, robustness to invalidation of assumptions, resource requirements, ...

How has this been tested?

Added / updated unit and integration tests.

Specify the platform(s) on which this was tested:

• MacOS