What I'm trying to accomplish, is selecting all entries (they are events with a start/end date as custom fields) from a given section, which overlap in any way with a passed-in query start/end date.
It is probably easier to simply supply the raw query that works, and perhaps someone could point me in the direction of documentation that could help me.
SELECT * FROM craft_content WHERE ! ( field_eventStartDate > @queryStartDate AND field_eventStartDate > @queryEndDate) AND ! ( field_eventEndDate < @queryStartDate AND field_eventEndDate < @queryEndDate )