When we design databases, invariably, normally we design the queries at the same time.
Well this may be true to an extent well implemented models have the ability to answer questions (queries) the original designer never thought of or that were not important at the time.
As for the rest - invest in a good graphical query builder (or write one if the existing choices are insufficient).
