(prior-art)=
(research)=
# 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


[AirbyteCatalog]: https://docs.airbyte.com/understanding-airbyte/beginners-guide-to-catalog
[An introduction and overview about Singer]: https://github.com/daq-tools/lorrystream/blob/main/doc/singer/intro.md
[AWS DMS source filter rules]: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.Filters.html
[AWS DMS table selection and transformation rules]: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.html
[Meltano Inline Data Mapping]: https://docs.meltano.com/guide/mappers/
[Meltano Inline Stream Maps]: https://sdk.meltano.com/en/latest/stream_maps.html
[PipelineWise Transformations]: https://transferwise.github.io/pipelinewise/user_guide/transformations.html
[Singer Transformer]: https://github.com/singer-io/singer-python/blob/master/singer/transform.py
[singer-transform]: https://github.com/dkarzon/singer-transform