Something I use all the time to handle applications which might have multiple instances opened at once. For example, web browsers.
Press CMD-TAB to bring up the list of opened applications and then pressing UP or DOWN over a selected application to show the opened instances. After that use LEFT or RIGHT to select the instance you want to show.
Total agree and I use query builders all the time. (Yours definitely looks nice.) I was curious though how others might of handled these issues when using libraries like the one posted here which is just raw sql.
I'm a fan of using raw sql like this but curious if anyone has solved deduplicating common statements and dynamic queries in a good way.
For example:
1) Imagine lots of queries having to show the results in the context of a user and therefore use the same JOIN and WHERE clause all over. Not being DRY, this breaks down when having to change the clause at all.
2) Imagine a reporting page that allows for filtering and ordering by different columns and therefore need some way to compose the final sql.