Appropriate approach for better performance. SQL vs transform?

The SQL approach is free.
The Script Transform approach requires loading up the Jython interpreter. It will be slower.