Hi,
After a little chat with Dries on #drupal :
The plan is to drop MySQL 4.0 support in Drupal 6.0 (note that free
support already ended for this version of MySQL).
This will allow us to use more ANSI SQL constructs like subqueries.
Life is beautiful.
Regards
NK