Is it possible to have YQL generate HTML output directly (or via "execute"). If so, it could generate a web page directly by passing the REST query.
Not today, although you could output XHTML (or at least well formed HTML with all the closing tags) as a single result in the YQL response and simply extract and insert it into a page with some client side helper code.
Jonathan