Use custom function to Transform input/ insert/ update and Parse read using custom function before running sql query

[ganeshkbhat]

Where and which file do I specify and customize to my own function to write the file in a specific format of csv. I basically want to Use custom function to Transform input/ insert/ update and Parse read using custom function before running sql search query.

Say for example, put the entire csv or json file as a encrypt before putting it on to a file after the insert statement and then parse it back again to text before using it with the sql statement.

I see that json and csv have different parsers.

[hw2499]

Your requirements are actually an ETL process. You can learn about etl engine https://github.com/hw2499/etl-engine