New MySQL beta was released recently. MySQL 5 will have stroed procedures, triggers and views. Subqueries are available since somewhere in 4.1 series. I'm wondering how will this change performance... I guess I need to wait until final release.
There's an zdnet article about this. Changelog is available on MySQL site.