You are the administrator supporting a client application developer. She submits a specification suggesting the need for back-end processing for her front-end consumption. This suggest that you create a:
Answer – Stored Procedure
(Stored procedures are compiled code usually optimized to deliver a dataset as the result of a client request, thus optimizing processing speed and minimizing network traffic while providing the best possible security controls.)