Big SQL statements get away from you
Quote
have like a 40 or 50 line long SQL statement with multiple subselects, this kind of thing, it really gets difficult to understand what's happening.
Episode 272: Is this Y'all? (episode page, opens in a new tab) 00:16:50 (play audio from this timestamp, opens in a new tab)
Voice-matched
Summary
A 40- or 50-line SQL statement with multiple subselects becomes really hard to understand, which is how Dave's aggregator feed-selection query went wrong (an ORDER BY on an unindexed column). At that size you need help reading it, whether an agent or at least a syntax parser.
Not in the audio. The 'you really need an agent, or at least a syntax parser' line is in an Unknown-labeled cue just before this, so it's in the summary as context, not as part of the quote.