Here's another one that would help:
IF we use MySQL CURDATE() function it gets wrapped in single quotes 'string'.
The Query Editor sets the value as 'CURDATE()' rather than without the single quote as it should be.
Maybe a library of Functions that should not be wrapped as stings?
SELECT bs_events.id, bs_events.eventDate, Count(bs_reservations.eventID) AS CounteventID FROM bs_events LEFT OUTER JOIN bs_reservations ON bs_events.id = bs_reservations.eventID WHERE bs_reservations.eventID = ? AND bs_events.eventDate > CURDATE() ORDER BY bs_events.eventDate