Is there any way to express and add to custom queries, queries like:

1. Any project that has subprojects
2. Any project than is NOT a subproject
3. Joined projects that have subprojects
4. Joined projects that are not subproject themselves
5. Joined projects that have subprojects and are not subproject themselves