As the byline of this blog can attest, I was once a ColdFusion developer. In fact, I wrote ColdFusion professionally for about seven years, which is long enough to learn all of its dirty secrets and come to appreciate its (few) strengths.
Here’s a controversial take: ColdFusion has the best SQL interface for developers, period.
Having used SQL interfaces in ColdFusion, PHP, Python, Ruby (Rails), and Java (8), I can say with some confidence that, at least to my taste, ColdFusion’s implementation of the modest SQL query is far and away the most elegant. Prove me wrong. Or, wait, read the rest of this thing first.