cube2222 / octosql

OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Mozilla Public License 2.0
4.75k stars 202 forks source link

More transform examples and functionality? #274

Open kuzhao opened 2 years ago

kuzhao commented 2 years ago

I see great potential of PoC/experimental data row transformation in this brief but universal SQL client written in golang.

May I know if we can add more data transformation CLI examples into README.md? I (and maybe many others) would much enjoy examples like the capability of generating new fields on the fly and on demand, i.e. adding a geoCoordinate field from the address field for each row. It's okay if such functionality requires plugin/custom golang function pkg. People from the community with the interest will help.