Creating SQL for lists

I am working on a project which creates many lists. The lists use similar queries, but a number of them hae their own where clauses. To help I have broken it down to three levels, lists, list types, and base queries. There are only a few base queries from which all the lists are created. There are more list types with each one using one of the base queries. Some list types need to add a where clause to the query it uses. Finally, there are the lists themselves, which in some cases, usually based on the type, need there own where clause. I am looking for ideas and input at how to design the system.

Here a few ideas I have thought of.

1. Split the queries into the three levels mentioned, and have a function create the query at runtime.
2. Split the queries into the three levels mentioned, but store the entire query in the list table when the record is entered. In other words, get the base query and where clause from the list_type and base_query tables, and add a possible where clause and store it in the lists table.
3. Have three levels, but leave each as its own query, and when needed use a query with a sub-query and sub-sub-query.

Any thoughts,
Brian Received on Tue Dec 26 2000 - 11:40:22 CST