A 45-year-old man presents with sudden onset severe right loin to groin pain, haematuria and restlessness. He is afebrile and haemodynamically stable. The clinical picture is typical of renal colic. What is the most appropriate initial analgesic management in the emergency department?