Scripting up analysis
Analyze with interval or begins/ends
Escape some SQL
Yet another query they made harder than it had to be