I didn't mean to imply that compilation never makes sense, I'm only pointing out that it isn't always the fastest way of executing a query In situations where

I didn't mean to imply that compilation never makes sense, I'm only pointing out that it isn't always the fastest way of executing a query In situations where you have a limited number of queries and these are used repeatedly then some kind of cache for the complied code will be able to amortise the cost of compilation. I certainly agree that a situation where an analyst enters SQL manually is a weird niche and not common. However most applications can dynamically construct queries on behalf of users and so getting a good hit rate on your cache of precompiled queries isn't a certainty.