What do I regard when working with SQL Script Procedures in Code-pushdown?

The first point that needs to be considered is client handling when applying any aggregation on data. The second point is to take care of explicit functionality of LUW concept since there is no explicit functionality of LUW concept in SAP HANA. The third point is to take care of implicit locking since there is no implicit locking mechanism when working with SQL scripting on SAP HANA database.