The good folks at the SharePoint Product Group have announced that Windows SharePoint Services v3 and SharePoint Server 2007 are now supported on SQL Server 2008.  SP1 of the SharePoint product is required for this support.

New documentation describing the support for SQL Server 2008 has been released:

Have fun with SQL Server 2008!