I should add that I'm asking this question due to what I believe is either a gap in the documentation or a bug in DSS. The limitations say that SQL Query recipes with multiple recipes aren't supported - implying that those that have single statements should work. However, I cannot get this to work with a virtualized dataset.
Additional limitations when running a SQL pipeline:
The SQL datasets must be part of the same database connection. SQL script recipes, SQL query recipes with multiple statements, or the TopN visual recipes with rejected output tables are not currently supported.