I think the SQLCreator should be able to do that.

This transformer acts as a reader, based on a SQL statement.

The statement will be passed to the database and the result will be read into FME.

Hope this helps.

Thanks Erik, that works great. Make sure to specify Automatic or Manaul for user attributes for anything consuming the data however, since FME does not pre-parse the return types for Dynamic with this type of call.