[SPARK-3176] Implement 'POWER', 'ABS and 'LAST' for sql

Add support for the mathematical function "POWER" and "ABS" and the analytic function "last" to return a subset of the rows satisfying a query within spark sql. Test-cases included.
It would be good to investigate what other systems do in this case or if the SQL standard says something.