Code compilation isn't much of an issue in my realm. However, if a user runs a query that joins two or more billion row tables using a non-indexed expression and a nested loop hint, they can pack up and leave for the weekend.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho