I'm creating a filter and there are quite a few tables that I need to consider. I think the problem is that for some of the things I'm filtering I do both a EXISTS and NOT EXISTS subquery on the same ...

The "pure SQL" part is important. There have been attempts to get Doom-like games up and running in the past. The excellent ...