SQL queries that work for all db types

Instead of having different SQL queries for different db types (mysql/pgsql) as this module does now to handle date/time values, I'd rather use one query that will work on any db type. The patch attached should work in theory, but I have no pgsql testing environment at the moment. I'm also curious if anyone sees any disadvantages to this approach. Tests, reviews and opinions are very welcome.