migrating table fields

If a Xano user changes the name of a table field, they will lose all the data in that field. Not good.

I goofed when I set up a table and used a name with a dash where I should have used an underscore. Yeah I know... I have 'Main-address' instead of Main_address or mainAddress etc.

I created a function to migrate each address to the new column. I can run again and again but...

The answer to this is probably staring me in the face but in looking at all the Xano looping functions, I didn't see a way to process 9,600 records within this one function.

Maybe create a second function querying the table looking for a default value and 'if found' invoke the first function? With JavaScript it would be pretty easy to loop through these but in Xano it's not clear how to do this.

I could download the table, change the header and upload the table again...

This must have been addressed before by someone?