In a custom module I'm using hook_views_query_alter() to add a number of complex WHERE expressions that Views UI can't handle. One of them involves comparing Date fields related to temporary job ...