I think the answer will be almost any transformation.
You can for sure do:
- load text file into text file (various formats)
- load text file (csv, xml...) into table (several databases including most common)
- copy tables between databases
- DDL and DML
- vendor dependant SQL (such as PL/SQL)
- transformations from source to target
I think the problem with scriptella is not what you can do but how fast you can do it, that means performance