Hey @lukejamison - if you're still looking into this, our Office Hours could be a good format for exploring SQL syntax strategies for this use case, and get ideas in a group including Retool Community Support Engineers and other experts from the community 
If you do join an Office Hours session, could then share learnings back here as I'm sure it could be useful for others searching for how to build similar functionality!