I previously asked this question about creating an algorithm for joining records from multiple databases, and since then, I have built a rudimentary version of it (which doesn’t allow for inter database table associations to keep it simple for the moment), and now I am trying to test it. So far, I have tested doing joins, custom columns, where and having clauses, order by’s, and limits, and they seem to all work perfectly. But, most of my applications that do database queries are quite simple, with just a few joins, a couple of custom columns, and a few other bits and pieces of information, so I was wondering if there was a nice series of really complex queries i could pass through it to ensure that it can really do everything that would be needed by 99% of applications? I know its a bit broad, but even just a handful of complicated queries would be fantastic to test it out.
4