Research and Prior Art

Toolbox

• jq, jsonpointer, jmespath, funcy, morph, boltons, toolz

• json-spec, jdata, jolt, json-document-transforms, transon

Prior Art I

• An introduction and overview about Singer

• Singer Transformer

• PipelineWise Transformations

• singer-transform

• Meltano Inline Data Mapping

• Meltano Inline Stream Maps

• AirbyteCatalog

• AWS DMS source filter rules

• AWS DMS table selection and transformation rules

Prior Art II

• https://pypi.org/project/json-spec/

• https://pypi.org/project/transon/

• https://pypi.org/project/jdata/

• https://github.com/microsoft/json-document-transforms

• https://github.com/Microsoft/json-document-transforms/wiki

• https://github.com/bazaarvoice/jolt

• https://stackoverflow.com/questions/76303733/exploring-jolt-functions-for-json-to-json-transformations-an-overview

• https://github.com/microsoft/JsonToJsonMapper

• https://pypi.org/project/jdt/

• https://github.com/videntity/json-data-tools

• https://github.com/datavis-tech/json-templates

• https://github.com/google/jsonnet

• https://github.com/jsonata-js/jsonata

• https://github.com/pacifica/python-jsonpath2

• https://github.com/reagento/adaptix

• https://blog.panoply.io/best-data-transformation-tools

Prior Art III

• https://github.com/cloud-custodian/cel-python

• https://github.com/MacHu-GWU/learn_polars-project

• https://github.com/MacHu-GWU/jsonpolars-project

• https://github.com/MacHu-GWU/polars_writer-project

• https://github.com/MacHu-GWU/aws_sdk_polars-project

• https://github.com/raw-labs/snapi

• https://github.com/danthedeckie/simpleeval

• https://github.com/mitghi/jetro

• https://github.com/mahmoud/glom

• https://github.com/hi-primus/optimus

• https://github.com/hi-primus/bumblebee