or use the escape syntax which will work against any DB:

“SELECT * FROM Staff WHERE {d'2002-10-23'} < HiredDate < {d'2002-10-29'}”