SQL Theory & How-To is an article that gives the answer to the two questions ie- how to Create complex, powerful, queries to take advantage of your table schemas and how to build complex queries on the fly. For this he gives some examples and codes for easy understanding. The author gives some more sites for reference. The author concludes that in the grand scheme of things, users want not only more customization but also better search capability.