Best language for data transformation (ETL)

What is the best end-user language开发者_如何学运维 for data transformation (ETL), ideally something that can run in a JVM (with a LGPL like license).

With end-user meaning users who are IT related but might not be experts in OO or like.

You can try CloverETL. It is Java based ETL tool. You can either define transformation through its visual designer or handcode directly in XML files that are used to store data about transformations.

It also uses its own transformation language - CTL that is used inside transformation components. You do not need to be expert in OOP to use it.

Rust is the best language. In fact, companies can now evolve from ETL to STL or Stream, Transform and Load with a technology like InfinyOn Cloud. InfinyOn Cloud is a fully managed Fluvio service. This solution brief explains how the Financial Services industry is leveraging this tech: https://www.infinyon.com/resources/real-time-data-trasformation/