Use pandas if you want advanced analytics, visualization, or ml.
Use SQL if you need to move data around.
Use SQL if you need to move data around.
And in the end save processed data in aws s3 in another format like iceberg or whatever
In pandas a lot of these are one-liners that are impossible in sql (depends on what sql engine you have?)